LOB in PostgreSQL

matteogd · #1 (**permalink**) 07-07-03, 09:59

Hello guys,
I'm developing a web site and I'm evaluating PostgreSQL as well as other Databases. The purpose of the web site is to share big files, is PostgreSQL good in storing LOBs? I'm thinking also about storing only the pointer to the physical file rather than the file itself in the database.
Regards

Matteo

eperich · #2 (**permalink**) 07-09-03, 17:21

Sure it is

I knwo from a DB that stores BLOBS ( 2 TB)

and there is no problem

karim2k · #3 (**permalink**) 07-11-03, 10:08

I've used to store files in an educational web site , so I'll advice you to store in the database the info about the files, not the files themselves, I'll recommand you to put them in an ftp , or via a htpp access , It could be like this
=> the fils is here
/mysite/myfile.xxx

=> the table

Filename : myfile.xxx
category :xxxxx (where the cat could refer to a directory for example)
owner : the man who sold the world
size : 1024 Kb
seen (or downloaded) : 45454 times
description : nothing else a matters hunger file

Hope You understand me