4 ms·
I've solved some days in past years with sqlite + enough awk to transform the input into something that can be imported into a table. It can be a fun challenge.
by shawn_w 2y ago
I've solved some days in past years with sqlite + enough awk to transform the input into something that can be imported into a table. It can be a fun challenge.
- lyxell 2y agoI’m allowing myself to convert the data to a csv and read it using ’.mode csv’. I realized when solving todays problem that SQLite’s json_each("[" || T.c1 || "]") Is useful for parsing comma separated rows into (row, col)-pairs as well.