Sqlite support #170
Description
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
Resources
Notes: investigate using bref to run the importer as a serverless API.