Category
PostgreSQL and database engineering — indexing, query planning, data modelling, and the trade-offs behind how data is stored and read.
DatabasesLearn how optimistic concurrency and pessimistic locking prevent lost updates, with SQL and Node.js examples, common pitfalls, and when to use each.
Continue reading
DatabasesLearn how transaction isolation levels work in PostgreSQL and MongoDB, why lost updates and write skew slip through, and how to fix them.
Continue reading
DatabasesLearn database indexing, including B-Tree, Hash, Composite, Unique, Partial, and Covering indexes, their performance trade-offs, and write amplification.
Continue readingTell us about your project and we'll come back with a plan, a timeline, and a quote.