Database Blocks
Database blocks provide ready-to-use managed data storage services. Fransys handles provisioning, network configuration, backups, and scaling — you just drag and drop the block and connect it to your application.
PostgreSQL
PostgreSQL is the recommended relational database on Fransys. It offers the most complete configuration with built-in resource management, storage, and backups.
General configuration
| Parameter | Description |
|---|---|
| Database engine choice | PostgreSQL |
| PostgreSQL version | Engine version (e.g., v18.0) |
| Remote database access | ON/OFF — Allow access from outside the cluster |
Resources and scaling
The Resources tab lets you finely control the resources allocated to PostgreSQL.
| Parameter | Description |
|---|---|
| Requests — CPU per replica | Minimum guaranteed CPU per replica |
| Requests — Memory per replica | Minimum guaranteed RAM per replica |
| Limits — CPU per replica | Maximum allowed CPU per replica |
| Limits — Memory per replica | Maximum allowed RAM per replica |
| Horizontal scaling | Number of replicas (default: 1) |
Requests define the minimum resources reserved for each replica. Limits define the ceiling the service cannot exceed. Leaving these values at "No request" / "No limit" allows the service to use available cluster resources flexibly.
Storage and backups
The Storage tab manages data volume and the built-in backup system.
| Parameter | Description |
|---|---|
| Volume | Persistent storage size (e.g., 5 gigabytes) |
| Bootstrap | Startup source — From scratch or from an existing backup |
| Backup Retention Days | Backup retention period (default: 14 days) |
| Backup Schedule | Automatic backup schedule (cron) |
| Last backups | History of recent backups |
Automatic backups
Fransys includes a built-in automatic backup system for PostgreSQL. Backups are:
- Automatic — Scheduled according to the defined schedule, without manual intervention
- Configurable retention — Default 14 days, adjustable to your needs
- Restorable — Ability to bootstrap a new instance from an existing backup via the Bootstrap option
Automatic backups are enabled by default. Adjust retention and schedule based on the criticality of your data. For a production database, 14 days is a good starting point.
MariaDB
MariaDB is a lightweight and performant MySQL-compatible alternative.
| Parameter | Description |
|---|---|
| Database engine choice | MariaDB |
| MariaDB version | Engine version (e.g., v10.6) |
| Remote database access | ON/OFF — Allow external access |
Redis
Redis is an in-memory key-value store, ideal for cache, sessions, and queues.
| Parameter | Description |
|---|---|
| Database engine choice | Redis |
| Redis version | Engine version (e.g., v7.0) |
Redis has the simplest configuration: choose the version and you're ready. Connect it to your application and the REDIS_HOST, REDIS_PORT, and REDIS_PASSWORD variables are automatically injected.
Connection with an application block
When you connect a database block to an application block on the canvas, Fransys automatically injects all necessary variables on the application side. You don't have to manually copy the host, port, user, or password — everything is synchronized.
→ Learn more: Connections between blocks