PostgreSQL

Overview

PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development and a proven architecture.

Features

• ACID Compliant: Strong data integrity guarantees
• Extensible: Custom data types, functions, and operators
• Advanced Features: Full-text search, JSON/JSONB support, window functions
• Reliable: Proven stability and data integrity
• Performance: Advanced query optimizer and indexing

BasicStack Integration

PostgreSQL is used as the primary database for all BasicStack services. Each service (Directus, Pocket ID, BookStack) has its own PostgreSQL database, all running on encrypted Hetzner Cloud Volumes with automated backups.