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?