Ruby Forum Ruby on Rails > ActiveRecord & SQLite3 Blobs

Posted by Jay (Guest)
on 07.05.2008 07:15
(Received via mailing list)
There is a problem with blobs in ActiveRecord when you're using
sqlite3:  sql length limits.  Sqlite3 limits the size of the sql
queries to 1mb.  Because AR puts everything into the sql text, you
can't insert a blob or a clob that is larger than about a meg.

That sucks.

So I'm trying to fix that, but there's a problem (obviously, or I
wouldn't be here...).  The sql is created before it gets to the
sqlite3 adapter.  That means that I would have to parse the sql text
to pull out the data fields.  I would also have to un-escape all that
data.

Is there something I've missed?  Some way to override the behavior of
create and update w/o changing the relationship between
ActiveRecord::Base and the connection adapter?