Sqlite

CSV

In the SQLite shell:

.mode csv
# don't add quotes around the filename, as that led to really weird results
# automatically creates table if doesn't exist
.import /path/to/links.csv table_name
 
# to use an existing table, skip the first row when importing
.import --skip 1 /path/to/links.csv table_name

Examine the schema with .schema

Data Exploration

• Datasette: exploring SQLite databases in the browser
• sqlite-utils CLI tool and Python library for manipulating SQLite databases
• wddbfs: browse SQLite database contents on the filesystem

Database Synchronization / replication

• Litestream: replicates change to dumb storage (e.g, S3)
• LiteFS: replication to other SQLite nodes
• mycelite: replicates changes to other nodes