Vucense
Dev Corner category

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 topic

Self-hosted PostgreSQL on Ubuntu 24.04: installation, user management, pg_hba.conf, remote access, and pgTune configuration for sovereign data persistence.

Redis & Caching

View topic

Deploy 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 topic

SQLite 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 topic

Sovereign 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 topic

Harden self-hosted databases against unauthorised access. Covers encryption at rest (pgcrypto, TDE), TLS connections, least-privilege roles, audit logging, and network isolation.