2020

• Advent of SQL Code, Week 2

  Welcome to the second post about Advent of Code where I continue to look at all the puzzles through my relation model glasses and solve them using only SQL. Only SQL? Stick to the end of this post to find out. For days 1 to 6 see the previous post. The text on this page alone probably does not make much sense without the Advent of Code puzzles and my proposed solutions.

  
  » Continue reading

• Advent of SQL Code, Week 1

  Advent of Code is an Advent calendar in form of a puzzle game. It’s on since 2015 and brings small programming tasks into your pre-Christmas period. I guess most people do this to learn a new programming language—which is a great idea—but for some reason, I decided to see how far I can get with just SQL. Please have a look at the puzzles by yourselves, I won’t repeat them here; I just want to share some SQL specific aspects which I think can be interesting to you. All my solutions are here on GitHub.

  
  » Continue reading

• MacPorts, OpenSSL, and Rust

  How to find out which variables to set on your Mac if you can't build a Rust project that relies on OpenSSL.

  
  » Continue reading

• Migrating Seafile from Postgres to MySQL

  I am hosting a Seafile instance for personal purposes, and for a long time, I used Postgres as database backend. It was never spectacularly supported; I think once the official documentation mentioned Postgres configuration, now there are only traces of it left.

  
  » Continue reading

• Deprecations in Java and Kotlin

  In the Java ecosystem, there is an annotation for marking code pieces as deprecated, so you do not use them in any new code. Modern IDEs can also use this to indicate that at a call location, a deprecated method is used, thus the programmer should maybe replace that call. (I will stick to methods and functions in this article, however, you can deprecate also other elements like classes, properties, …).

  
  » Continue reading