Re: [sqlite] Lazy JSON data to sqlite database

2019-01-19 Thread Andy Goth
If you have an SQL schema that works for you and also sample data, I might be able to assist writing the conversion program. Dunno if you're interested since it sounds like you won't need to do this again for another year. On Sat, Jan 19, 2019, 23:17 David Bicking >> Is there a tool out there

Re: [sqlite] Lazy JSON data to sqlite database

2019-01-19 Thread David Bicking
>> Is there a tool out there that will more or less automate the task for >> me? Hopefully free, as no one is paying me to do this. (The other >> volunteers have maybe a dozen records in total and are doing their >> reports by hand. ) >The automation is at a lower level than you seem to

Re: [sqlite] Lazy JSON data to sqlite database

2019-01-19 Thread Andrew.Goth
David Bicking wrote: > I have a data file with JSON data, and I want to get the data into an > sqlite database so I can run queries against it. It is not a large file, > only about 600 records in the main table. I've never worked with JSON > before, and really don't want to write my own parser to