Databases
-
Software Development
The downside of version-less optimistic locking
Introduction In my previous post I demonstrated how you can scale optimistic locking through write-concerns splitting. Version-less optimistic locking is…
Read More » -
Software Development
Use MySQL’s Strict Mode on all new Projects!
MySQL is a database that has been bending the SQL standard in ways that make it hard to move off…
Read More » -
Software Development
Don’t Migrate to MariaDB just yet. MySQL is Back!
Now that I have your attention, I’d like to invite you to a critical review of where we’re at in…
Read More » -
Software Development
Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?
When writing DDL in SQL, you can specify a couple of constraints on columns, like NOT NULL or DEFAULT constraints.…
Read More » -
Software Development
An entity modelling strategy for scaling optimistic locking
Introduction Application-level repeatable reads are suitable for preventing lost updates in web conversations. Enabling entity-level optimistic locking is fairly easy.…
Read More » -
Software Development
Logical vs physical clock optimistic locking
Introduction In my previous post I demonstrated why optimistic locking is the only viable solution for application-level transactions. Optimistic locking…
Read More » -
Software Development
Using Your RDBMS for Messaging is Totally OK
Controversial database topics are a guaranteed success on reddit, because everyone has an opinion on those topics. More importantly, many…
Read More » -
Software Development
Preventing lost updates in long conversations
Introduction All database statements are executed within the context of a physical transaction, even when we don’t explicitly declare transaction…
Read More » -
Software Development
A beginner’s guide to database locking and the lost update phenomena
Introduction A database is highly concurrent system. There’s always a chance of update conflicts, like when two concurring transactions try…
Read More »