SQLite Forum

Insert ("slurp" ?) JSON documents
Login
I have a table like `raw_data(data json)`. I'm trying to just dump (via unix pipes) some json documents collected from the web. Something like curl "HTTP://...json" | jq . | sqlite3 my.db . The problem is that the `.import` commands usually works for tabular data. Handling quotes and whitespace via json is driving me nuts.

Any simple way I can achieve this? To make things simple, each pipe output inserts only one row.