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

From: dustin sallings <dustin(at)spy(dot)net>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] postgreSQL for storing a database of documents
Date: 1999-05-05 06:08:12
Message-ID: Pine.NEB.4.10.9905042304500.564-100000@mobile
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 played with BLOBs, but I didn't like how they were stored, or
that they didn't back up, so I went with Base64 encoded data which I split
up to store. It's pretty damned quick, and I get a lot more control.

--
Principal Member Technical Staff, beyond.com The world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message darold 1999-05-05 07:16:28 Re: [GENERAL] postgreSQL for storing a database of documents
Previous Message dustin sallings 1999-05-05 05:57:07 Re: [GENERAL] postgreSQL for storing a database of documents