PostgreSQL: Transactions, Locks, Isolation Levels, MVCC, VACUUM https://sudonull.com/postgresql-transactions-locks-isolation-levels-mvcc-vacuum
Deep dive into PostgreSQL transaction and locking mechanisms. Analysis of isolation levels (Read Committed, Repeatable Read, Serializable), MVCC, VACUUM, and methods for solving concurrency issues.
Cambalache 1.0: GTK UI editor https://sudonull.com/cambalache-1-0-gtk-ui-editor
Cambalache 1.0 — WYSIWYG tool for GTK 3/4 interfaces with MVC and Casilda. Style support, GResources, Undo. Install Flatpak and develop UI without Glade. For developers.
Designing OLTP DB on Rust: principles https://sudonull.com/designing-oltp-db-on-rust-principles
Learn the principles of creating an OLTP database from scratch: restrictive by default, contract-first, Rust traits, hybrid async/sync. Real trade-offs for middle/senior dev. Study the architecture.