Databases
-
Software Development
Discovering the Computer Science Behind Postgres Indexes
This is the last in a series of Postgres posts that Pat Shaughnessy wrote based on his presentation at the…
Read More » -
Software Development
Rethinking database schema with RDF and Ontology
When I joined the industry 10 years ago, my first project used relational database. After that, my next project also…
Read More » -
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 »
