Databases
-
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 » -
Software Development
Writing Tests for Data Access Code – Don’t Forget the Database
When we write tests for our data access code, we must follow these three rules: …
Read More » -
Software Development
PostgreSQL’s Table-Valued Functions
Table-valued functions are an awesome thing. Many databases support them in one way or another and so does PostgreSQL. In…
Read More »
