sql

01.12.2022

SQL date range queries

In my company work, we often use two Date or DateTime fields to express a range when the row data is valid. CREATE TABLE test ( id int NOT NULL PRIMARY KEY, title varchar(255) NULL, valid_from…

Weiterlesen
29.12.2020

Data Access Layer Techniques

I have spent the last days exploring ways to map SQL result sets to objects as used in object-oriented programming languages as C# or Java. This process is known as object-relational mapping and is…

Weiterlesen
11.03.2020

PostgreSQL revisited

I still remember when I heard PostgreSQL for the first time. It was around 2001, when my former room mate mentioned that he was a maintainer for PostgreSQL on Debian. At that time, I was still…

Weiterlesen
01.05.2018

Exploring GraphQL

In an attempt to explore new technologies, I have recently digged into GraphQL, which may be the future protocol for fetching data with mobile and web applications. In contrast to the current…

Weiterlesen