Sqlite support

[johanjanssens]

Implement support for SQLite and build a command line utility to import json or csv.

Reading

• https://antonz.org/sqlite-is-not-a-toy-database/
• https://litestream.io/blog/why-i-built-litestream/
• https://syncinc.so/ and https://syncinc.so/careers
• https://github.com/lspgn/edge-sql
• https://www.notion.so/blog/faster-page-load-navigation
• https://www.sqlite.org/fasterthanfs.html
• https://mtlynch.io/litestream/
• https://www.cloudsavvyit.com/13161/what-is-sqlite-and-why-is-it-so-popular/
• https://jlongster.com/future-sql-web
• https://tirkarthi.github.io/programming/2022/02/26/sqlite-json-improvements.html
• https://blog.cloudflare.com/introducing-d1/?ref=console.dev
• https://christine.website/blog/sqlite-json-munge-2022-01-04
• https://antonz.org/json-virtual-columns/
• https://venturebeat.com/2022/05/20/why-sqlite-may-become-foundational-for-digital-progress/
• https://tailscale.com/blog/database-for-2022/
• https://changelog.com/posts/sqlite-web-renaissance
• https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/

Tools

• https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/
• https://github.com/phiresky/world-development-indicators-sqlite/
• https://github.com/jlongster/absurd-sql
• https://sqlime.org/about.html
• https://sqlite.org/fiddle/
• https://github.com/maxpert/marmot
• https://github.com/rqlite/rqlite
• https://vlcn.io/
• https://github.com/asg017/sqlite-loadable-rs
• https://github.com/nalgeon/sqlean
• https://github.com/libsql/libsql
• https://github.com/vlcn-io/cr-sqlite
• https://github.com/siara-cc/sqlite_blaster

Extensions

• https://github.com/x2bool/xlite
• https://h3rald.com/litestore/

Resources

• https://github.com/salsify/jsonstreamingparser
• https://bref.sh/

Notes: investigate using bref to run the importer as a serverless API.