software
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
HAProxy
One of my current topics at work is setting up an API Gateway. We are slowly moving towards a cloud-capable environment, and having only one entry point for our growing stock of web applications can…
WeiterlesenCombining config.json and MSAL
The issue Reading a config file before everything else is one thing you might also use in your Angular app. Typical tutorials will use Angular's HttpClient to read the file during application startup…
WeiterlesenData 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…
WeiterlesenAgil skaliert
Heute habe ich mal wieder eine Prüfung absolviert, am Computer tickten 90 Minuten runter, um etliche Fragen zu beantworten, alles mit der Maus auswählbar. Thema war das Scaled Agile Framework 5.0…
WeiterlesenPostgreSQL 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…
WeiterlesenImage Handling with Hugo
I like photos and use them extensively on this site. But images have a price, as images can be quite large and every image needs to be fetched by a request. And so, image-heavy pages take quite some…
WeiterlesenExploring 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…
WeiterlesenComparis-Relaunch
Am Dienstag ging ein Teil der Comparis-Seite im neuen Design live. Noch sind wir am Testen, wie gut das bei den Benutzern ankommt, aber schon bald werden auch weitere Applikationen im neuen Kleid…
WeiterlesenModular JavaScript
On our company website, as on many others, we have a growing JavaScript code base. We are now taking the effort to develop a module system to make it easier to structure the code. Our first decision…
WeiterlesenFirst Steps with Scheme and Git
Today, I installed Git, joined github.com and published my first two code snippets in Scheme (Lisp dialect). The main reason to study Scheme is the book Structure and Interpretation of Computer…
Weiterlesen