images
Is it possible to save images in postgreSQL ??
If yes, and in the case of a web site using both postgrSQL and mod_perl,
is it preferable (faster) to save images in the database, or to simply
save a reference to the images in the database, but load the image from
the filesystem ???
Yves.
----
Yves Dorfsman dorfsmay@cuug.ab.ca
http://www.cuug.ab.ca/~dorfsmay
You sure can by using BLOBS.
You can do that by reading the perl module docs for Pg;
Read the section on large objects.
From experience, I would definitely recommend that you store the reference
to the file, like a URL or something. That is defiantly the faster way.
Loading things off the file system instead of the database will always be
faster. The only thing you run up against in that case is making sure that
your files and db references remain consistent. But that's not too big of a
deal.
Yves Dorfsman <x@x.com> wrote in message
news:imo95.61086$ef6.751553@news1.rdc1.ab.home.com...
Show quoted text
Is it possible to save images in postgreSQL ??
If yes, and in the case of a web site using both postgrSQL and mod_perl,
is it preferable (faster) to save images in the database, or to simply
save a reference to the images in the database, but load the image from
the filesystem ???Yves.
----
Yves Dorfsman dorfsmay@cuug.ab.ca
http://www.cuug.ab.ca/~dorfsmay