Hello
I am going to write an application tht writes big amounts of plain text into a
database.
I thought of using the text type for this, but I don't know if it has a maxlenght, and
given that these will be very long texts I started wondered if these would have to be
blobs... but they aren't b
> I am going to write an application tht writes big amounts of plain text
into a database.
What kind of data are those? Articles? News/mail messages? Other?
> I thought of using the text type for this, but I don't know if it has a
maxlenght, and given that these will be very long texts I s
On Tue, 18 Apr 2000, Lincoln Yeoh wrote:
> At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
> >On Mon, 17 Apr 2000, Adam Ruth wrote:
> >
> >> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
> >> > 6.5.3 tables are stored as single files, so better not go down that path
>
At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
>On Mon, 17 Apr 2000, Adam Ruth wrote:
>
>> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
>> > 6.5.3 tables are stored as single files, so better not go down that path
>> :).
>>
>> I'm using 6.5.2 and it will split a tabl
On Mon, Apr 17, 2000 at 06:12:37PM +0930, Stephen Davies wrote:
> G'day.
>
> I do a lot of work with the BASIS textual/multi-media RDBMS package and
> run into this question all the time.
>
> There is one pretty basic answer:
>
> If you leave BLOBS lying around in the file system - particularl
G'day.
I do a lot of work with the BASIS textual/multi-media RDBMS package and
run into this question all the time.
There is one pretty basic answer:
If you leave BLOBS lying around in the file system - particularly if
it is a Novell etc file system - people move them and the links get
broke
How do I start this? There are so many different ways to look at this
question. Do I save files inside the database, or do I simply use the database
as a tool to query information about a given file, it's properties, etc.
Instead of making general statements, let me pick specific examples. Let
-> It seems that the issue with large objects is "Why do you want the info in a
-> database?"
To organize them, of course.
-> It seems to me that the point of a database is its ability to order and
-> relate data. If you want to retrieve the "large-ish text files" based on
-> their content then
> A while ago it was being held that the Postgres large object data type
> was too new and not sufficiently tested and mature to be used in a
> production environment. I am about to deploy a little database that
> involves storing large-ish text files (20-500k) which could be either done
> as larg
lt;[EMAIL PROTECTED]>, Frank Joerdens <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: [GENERAL] To BLOB Or Not To BLOB
Well I'm currently using the file system for large files. However because
of that I can see a few reasons why people might want to use Postgresql to
handle th
Well I'm currently using the file system for large files. However because
of that I can see a few reasons why people might want to use Postgresql to
handle them. Others can probably mention more.
Using Pg to handle large stuff makes more consistent overall and it's
easier for you to handle except
Hi,
It seems that the issue with large objects is "Why do you want the info in a
database?"
It seems to me that the point of a database is its ability to order and
relate data. If you want to retrieve the "large-ish text files" based on
their content then I think you need to have the files in the
On Sun, 16 Apr 2000, you wrote:
> There are some programs out there to dump large objects and I've been playing
> with one. It's worked well so far. You can get it at
> ftp://ftp2.zf.jcu.cz/zakkr/pg/
>
> ---
>
> file not found...
Correction:
ftp://ftp2.zf.jcu.cz/users/zakkr/pg/
On Sun, 16 Apr 2000, Frank Joerdens wrote:
> A while ago it was being held that the Postgres large object data type
> was too new and not sufficiently tested and mature to be used in a
> production environment. I am about to deploy a little database that
> involves storing large-ish text files (20
A while ago it was being held that the Postgres large object data type
was too new and not sufficiently tested and mature to be used in a
production environment. I am about to deploy a little database that
involves storing large-ish text files (20-500k) which could be either done
as large objects
15 matches
Mail list logo
