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.
SQLite | PostgreSQL | TimescaleDB | |
---|---|---|---|
Supported versions | latest | 13 , 14 | pg13 , pg14 |
Best application | development | general usage | working with timeseries |
SQL scripts | ✅ | ✅ | ✅ |
Immune tables | ❌ | ✅ | ✅ |
Hasura integration | ❌ | ✅ | ✅ |
By default DipDup uses in-memory SQLite database that destroys after the process exits.
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. However, Tortoise ORM mostly hides these differences.