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?

[SQL] BLOBs vs BYTEA

2005-01-31 Thread Sam Adams
Hi, Apologies if I've already sent a post asking this but I'm not sure if it actually went through last time as it doesn't seem to be in my sent items box. 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

[SQL] BLOBS AND FILES

2003-09-29 Thread marcello miorelli
Hello folks, How can we insert a file into a blob field in a table? Could someone please explain something regarding this? It is ver important. tia marcello miorelli __ Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi alleg

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

[SQL] Blobs

2003-07-11 Thread sri devi
hi   we have to download url files in to oracle using BLOBs how to create oracle table stucture how to write the query,we are using oracle9i,and javaswings,reply me to this id. [EMAIL PROTECTED]     thanking you sridevi SMS using the Yahoo! Mess

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

[SQL] Blobs with perl

2003-06-17 Thread cristi
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)? Thanks! ---(end of broadcast)--- TIP 9: the planner will ignore your des

[SQL] blobs and small binary objects

2001-01-24 Thread David Wall
I'm new to Postgresql and am trying to figure out how I'd store Serializable objects, byte arrays and potentially large binary objects. JDBC has APIs for getObject(), getBytes() and getBlob(), but how do I define those attributes inside a table? I don't see the typical BYTE or BINARY or BLOB typ

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

[SQL] BLOBs

2000-07-27 Thread Bernie Huang
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 Postgres. Could anyone points me an URL where I can look it up? Thanks. -Berni