[OpenGuides-Dev] Re: BLOBs in SQLite and MySQL?

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 &lt;merlyn(a)stonehenge.com&gt; <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!