Re: [SQL] BLOBs vs BYTEA

2005-02-01 Thread Karl Denninger
On Tue, Feb 01, 2005 at 10:04:45AM +0200, Achilleus Mantzios wrote: > O Dennis Sacks Ýãñáøå óôéò Jan 31, 2005 : > > > Sam Adams wrote: > > > > >Anyway, I was wondering which would be a better way to store a large > > >amount of files each a few megabytes in size. There could be hundreds of > > >t

Re: [SQL] BLOBs vs BYTEA

2005-01-31 Thread Achilleus Mantzios
O Dennis Sacks έγραψε στις Jan 31, 2005 : > Sam Adams wrote: > > >Anyway, I was wondering which would be a better way to store a large > >amount of files each a few megabytes in size. There could be hundreds of > >thousands of files altogether. If stored as BYTEAs this would put them > >all in a

Re: [SQL] BLOBs vs BYTEA

2005-01-31 Thread Dennis Sacks
Sam Adams wrote: Anyway, I was wondering which would be a better way to store a large amount of files each a few megabytes in size. There could be hundreds of thousands of files altogether. If stored as BYTEAs this would put them all in a single table. Would this effect performance considerablely?

Re: [SQL] Blobs

2003-07-12 Thread Rajesh Kumar Mallah
Sir Devi, This is PostgreSQL mailing List. If you need help porting applications from Oracle9i to PostgreSQL we might help. Or if you have generic SQL question not specific to any database we can also consider. for help in Oracle specific problems there may be more appropriate lists on the net

Re: [SQL] Blobs with perl

2003-06-17 Thread Michael A Nachbaur
On Tuesday 17 June 2003 02:00 am, cristi wrote: > I want to insert a picture in a table from an internet browser using a > script made in perl. > Has somebody a code example with this kind a problem (I need only a code > fragment)? I put album covers into a database table, primarily because I want

Re: [SQL] Blobs with perl

2003-06-17 Thread Rudi Starcevic
Hi, For not so big applications you could consider converting the binary image/file into text, using base64, then store the resulting text. For example I have an app. where each member may have one or two images on their account. So when the user upload's their image I base64 it and store the

Re: [SQL] Blobs with perl

2003-06-17 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 17 June 2003 02:00, cristi wrote: > I want to insert a picture in a table from an internet browser using a > script made in perl. > Has somebody a code example with this kind a problem (I need only a code > fragment)? > Despite PostgreSQL's

Re: [SQL] BLOBs

2000-07-28 Thread André Næss
- Original Message - From: "Bernie Huang" <[EMAIL PROTECTED]> > Hi, everyone, > > Browsing through the online manual, I didn't find anything related to > BLOBs, but I know there must be BLOBs since many people are asking about > it on the list and there is a pg_fetch_object() in PHP for