Databases
Explore Dev Corner articles and subtopics in Databases. This hub page collects practical builds, tools, and engineering guides for sovereign local AI.
Topic breadth
2
Active builds, guides, and subtopic coverage.
Subtopics
PostgreSQL
View topicSelf-hosted PostgreSQL on Ubuntu 24.04: installation, user management, pg_hba.conf, remote access, and pgTune configuration for sovereign data persistence.
Redis & Caching
View topicDeploy Redis for sovereign caching, session storage, and pub/sub messaging. Covers installation, ACL security, persistence configuration (RDB/AOF), and Valkey migration.
Embedded & Analytical DBs
View topicSQLite and DuckDB for sovereign, serverless data storage. SQLite for embedded apps and local state; DuckDB for in-process analytical queries with zero infrastructure overhead.
Backup & Recovery
View topicSovereign database backup strategies: pg_dump, pgBackRest, Barman, and point-in-time recovery for PostgreSQL. Covers automated backup scripts, retention policies, and restore testing.
Database Security
View topicHarden self-hosted databases against unauthorised access. Covers encryption at rest (pgcrypto, TDE), TLS connections, least-privilege roles, audit logging, and network isolation.