Some Useful Privacy Tools

My this year's Christmas blog post is about some useful privacy tools and actions you can take to easily improve your privacy. This post is not dedicated to shop owners or developers but to any people in general that take their privacy seriously (which should be anyone to be honest). When choosing these privacy tools the focus was on easy handling so that everyone can use them easily or with minimal implications and technical knowledge.

How to calculate MySQL timezone offset

Sometimes it is necessary to calculate the offset for the current timezone. Therefore you can use this helpful snippet: SET @tzOffset = (UNIX_TIMESTAMP()-UNIX_TIMESTAMP(CONVERT_TZ(NOW(), 'Etc/UTC', 'Europe/Berlin'))); That's it.

My Blog now moved to Hugo

Although there are not that many blog posts here, I regularly re-acknowledge all the work that has been spent to create the articles that are currently there. That's why I decided to give some love to my blog and move all the content from WordPress to Hugo. While my main website is (of course ;-) based on Magento, my blog always has been separate from it to avoid any interferences. When I started in 2006, I hosted it on Tumblr, then I moved it to WordPress a few years ago.

Dropshipping possibilities in Magento

Approximately in every third Magento project that I am doing I get the request to implement some kind of Dropshipping. That’s why I want to give a short overview of how to handle that with Magento. What is Dropshipping? Dropshipping is a kind of E-Commerce business where the merchant offers products in his online shop without having the products in his inventory. If a customer orders some of these products a so-called purchase order is made and the dropshipping partner will ship the items for the merchant.

Why developer health matters?

So this blog post will be the starting point for a series of health-related articles targeted for developers. As I know personally life as a developer can be tough: we live in an ever-changing world and the speed in the IT sector is even faster than anything else. And human brain has its difficulties with exponential growth. That’s why I want to get into the details about how to establish developer health.

Legacy IT-Systeme in Real Life

Interessante Unterhaltung zum Thema Legacy IT-Systeme am Beispiel der Sparkasse: Unterhaltung – Curated tweets by vianetz

Infografik zur DSGVO

Die Datenschutzgeundverordnung darf natürlich in keinem Blog heutzutage fehlen😬 Hierzu habe ich folgende gute Infografik von webvision gefunden: (Quelle:

AlphaGo | Netflix

AlphaGo | Netflix

Book-Review “Die 4 Stunden Woche”

Zur Zeit lese ich das Buch Die 4 Stunden Woche” von Timothy Ferriss. Prinzipiell gefällt mir sein vorgeschlagener Ansatz, Arbeitszeit im Hinblick auf unsere Lebenszeit zu optimieren. Allerdings habe ich doch einige Zweifel, dass dieses Prinzip auf alle Branchen, insbesondere z.B. die Dienstleistungsbranche anwendbar ist. Selbst im privaten Bereich würde ich mir jetzt nicht wie von ihm vorgeschlagen einen Virtual Private Assistent zulegen, da die Qualität sehr schwankt und vor allem die Aufgaben auch passen müssen: was nützt mir ein Assistent in Indien, wenn ich hier in Deutschland zur Post muss?

MySQL: The innodb_file_per_table misconception

Mistakes in the conception phase of a project often pay off in a far far later point in time. This also applies for the setting innodb_file_per_table in MySQL. Prio to MySQL 5.6 this option is disabled by default which leads to one huge ibdata1 file being created on your machine for all your databases. The problem with this is that the space allocated on your disk can never be freed again.