Tag: postgresql
All the articles with the tag "postgresql".
CDC or outbox: why I chose the outbox to publish events
Both guarantee that the event goes out if, and only if, the database transaction was committed. The difference is in what goes out, in who owns the contract, and in what you end up operating.
Partitioning a ledger at two levels: account group and year
LIST by account group, RANGE by year, a composite primary key and one rule nobody may forget: every query carries both keys.
Creating new partitions without locking the root table
The obvious PostgreSQL command holds an ACCESS EXCLUSIVE lock on the whole table until commit. There is a path that holds nothing that matters, and it is two commands instead of one.