Self-host LinkBreeze: a Linktree alternative
Run LinkBreeze on a VPS with Docker Compose and Caddy: pinned image tags, cookieless click tracking, and the one volume that holds your whole site.
#sqlite
Filtering by topic #sqlite · clear
When agent memory goes stale, and how to prune
Agent memories go wrong quietly. Put an expiry on time bound facts, cascade the deletes, review the rest, and read your SQLite store with sqlite3.
Vaultwarden backup and restore on a VPS
Copy a live Vaultwarden vault with sqlite3 .backup, keep the attachments, config.json and rsa_key files, then prove the restore works before you need it.
SQLite in production on a VPS
SQLite is the right production database for most small apps on one VPS. WAL mode, busy_timeout, Litestream replication, and the limits that break it.
DuckDB vs SQLite on a server
SQLite holds transactional application state. DuckDB answers analytics over Parquet and CSV. Why one VPS usually runs both, with a worked example of each.