Re: Picture with Postgres and Delphi
От | Darko Prenosil |
---|---|
Тема | Re: Picture with Postgres and Delphi |
Дата | |
Msg-id | 003a01c37713$11c939b0$ae96bfd5@darko обсуждение исходный текст |
Ответ на | Picture with Postgres and Delphi ("Edwin Quijada" <listas_quijada@hotmail.com>) |
Ответы |
Re: Picture with Postgres and Delphi
|
Список | pgsql-general |
----- Original Message ----- From: "Edwin Quijada" <listas_quijada@hotmail.com> To: <pgsql-general@postgresql.org> 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 !
В списке pgsql-general по дате отправления: