Database engines

DipDup officially supports the following databases: SQLite, PostgreSQL, TimescaleDB. This page will help you choose a database engine that mostly suits your needs.

SQLitePostgreSQLTimescaleDB
Supported versionsanyanyany
When to useearly developmentgeneral usageworking with timeseries
Performancegoodbettergreat in some scenarios
SQL scripts
Immune tables*
Hasura integration✅**✅**

* — see immune_tables config reference for details.

** — schema name must be public

While sometimes it's convenient to use one database engine for development and another one for production, be careful with specific column types that behave differently in various engines.