4 ms·
> There is nothing more convenient than SQLite for analyzing and transforming JSON. the example query given: select json_extract(value, '$.iso.code'
by jstrong 6y ago
> There is nothing more convenient than SQLite for analyzing and transforming JSON.
the example query given:
select
json_extract(value, '$.iso.code') as code,
json_extract(value, '$.iso.number') as num,
json_extract(value, '$.name') as name,
json_extract(value, '$.units.major.name') as unit
from
json_each(readfile('currency.sample.json'))
;
that sure looks fun to type into a repl!
nothing against sqlite, which I like and use, just found the idea of that query being convenient for one-off analysis to be off.