by Sem Postma | Sep 10, 2023 | Development, EN
Troubleshooting common issues with composite indexes in SQL databases Sem Postma, 10 September 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, 9 September 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 returning...
by Sem Postma | Apr 22, 2023 | Development, EN
Binary Heaps with Javascript 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 children. This means that the...
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...
by Sem Postma | Jan 6, 2023 | EN
Lancering van Cast to Sonos Sem Postma, January 6, 2023 Cast your Google Chrome tab to any Sonos device. After a lot of time and a lot of testing, I’m happy to finally release this application for Sonos to the wider public! Cast to Sonos is a browser extension...
by Sem Postma | May 16, 2021 | Development, EN
S3 not passing correct headers to Cloudfront A simple fix for a very annoying issue with AWS Cloudfront and S3. Assuming that you already configured the appriopriate CORS policy below. Your CORS policy may look different depending on the type of headers, methods and...
