Visit spinellis.gr → On Hacker News Aug 2009 – Oct 2026
History & Retro Computing 5Life, Learning & Writing 4Tools & Productivity 3Society, Policy & Culture 3Software Engineering 3Systems & Performance 2
I was trying to run a simple join query on MariaDB (MySQL) and its performance was horrendous. Here’s how I cut down the query’s run time from over 380 hours to under 12 hours by executing part of it with two simple Unix commands.
Although I'm a happy (also paying) user of GitHub's offerings, there are times when I prefer to host a private repository on a server I control. Setting up your own Git server can be useful if you're isolated from the public internet, if you're subject to inflexible regulations, or if you simply want features…
Yesterday Mark Reid posted on Twitter a challenge : create a self-referential tweet (one that links to itself). He later clarified that the tweet should contain in its text its own identifier (the number after " /status/" bit should be its own URL). I decided to take up the challenge ("in order to learn a bit about…