Articles with "sql"

17.2.2023
Using OData

Exploring the use of OData for fetching data.

1.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.

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 needed for all projects accessing data from a SQL database, the results must be converted to objects for further processing or sending them out as JSON.

Example SQL code
11.3.2020
PostgreSQL revisited

Rediscovering PostgreSQL and highlighting some features.