Databases
-
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 » -
Software Development
Flyway and jOOQ for Unbeatable SQL Development Productivity
When performing database migrations, we at Data Geekery recommend using jOOQ with Flyway – Database Migrations Made Easy. In this…
Read More » -
Software Development
Database primary key flavors
Types of primary keys All database tables must have one primary key column. The primary key uniquely identifies a row…
Read More »