-
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 »




