[sqlite] compressing BLOB

2012-03-02 Thread Christoph P.U. Kukulies
Since I'm inserting large files into the DB I'm wondering whether Sqlite can do compression on the data BLOB by itself or whether I should do that by programming when creating the BLOB? -- Christoph Kukulies ___ sqlite-users mailing list

Re: [sqlite] compressing BLOB

2012-03-02 Thread Benoit Mortgat
SQLite does not compress your blob and you will have to do that programatically. However you can define your own with sqlite_create_function_v2(): the prototype of your function would be void compress(sqlite3_context *context, int argc, sqlite3_value **argv) { assert(argc==1); void *data =

Re: [sqlite] compressing BLOB

2012-03-02 Thread Stephan Beal
On Fri, Mar 2, 2012 at 12:54 PM, Benoit Mortgat mort...@gmail.com wrote: SQLite does not compress your blob and you will have to do that programatically. However you can define your own with sqlite_create_function_v2(): the prototype of your function would be There's an implementation in