Interesting project, a JSON+SQLite based database with rest API. https://bitbucket.org/robertodealmeida/jsonstore
May be web2py DAL can have an adapter for it, or something like this. A schema-free database for JSON documents, exposed through a REST API. JSONStore supports a wide range of backends (memory, Amazon S3, SQL databases, etc.), and searching is implemented using a flexible matching algorithm that has support for standard and user-defined operators.