-
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 » -
Core Java
Java 8 Friday: 10 Subtle Mistakes When Using the Streams API
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Enterprise Java
Stop Trying to Emulate SQL OFFSET Pagination with Your In-House DB Framework!
I’m pretty sure you’ve gotten it wrong in numerous ways, so far. And you probably won’t get it right any…
Read More » -
Software Development
Java 8 Friday: JavaScript goes SQL with Nashorn and jOOQ
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
SQL Developer’s “Securely” Encrypted Passwords
Recently, while at one of our customers’ site, the customer and I needed to get access to a database. On…
Read More » -
Core Java
Java 8 Friday: Most Internal DSLs are Outdated
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
Yet Another 10 Common Mistakes Java Developers Make When Writing SQL (You Won’t BELIEVE the Last One)
(Sorry for that click-bait heading. Couldn’t resist!) We’re on a mission. To teach you SQL. But mostly, we want to…
Read More » -
Core Java
Java 8 Friday: Better Exceptions
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More »