Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-05 Thread darold
Hi, Rigth now I have less than one thousand of gif/jpg around 6 to 15 ko each. I guess I can go upper :-)) regards, Gilles Darold Chris Bitmead wrote: > darold wrote: > > > I'm using Large Object to store images and displayed them on the fly. I never found > > any problems and it > > is very

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-05 Thread Michael Davis
Subject:Re: [GENERAL] postgreSQL for storing a database of documents On Tue, 4 May 1999, Mark Fleming wrote: // That a good solution, but now that XML is starting to break off it // kinda puts PostgreSQL users at a disadvantage. We have to have // static

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-05 Thread Michael Davis
] postgreSQL for storing a database of documents Ari Halberstadt wrote: > Raphael Finkel <[EMAIL PROTECTED]> wrote: > >Is PostgreSQL appropriate for a database of documents? I see several > >potential problems. > > > >

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-05 Thread Chris Bitmead
darold wrote: > I'm using Large Object to store images and displayed them on the fly. I never found > any problems and it > is very quiet. "When Postgre starts using large objects it is going to make a lot > of noise." ??? How many images are you storing? -- Chris Bitmead http://www.bigfoot.co

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-04 Thread darold
Hi, I'm using Large Object to store images and displayed them on the fly. I never found any problems and it is very quiet. "When Postgre starts using large objects it is going to make a lot of noise." ??? You can also generate XML on the fly or what you want with Perl or other CGI stuff, simply

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-04 Thread dustin sallings
On Wed, 5 May 1999, Chris Bitmead wrote: // > # 1. Tuples are limited to 8KB. I assume even the "text" type is limited // > # that way. But my documents may be longer than that. // > // > This isn't a problem, I store all of my photographs // > in postgres. // // How? I pla

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-04 Thread dustin sallings
On Tue, 4 May 1999, Mark Fleming wrote: // That a good solution, but now that XML is starting to break off it // kinda puts PostgreSQL users at a disadvantage. We have to have // static XML documents on on disk in order to use the format and have // external search engines to search for content

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-04 Thread Chris Bitmead
Dustin Sallings wrote: > > On Tue, 4 May 1999, Raphael Finkel wrote: > > # Is PostgreSQL appropriate for a database of documents? I see several > # potential problems. > # > # 1. Tuples are limited to 8KB. I assume even the "text" type is limited > # that way. But my documents may be longer

Re: [GENERAL] postgreSQL for storing a database of documents

1999-05-04 Thread Mark Fleming
Ari Halberstadt wrote: > Raphael Finkel <[EMAIL PROTECTED]> wrote: > >Is PostgreSQL appropriate for a database of documents? I see several > >potential problems. > > > >1. Tuples are limited to 8KB. I assume even the "text" type is limited that > >way. But my documents may be longer than th