Databases
-
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 » -
Enterprise Java
How to fix optimistic locking race conditions with pessimistic locking
Recap In my previous post, I explained the benefits of using explicit optimistic locking. As we then discovered, there’s a…
Read More » -
Core Java
JDBC Tutorial – The ULTIMATE Guide (PDF Download)
In this post, we feature a comprehensive JDBC Tutorial (Java Database Connectivity), an API provided by Oracle that allows programmers…
Read More » -
Software Development
Declarative SQL Mode Pitfall
As we know a view object definition supports three SQL modes. There are normal, declarative and expert modes. In this post…
Read More »
