What datatype should I use for storing large text files and binary data in SQLite in Rails

I need to store some binary files (spreadsheets) and some web pages in my table in SQLite DB in Rails. I know that storing files in the 开发者_运维问答DB isn't a good practice but in this case, the convenience outweighs all else since I only need to store files rarely. Thank you.

You should use the BLOB type for this purpose.

The binary data type maps to to the BLOB in SQLite. The size can be specified by using the limit parameter. Here's an example from an self.up method of a migration:

t.column :mystuff, :binary, :limit => 10.megabyte