----- Original Message ----- From: "Edwin Quijada" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 6:54 PM Subject: [GENERAL] Picture with Postgres and Delphi
> Hi !! Everybody > I am developing app using Delphi and I have a question: > I have to save pictures into my database. Each picture has 20 o 30k aprox. > What is the way more optimus? > That 's table will have 500000 records around. Somebody said the best way to > do that was encoder the picture to field bytea but I dont know about this. > Another way is save the path to the picture file but I dont like so much > because I need to write to disk by OS and have permission to write a > directory to OS. > What do u think?? You may choose between Bytea or large objects. I had some problems with bytea on earlier version of pg (7.2 I think), but last time I checked (7.3), all worked fine. However, I use large objects. The only disadvantage of large objects I see is that You can't dump them into textual dump. You must use binary dumps. Regards ! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
