Daniel Niecke - Daniel's blog

Data Compression with Brotli

You may have heard of brotli and wondered what it is exactly. "Brotli is a generic-purpose lossless compression algorithm ..." the sentence goes on, of course, but after that it gets relatively technical. So the important information is, you can use Brotli to compress data. In fact, Brotli is now supported

Should I cache my Queries?

Regarding MySQL databases I have heard this question several times and I have asked it myself several times. The query cache of MySQL is a very old feature, which does not mean that it is bad. Yet, you rarely hear people advocating the use of the cache anymore. What does

Need To Improve Performance In MySQL? Try Prepared Statements

There are two main ways to execute MySQL queries against databases, through simple statements and through prepared statements. This article will cover the benefits of using prepared statements. What is a normal Statement?Simple SQL queries need no detailed explanation, since anyone who has ever sent an SQL query to

Why I started writing daily on LinkedIn

This is my story of why I chose to write a post every day on LinkedIn. Hopefully it will inspire a few to think about it as well. Even if it only makes one person think, I have always achieved something with this. Until a few days ago, my LinkedIn

MySQL

You should avoid using the IN-funtion in MySQL

In this small article, I would like to discuss why you should be careful with the popular IN function of SQL in certain situations. Of course, the function is not fundamentally bad, it is even extremely helpful. But there are always situations where the ill-considered use of this function can

HowTo

Ghost on Docker with Traefik

In this Article, I will show you how to host your own Ghost Instance with Docker and use Traefik as a Reverse Proxy. So let's start with the things we need: Some kind of server where everything will be deployed. I took a Hetzner Cloud Instance with 2 vCPUs and