Databases
-
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 » -
Software Development
Awesome SQL Trick: Constraints on Views
CHECK constraints are already pretty great when you want to sanitize your data. But there are some limitations to CHECK…
Read More » -
Software Development
PL/SQL backtraces for debugging
For many PL/SQL developers, this might be common sense, but for one of our customers, this was an unknown PL/SQL…
Read More »
