Databases
-
Software Development
Do You Really Understand SQL’s GROUP BY and HAVING clauses?
There are some things in SQL that we simply take for granted without thinking about them properly. One of these…
Read More » -
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 »
