Daniel Setzermann
  • Home
  • About Me
  • Workflows
Daniel Setzermann

Daniel Setzermann

How to calculate the median per group with MySQL

The other day I had to calculate the median per group within MySQL. Turns out this is not as easy as it sounds mostly due to the fact that there exist

Daniel Setzermann Jul 9, 2016 public
How to calculate the median per group with MySQL 3 min read →

The best way to convert a screen recording (or any video) to a gif both in quality and size

A gif of a screen recording has proven itself to be a very practical solution to make tutorials easier to understand. The gif has the big advantage th

Daniel Setzermann Jun 5, 2016 public
The best way to convert a screen recording (or any video) to a gif both in quality and size 2 min read →

How to build an analogue dashboard for digital metrics – like the current number of visitors on your site

Update 2025: This doesn't work anymore – the post is kept alive because I still like what I've done back then. But don't try to rebuild th

Daniel Setzermann May 29, 2016 public
How to build an analogue dashboard for digital metrics – like the current number of visitors on your site 6 min read →

How to get started with Markdown: Your new best friend when writing any line of text

Markdown is a text-to-HTML conversion tool for web writers. Markdown allows you to write using an easy-to-read, easy-to-write plain text format, then

Daniel Setzermann Apr 13, 2014 public
How to get started with Markdown: Your new best friend when writing any line of text 3 min read →

How to create a web icon font using illustrator and fontastic.me - meet my new mac keyboard shortcut font

So the other day I wanted to display a few keyboard shortcuts to my fellow coworkers. I wanted to display those shortcuts in a visual way, not just th

Daniel Setzermann Oct 26, 2013 public
How to create a web icon font using illustrator and fontastic.me - meet my new mac keyboard shortcut font 2 min read →
  • Sign up

©2026 Daniel Setzermann - Published with Ghost and Macaw.