by Sem Postma | Jan 30, 2024 | Development, EN
Creating a binary storage format from scratch Sem Postma, January 30, 2024 Binary formats are often the most efficient and performant, the drawback being that they are not human-readable. In this article, I’ll be using Key/Column order The key order is extremely...
by Sem Postma | Sep 10, 2023 | Development, EN
Troubleshooting common issues with composite indexes in SQL databases Sem Postma, September 10, 2023 Composite indexes are very powerful tools at your disposal when improving performance on large databases. It’s important to state beforehand that you should always be...
by Sem Postma | Sep 9, 2023 | Development, EN
Eliminating full table scans for slow paginated SQL queries Sem Postma, September 9, 2023 You often do not need to know the total page count. Here is an easy way to rewrite your SQL queries with the potential to drastically improve performance. If your ORM is...
by Sem Postma | Apr 22, 2023 | Development, EN
Binary Heaps with Javascript Sem Postma, April 22, 2023 Even though it might sound like a difficult subject it’s actually not that difficult. We will start by establishing some basics. The first one being that a node will always be equal to or smaller than it’s...
by Sem Postma | Jan 12, 2023 | Development, EN
A complete guide to tracking events with GA4 & BigQuery Useful but not often used, the new GA4 measurement protocol offers a programatic method of tracking events using Google Analytics. Let’s first have a look at the diagram provided by google, explaining...