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

Toby Corkindale wrote:

Hi there,

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).

Cheers