Re: [GENERAL] Storing jpgs

2004-04-08 Thread Greg Stark
Marek Lewczuk <[EMAIL PROTECTED]> writes: > On Apr 5, 2004, at 2:03 PM, Gavin M. Roy wrote: > > > I'm one for using base64 encoded text in a text field. It's easy to > > deal with queries, it's easy to deal with spitting out images, and > > it's easy to back up. Others do it differently, there

Re: [GENERAL] Storing jpgs

2004-04-06 Thread Joe Lester
Would anyone have some example code they could share using libpq to encode an image into a text field? Right now, I'm converting my image into a hexadecimal string representation in my SQL statement. I'm sure there must be a better (faster) way. The hex encodeing/decoding slows things down for

Re: [GENERAL] Storing jpgs

2004-04-05 Thread scott.marlowe
On Mon, 5 Apr 2004, C G wrote: > Dear All, > > What's the best way to store jpgs in postgresql to use in a web page? > > I tried to use large objects, but how would you extract them from a table to > be viewed in a web-page without having to write them to a scratch file > somewhere first? The

Re: [GENERAL] Storing jpgs

2004-04-05 Thread Rod K
004 12:20 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Storing jpgs > > > Dear All, > > What's the best way to store jpgs in postgresql to use in a web page? > > I tried to use large objects, but how would you extract them from > a table to > be viewed in a

Re: [GENERAL] Storing jpgs

2004-04-05 Thread Bob . Henkel
| | To: [EMAIL PROTECTED] | | cc: | | Su

[GENERAL] Storing jpgs

2004-04-05 Thread C G
Dear All, What's the best way to store jpgs in postgresql to use in a web page? I tried to use large objects, but how would you extract them from a table to be viewed in a web-page without having to write them to a scratch file somewhere first? Thanks Colin __