use BLOBS or use pointers to files on the filesystem?

Поиск
Список
Период
Сортировка
От Travis Bear
Тема use BLOBS or use pointers to files on the filesystem?
Дата
Msg-id dMSQ7.21755$wL4.48308@rwcrnsc51
обсуждение исходный текст
Ответы Re: use BLOBS or use pointers to files on the filesystem?  (Frank Joerdens <frank@archi-me-des.de>)
Re: use BLOBS or use pointers to files on the filesystem?  (Jason Earl <jason.earl@simplot.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I'm kind of a database newbie in general,  so be nice to me if this
is a bonehead question.  I am building a java servlet based web
application to manage photos and images.  My first thougth has been
to store the images as BLOBs in the database, but I read one user say
that you're better off not using BLOBs.  Instead, he says, store your
large data objects as files on the filesystem, and just use the
database to store the path to the file and any file-related meta
data.

I wasn't sure what to think of this, so I was hoping to get some
other ideas and opinions.  I expect to accumulate 1-2 gigs of new
data per year, max, with average image size being 700k.

Also, if I've missed any obvious documentation on this issue please
feel free to send it my way.

Thanks!


Travis

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBP9vKBIzo/FCjIeEQLffgCePrTcI3ugWC9NhdRT12Pt1XFnW0gAoLl3
t8HQbiGAOJt6jDhZNZlk+2GL
=N3bL
-----END PGP SIGNATURE-----




В списке pgsql-general по дате отправления:

Предыдущее
От: "Mourad EL HADJ MIMOUNE"
Дата:
Сообщение: Limit of sequence
Следующее
От: James Thornton
Дата:
Сообщение: Re: update returns 1, but no changes have been made