Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives you the goods of relational and hierarchical databases in one place, including the querying and indexing. -- Darren Duncan
On 2015-07-13 5:43 PM, Hayden Livingston wrote: > Is there a concept of a schema-less JSON SQLite DB? > > My reason is simple: versioning. We have lot of business metrics that > get updated let's say once a month, and we need to be agile to get > them. Right now, we just put the version in the SQLite file, and then > make sure no queries cross the boundaries. > > Secondly, we have requirements for slightly hierarchal data, i.e. > mostly row form, but then some guy wants to put an object. > > What's the SQLite community heading towards if at all? > > Do others have experiences and requirements similar to this?