On Wed, Apr 22, 2015 at 2:17 PM, Eric Rubin-Smith <eas.bts at gmail.com> wrote:
> > On Tue, Apr 21, 2015 at 9:09 PM, Ashish Sharma <ashishonline at gmail.com> > wrote: > >> Many times I store JSON data in sqlite. It will be useful if sqlite came >> with functions which understand JSON. Presto has a nice set >> https://prestodb.io/docs/current/functions/json.html >> > > I wrote a little tool that more or less allows the user to ingest JSON > into an SQLite database, for use in tiny platforms (think a VM running > inside a low-power home router). I was considering open-sourcing it. > > Below is the man page for the tool. If there is enough interest, I'll do > the requisite work to remove dependencies on other bits of my > infrastructure and publish it somewhere. Let me know. > Apologies for self-replying. The formatting of my man page copy-paste looks pretty bad in a lot of places. Here's a PDF-ized version for easier reading: https://www.aterlo.com/wp-content/uploads/2015/04/json2sqlite.pdf Eric