Database engines

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

SQLitePostgreSQLTimescaleDB
Supported versionslatest13, 14, 15pg13, pg14
When to useearly developmentgeneral usageworking with timeseries
Performancegoodbettergreat in some scenarios
SQL scripts
Immune tables
Hasura integration

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.

💡 SEE ALSO