Databases

Piora lets you quickly create and manage database services on your own VPS. All databases run as Docker containers with persistent storage, automatic backups, and connection management.

Supported Databases

Database	Versions	Use Case
PostgreSQL	14, 15, 16	General-purpose relational database, suitable for most applications
MySQL	8.0, 8.4	Widely used relational database
MariaDB	10.11, 11	Open-source MySQL fork, fully compatible
MongoDB	6, 7	Document-based NoSQL database
Redis	7	In-memory cache and key-value store

Creating a Database

Creating a database in the Piora dashboard is straightforward:

Navigate to the “Databases” page
Select the database type and version
Configure the name and authentication details
Click “Create”

Piora automatically creates the Docker container and sets up persistent volumes to keep your data safe.

Connection Methods

Internal Connection (apps on the same server)

If your application and database are deployed on the same server, use Docker’s internal network:

# PostgreSQL example
postgresql://user:password@database-container-name:5432/dbname

# MySQL example
mysql://user:password@database-container-name:3306/dbname

External Connection

If you need to access the database externally (e.g., from a development environment), you can enable external port access in the settings.

Database Management

Each database service provides the following management features:

Status monitoring — View running status, connection count, resource usage
Log viewer — View database log output
Backup management — Configure automatic backup schedules
Connection info — Quickly access connection strings

In This Section

PostgreSQL — PostgreSQL setup and management
MySQL / MariaDB — MySQL and MariaDB configuration
MongoDB — MongoDB document database
Redis — Redis cache service