# Data Persistence & Visualization SOP

## SQLite with `sqlite-utils`
- Install: `pip install sqlite-utils`

## Basic Operations
```python
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.