I managed to reduce a PostgreSQL view’s query time by more than 80% with just the two keywords NOT MATERIALIZED and by reading the actual database manual when GPT-4 gave up. Below, I will explain the context of the speedup. I recently moved a little bit of business logic from an API endpoint and into… Continue reading NOT MATERIALIZED

Simple website visitor stats and location with GoAccess

I do not use cookies or browser trackers (like Google Analytics) on any of my personal websites to track visitor information. From time to time however, it is nice to get an idea of the amount traffic to my sites, including what pages get viewed the most. I use the following one-liner for this: Read… Continue reading Simple website visitor stats and location with GoAccess

AI Tales

I recently launched a new website called AI Tales, where I share small snippets of text, generated by AI, edited by me. AI Tales is going to be my playground for sharing pieces of text that I find “interesting” in one way or another. I will try to update it regularly with new content. We… Continue reading AI Tales