I've posted about this before in regards to the PictureDatabase example, as in postgres though you can save the picture, it dosn't retreive. I had asked someone to test it, though no-one appears to have had the time.
This driver is pretty critical to my medical records project, as I used to be able to save images of skin lesions/Xrays, diagrams, line drawings, back to my database and now can save but the retreived image is chopped losing a number of bytes from the end and won't display. I want to be able to present my program at a medical computing conference in July as a prototype version reasonably fully complete by then, so I need it to work. All this work of mine by the way will be open-sourced if I can get it to a state of functional completeness. So I asked my mate Ian Haywood, who is quite an accomplished programmer and far far brighter and more computer literate than I by sending him this message > If you updated the latest gambas - you don't need my program to test this - > just change a couple of lines of code in the picturedatabase sample program > to use postgres and you will see the error. Maybe, it is only on my machine. and this was his reply: ================================================= I can reproduce this. It is only postgres, only gambas, and only with the BYTEA type, TEXT doesn't do this (but you can't put a png in text, at least not easily). So, it's definitely a bug in the postgres drivers for gambas. Has this been reported to the gambas list? There is a workaround: convert the png to text and store, then convert back on reading. this works b/c our images are small, but big images will waste space and cause slowness. this solution is fairly easy to whip up, I can do this if the underlying bug can't be fixed and we want this functionality for 10240cc[conference]. Ian ================================================= So I wondered if somone could test the postgres driver again, just to make sure it is not a library on my machine, although I know Ian runs a debian flavour so probably not. Regards Richard
--- Begin Message ---On Thursday 05 February 2009 08:19:36 you wrote: > If you updated the latest gambas - you don't need my program to test this - > just change a couple of lines of code in the picturedatabase sample program > to use postgres and you will see the error. Maybe, it is only on my machine. I can reproduce this. It is only postgres, only gambas, and only with the BYTEA type, TEXT doesn't do this (but you can't put a png in text, at least not easily). So, it's definitely a bug in the postgres drivers for gambas. Has this been reported to the gambas list? There is a workaround: convert the png to text and store, then convert back on reading. this works b/c our images are small, but big images will waste space and cause slowness. this solution is fairly easy to whip up, I can do this if the underlying bug can't be fixed and we want this functionality for 10240cc. I'll leave this for now and start researching the khtml control Ian
--- End Message ---
------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
_______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user