Can I import Javascript objects (and/or JSON) directly into a table?

[githorse]

My API returns an array of JSON objects, which then becomes an array of Javascript objects by the time it hits my application-level code. Is there a way to load the in-memory array of Javascript objects (or, possibly, the original JSON) directly into a sql.js database table?

Obviously I can craft my own INSERT statements to do this, but the omission of a built-in loader for Javascript objects makes me think I'm missing something here. If I don't have a .sqlite file to download, but rather a JSON API (surely, not a terribly rare use case?), what's the standard practice for getting my data from that API into sql.js?

[lovasoa]

Yes the best solution is to write your own insert statements.

I don't want to be rude, but maybe you could make this kind of requests for engineering advice on stack overflow instead? This is the second issue you open which is not really an issue but rather a general question.

[githorse]

@lovasoa - the right place for this kind of engineering advice (e.g., how to get Javascript objects into the database) would be your documentation. Since you're evidently not interested in improving it, sure, I'll use StackOverflow instead.

[lovasoa]

Pull requests to this repo are welcome, including to the documentation :)