My Juli ‘24 in Review
And now July is over. Time to take a quick look back.
Tech, life and everything else
And now July is over. Time to take a quick look back.
Telegram was always my favorite messenger, as it provided a fast and user-friendly experience on multiple devices. But one and a half years ago, I already started doubting my decision to rely on Telegram.
Probably some readers will now think about this post: “What’s wrong with you? Where have your ideals and principles gone? Microsoft is evil!” But why do I actually have to justify myself? I have my reasons and I am free in what I can and cannot do.
I am currently experimenting with whether a Scaleway Stardust instance will also suffice for me as a code server. Scaleway offers this at an incredibly low price and if you then also select that no IPv4 address should be used, then the instance costs less than 0,50 € per month.
Meanwhile the seventh month of this year is over and so here is my monthly review of July 2020.
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.