Database
Articles about database.
2 articlesUnderstanding Database Locks: Managing Concurrency in Databases
Database concurrency explained through shared and exclusive locks, isolation levels, pessimistic and optimistic locking, MVCC, and a seat-booking example.
How a Database Index Works and How to Use It Effectively
How database indexes speed up queries, their storage and write costs, and when to use single-column, compound, unique, and partial indexes.