Skip to content

Database

Setup

By default, DjipFast is using SQLite as database. SQLite can handle incredible amounts of data and is very easy to setup.

Want to know more about SQLite and what it is capable of?

Read here for a thorough explanation, or watch this video regarding using SQLite in production.

To get the maximum performance, DjipFast sets up SQLite in WAL (Write-Ahead Logging) mode and includes other sensible defaults:

  • PRAGMA journal_mode = 'WAL'
  • PRAGMA temp_store = 'MEMORY' (faster temporary storage operations)
  • PRAGMA synchronous = 'NORMAL' (faster synchronization that still keeps data safe)
  • PRAGMA cache_size = -64000 (increase cache size (in our case to 64MB), the default is 2MB)

Djipfast also includes a timeout of 20 seconds for database operations. To make sure transactions wait until timeout before raising "Database is Locked", the transaction mode is set to IMMEDIATE.

If you prefer PostgreSQL however, switching is straightforward. Replace the DATABASE configuration in settings.py with PostgreSQL. See the official Django documentation for more information.

Backup

When using Fly.io, the database is automatically backed up daily. You change the interval of the backup though.

For a streaming replication setup, i.e. a continuous backup setup, you can follow this tutorial.