>>>> "Toby" == Toby Corkindale
<tjc(a)wintrmute.net> writes:
Toby> I've written a file-attachment patch for OpenGuides and CGI::Wiki, which
Toby> stores the files in BLOBs. I've written the relevant CGI::Wiki::Store::Pg
Toby> module for Postgresql,
Why? Rows in Pg are unlimited length, and BLOBs are supported only to
be "oracle-like". It's preferred that you simply store the data in
the row.
Toby> but I don't know so much about SQLite or MySQL.
SQLite doesn't have blobs, but any column can store a lot:
The total amount of data in a single row of the database is limited
to 1 megabyte. You can increase this limit to 16 megabytes, if you
need to, by adjusting a single #define in the source tree and
recompiling.
MySQL is not a database. :)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(a)stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See
PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!