I’ve also just released sqlite3_compress, which implements gzip, deflate, and zlib compression in SQLite user defined functions.
It might serve as an example of how to implement custom functions. Or it might serve as an example of how not to do it… let me know what you think, either way!
For example: db.exec "INSERT INTO my_table (url, html_gzip) VALUES (?, COMPRESS_GZIP(?))", url, html
Paul M Lambert