Databases
-
Software Development
Adding OpenSSL User-Defined Types to PostgreSQL
PostgreSQL supports user-defined types (UDT). These types can be used to provide type-safety on user-defined functions when we would otherwise…
Read More » -
Software Development
Database Threat Models
I finally have a breather and can start working through my backlog of ideas. I start with some background that…
Read More » -
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 »
