Search Postgresql Archives

Re: Image in postgresql 7.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

like Berend, I also store my PDFs in text columns, but I usually use base64 encoding. AFAICS this has the big advantage versus BLOBs that I do not need to care about backup issues. The disadvantage of course is a bigger database (encoding inflates about 30%), so if you have lots and lots of pictures, you might want to use an other method. Another (small) disadvantage is that one has to encode/decode the binary files before storing/after retreiving.

Regards, Frank.



On Wed, 18 Jan 2006 05:13:22 -0800 (PST) "Peerri (sent by Nabble.com)" <lists@xxxxxxxxxx> thought long, then sat down and wrote:

> 
> Please help me!!!
> I'm with problems to record images in database in field type bytea.
> I'm using visual basic 6.0 and object ado stream to convert binary.
> 
> They say me if another way exists to record the images in the data base.
> 
> Thanks!!
> [:-)
> --
> View this message in context: http://www.nabble.com/Image-in-postgresql-7.3-t944227.html#a2446227
> Sent from the PostgreSQL - general forum at Nabble.com.
> 


-- 
Frank Finner

Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606    Mail: frank.finner@xxxxxxxxxxx
Telefax: 0271 231 8608    Web:  http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF  6E6A A74E 67E4 E788 2651

Attachment: pgpgbFx5CxVyA.pgp
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux