-
A Tale on Concatenated Indexes: Master Roshi and Goku’s fireside chat
Right Practice. Right Results This post is part of newsletter that I run “Scamming the Coding Interview”, which is geared towards continuous practice on concepts to ace the engineering interviews. Subscribe Once upon a time there was a master named Roshi whose relational database used to work like a blowing wind. Reads used to be…
-
Tackling Lost Updates Problem In Database Using Stricter Transaction Isolation Level
Introduction Databases are made for scale and are a highly concurrent system. Thus it is normal for them to expect multiple concurrent connections. Also, in most situations, we’ll want our database to be the source of truth and always contain consistent data. There are many concurrency related phenomena that can occur in a database when…