Postgres
Extensions
- visualise long-running requests and DB load we should use some statistics extension for Postgres
Database migration
We version control our database schema with a lightweight, framework-agnostic database migration tool called dbmate.
The database schema and migrations are open-source and can be found here. This repository acts like a single source of truth (SSOT) for the DB schema.