article

  • 21st February 2025

SQLite3 CTE for Calmap visualization

Data grouped by dates can easily be printed like GitHup contribution maps by weeks.

Read more 
  • 13th May 2020

Generate JSON from PostgreSQL

You can easily format your query output as JSON!

Read more 
  • 4th May 2020

Weekwise Anomaly Visualization

Many metrics are easier to visualize as a weekly table. Add anomaly highlights to that as well!

Read more 
  • 29th April 2020

VS Code as Git GUI

Why search for that perfect git gui? Use VS Code!

Read more 
  • 3rd March 2020

Remind - it does what it's name says!

Just don't forget anything - use this wonderful little Unix tool that runs on plain text.

Read more 
  • 9th September 2019

Are we there yet?

Scaling time triggered checks without crons crawling all over!

Read more 
  • 27th August 2019

Cook your Scripts to APIs in 5 minutes

node-red is a fantastic tool for various stuff; here a super useful unconventional usecase for it.

Read more 
  • 25th October 2018

SQLite3 CTE tricks for time series analysis

Hands on analyze git log data with SQLite3 CTEs!

Read more 
  • 6th June 2018

Quick development envs with Docker

Before moving production envs to Docker, use it for making new dev setup painless.

Read more