Christian Kruse

Welcome. On this page you can find my software projects, my articles, my notes and my pictures.

My name is Christian Kruse. I work as a software developer and system administator at Termitel GmbH. I live in Germany in a small town called Steinfurt.

I am passionate about software development, GNU/Linux, FLOSS as well as macOS. I am also a do-it-yourself apologetic: I did a lot of things in and around my house myself. I love the hacker culture. And last but not least I am a dog owner.

This is my personal replacement for Twitter, Facebook and the other data silos. My content is mine — so if you are interested in my activity, just have a look at this page.

Sorting by multiple criterias in Elixir

Christian Kruse
Read more…
  1. 2020-07-02

    • Christian Kruse

      Software I miss for the Linux desktop:

      • a power user mail client like MailMate
      • a good graphical Git client like Tower
      • a software like Soulver or Numi (yes, I know about NaSC , but the project is Elementary-only project and seems dead)
      • a todo management software working and syncing between the desktop and my iPhone
  2. 2020-06-27

  3. 2020-06-25

    • Christian Kruse

      TIL: there is an aggregate function mode() WITHIN GROUP (ORDER BY sort_expression) in PostgreSQL. It returns the most frequent value of a group. So, for example when you have this table:

      CREATE TABLE foo (id serial, user_id integer, task_id integer);

      You can get the most frequent task ID for each user ID by using this aggregate function:

      SELECT user_id, mode() WITHIN GROUP (ORDER BY task_id)
      FROM foo
      GROUP BY user_id;
  4. 2020-06-16

  5. 2020-06-15

  6. 2020-06-11

    • Christian Kruse

      While I don’t need it (and thus don’t buy it): the PineTab is a pretty interesting device.

  7. 2020-06-10

    • Christian Kruse

      I’m hurt again. A torn muscle fiber. At least 4 weeks no running 😭💩

  8. 2020-06-09

    • Christian Kruse

      In reply to

      I’m seriously considering to switch again to a different distribution. Maybe back to Arch or something like that.