I spent some time this week figuring out how to compile ghaering's `pysqlite` library with support for the new SQLite json extension. Finally got it working and I must say it's pretty damn exciting!
Here's a blog post I wrote that covers everything from compiling sqlite with JSON to running queries from Python: http://charlesleifer.com/blog/using-the-sqlite-json-extension-with-python/ Hope you all find it helpful. Charlie
