If anyone is wondering, why there’s no new content on this blog: I’m on vacation in northern Germany at the Baltic Sea!

I’m fine and am (mostly) enjoying the time with no internet. There’s no WiFi here and also my mobile network’s coverage isn’t optimal (o2 sucks outside of big cities). So I’m more or less forced to do a digital detox. I read books and spend time with my girlfriend instead. 😌

I also chose the right time for my vacation, now that it’s so hot and dry in most parts of Germany. Doing work during this heat wouldn’t be so comfortable. I really hope temperatures are back to normal when I’m back home.

@bekopharm Yeah, that shirt is really cool ☺️👍 But I wouldn’t wear it myself, I am already asked far too often things that you can easily find on Google DuckDuckGo. 😅

It was a nice evening yesterday with interesting discussions about different IndieWeb topics! I also used the writing hour to write some code for my custom CMS and it’s progressing well…

Answer to a comment by a reader on my last post: I know that there’s an active modding community for the Xiaomi Mi A1. However, I don’t want to use any custom ROM as long as possible, because it usually makes using banking apps etc. a lot harder and I don’t have any alternative to them. And Android 9 is still recent enough that all apps (I need) work fine. I used LineageOS on my Moto G 3rd Gen. and the Moto E 1 Gen. I had before.

Is it just my feeling or is there way less talk about custom ROMs these days? I already thought about this in 2018.

This day is successful: I created a recursive SQL CTE in SQLite even before noon. 🤓

with recursive f (i, fp, tp) as (select 1, fromPath, toPath
                                 from redirects
                                 where fromPath = ?
                                 union all
                                 select f.i + 1, r.fromPath, r.toPath
                                 from redirects as r
                                          join f on f.tp = r.fromPath)
select tp
from f
order by i desc
limit 1

This is for my new CMS project.