Differences

This shows you the differences between two versions of the page.

--- librematch:design:persistence:database:postgres [2022-10-27 22:57] – removed - external edit (Unknown date) 127.0.0.1
+++ librematch:design:persistence:database:postgres [2022-11-23 01:58] (current) – simonsan
@@ Line 1: / Line 1: @@
+====== 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 [[ https://github.com/amacneil/dbmate | dbmate]].
+The database schema and migrations are open-source and can be found [[https://github.com/librematch/librematch-database/|here]]. This repository acts like a **single source of truth (SSOT)** for the DB schema.
+===== Partitioning =====
+===== Replication =====
+===== Notes =====
+  * https://sqlfordevs.com/multiple-aggregates-in-one-query