The hi/lo algorithm

Introduction In my previous post I talked about various database identifier strategies, you need to be aware of when designing…

Read More »

Database primary key flavors

Types of primary keys All database tables must have one primary key column. The primary key uniquely identifies a row…

Read More »

A beginner’s guide to Hibernate Types

The basic mapping concepts When learning Hibernate many like to jump to parent-child associations without mastering the object relation mapping…

Read More »

The minimal configuration for testing Hibernate

Introduction In my previous post I announced my intention of creating a personal Hibernate course. The first thing to start…

Read More »

The data knowledge stack

Concurrency is not for the faint-hearted We all know concurrency programming is difficult to get it right. That’s why threading…

Read More »

The simple scalability equation

Queueing Theory The queueing theory allows us to predict queue lengths and waiting times, which is of paramount importance for…

Read More »

Time to break free from the SQL-92 mindset

Are you stuck in the 90s? If you are only using the SQL-92 language reference, then you are overlooking so…

Read More »

How to import CSV data into PostgreSQL

Introduction Many database servers support CSV data transfers and this post will show one way you can import CSV files…

Read More »

Professional connection pool sizing

Introduction I previously wrote about the benefits of connection pooling and why monitoring it is of crucial importance. This post…

Read More »