Databases
-
Enterprise Java
Do Not Make This Mistake When Developing an SPI
Most of your code is private, internal, proprietary, and will never be exposed to public. If that’s the case, you…
Read More » -
Software Development
PostgreSQL’s Best-Kept Secret, and how to Use it with jOOQ
PostgreSQL has a lot of secret data types. In recent times, PostgreSQL’s JSON and JSONB support was hyped as being…
Read More » -
Enterprise Java
How to Avoid the Dreaded Dead Lock when Pessimistic Locking – And some Awesome Java 8 Usage!
Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to…
Read More » -
Scala
A fresh look on accessing database on JVM platform: Slick from Typesafe
In today’s post we are going to open our mind, step away from traditional Java EE / Java SE JPA-based…
Read More » -
Software Development
How to use SQL PIVOT to Compare Two Tables in Your Database
This can happen ever so easily. You adapt a table by adding a new column: …
Read More » -
Software Development
How to Extract a Date Part in SQL
The Modern SQL Twitter account (by Markus Winand) published a hint about how to extract a date part in SQL:…
Read More » -
Software Development
jOOQ vs. Slick – Pros and Cons of Each Approach
Every framework introduces a new compromise. A compromise that is introduced because the framework makes some assumptions about how you’d…
Read More » -
Software Development
10 SQL Articles Everyone Must Read
We’ve been blogging about Java and SQL for a while now, on the jOOQ blog. Over the years, while researching…
Read More » -
Software Development
Five easy steps to improve your database performance
January 30, 2015: Based on reader feedback, section 4 “Do you have enough database connections?” has been revised. Database access…
Read More »
