Data Persistence & Visualization SOP

SQLite with sqlite-utils

• Install: pip install sqlite-utils

Basic Operations

import sqlite_utils
db = sqlite_utils.Database("data.db")
db["table_name"].insert({"id": 1, "value": "data"}, pk="id")
# Bulk insert
db["table_name"].insert_all([{"id": 1, "val": "a"}, {"id": 2, "val": "b"}])

Visualization

• Use datasette: datasette data.db to serve a web UI.