If you're using some BLOB data in ActiveRecord (e.g. user pictures stored in DB), then you may have noticed that the Rails logging simply prints the INSERT/UPDATE SQL containing the raw binary content. Now for me (at least in development env) this is pretty useless and besides my terminal seems to be getting crazy out of it.
As usual I thought someone must have done it before and found this post. It's pretty outdated since it targets Rails 1.x, so I decided to make it work with Rails 2.x and here's what I got :
Put this monkey-patch into a file named
Now, instead of being bloated with binary bits, your blob log entries should look similar to this one:
INSERT INTO db_files (data) VALUES(x'ffd8ffe000104a464946000101010048... (14133 bytes)')
As a home work you might further improve your SQL logs with stats (bytes transferred from DB per request), it's all in here done for Rails 1.x.
Thanx http://gurge.com/blog for the inspiration !