Databases
-
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 » -
Software Development
Integrating jOOQ with PostgreSQL: Partitioning
Introduction jOOQ is a great framework when you want to work with SQL in Java without having too much ORM…
Read More » -
Software Development
A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)
Have you ever wondered about the use-case behind SQL’s ANY (also: SOME) and ALL keywords? You have probably not yet…
Read More » -
Software Development
SQL Tip of the Day: Be Wary of SELECT COUNT(*)
Recently, I’ve encountered this sort of query all over the place at a customer site: …
Read More » -
Software Development
Are You Using SQL PIVOT Yet? You Should!
Every once in a while, we run into these rare SQL issues where we’d like to do something that seems…
Read More »
