modperl-image_databases_postgresql_vs_the_filesystem

This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.



To: "Perrin Harkins" <perrin@elem.com>
From: merlyn@stonehenge.com (Randal L. Schwartz)
Subject: Re: Galleries/ModPerl/Images
Date: 10 Oct 2001 07:14:42 -0700

>>>>> "Perrin" == Perrin Harkins <perrin@elem.com> writes:

Perrin> 3) Most databases don't make dealing with BLOBs as simple as MySQL

(ahem) *and* modern PostgreSQL

Perrin> does, so your code becomes rather hard to port.

Modern PostgreSQL has column type "bytea", with encode/decode escaping
handled entirely by DBD::Pg.

But agreed, it's slower to use an SQL interface to store images.  The
filesystem makes a darn fine database, as long as you can get the
resources into reasonable pathnames.

===


the rest of The Pile (a partial mailing list archive)

doom@kzsu.stanford.edu