Databases
Databases and caches used by apps and other assets. Install them directly, or install them together from the connection items when installing another asset. Project → Catalog
At a glance
| Open source | Type | License |
|---|---|---|
| PostgreSQL | Relational DB | PostgreSQL |
| MariaDB | Relational DB (MySQL compatible) | GPL-2.0 |
| MongoDB | Document DB | SSPL-1.0 |
| Redis · Valkey | Key-value cache | Valkey BSD-3 · Redis see below |
How to connect to an app → Chapter 8 · Connect resources
PostgreSQL
The most widely used open source relational database. Most assets installed on tidoly use PostgreSQL.
| Item | Details |
|---|---|
| Official site and usage | postgresql.org/docs |
Several apps share one instance. A dedicated schema is created for each app, so they don't mix.
For scheduled backups with point-in-time recovery, install the postgresql-backup extension alongside it.
MariaDB
A relational database compatible with MySQL.
| Item | Details |
|---|---|
| Storage | Minimum 5Gi · recommended 50Gi |
| Official site and usage | mariadb.com/docs |
Install a separate instance for each app
Unlike PostgreSQL, connected apps share the same database and the same account. To keep data separate between apps, install separate instances.
MongoDB
A database that stores JSON-style documents.
| Item | Details |
|---|---|
| Storage | Minimum 10Gi · recommended 30Gi |
| Official site and usage | mongodb.com/docs |
You choose the mode at install time. With a single server, mongodb (single) is enough.
| Mode | Characteristics |
|---|---|
mongodb | Single instance, lightweight. No authentication |
mongodb-percona | An operator handles authentication, replica sets, and account creation. Not yet covered by tidoly backup |
The SSPL license imposes conditions when you offer MongoDB as a service to others. That differs from in-house use, so check the official license.
Redis · Valkey
A key-value store used for caches, sessions, and job queues. Choose one of the two at install time.
| Choice | License | Usage |
|---|---|---|
| Valkey (recommended) | BSD-3 | valkey.io/docs |
| Redis | RSALv2 · SSPL-1.0 · AGPL-3.0 | redis.io/docs |
Valkey is a project forked from Redis, and apps connect to it exactly as they do to Redis. It's recommended because it has fewer license restrictions.