Toby Corkindale wrote:
I've written a file-attachment patch for OpenGuides and CGI::Wiki, which
stores the files in BLOBs. I've written the relevant CGI::Wiki::Store::Pg
module for Postgresql, but I don't know so much about SQLite or MySQL.
Do they support BLOBs?
I believe their interfaces (and that of other DBs) are very similar:
they both can handle BLOBbish data. The only issue off the top of my
head is to use placeholders rather than quoted values, but you were
probably gonna do that anyway...
IIRC some databases don't like to sort, compare, or get distinct blob
values. (You probably weren't gonna do that anyway).