Jan-Lukas Else

Tech, life and everything else

XXXX-08-01


My Juli ‘24 in Review

Published on in ✍️ Posts
Updated on

And now July is over. Time to take a quick look back.

View

Telegram worries

Published on in 💭 Thoughts

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.

View

I moved my files to OneDrive

Published on in ✍️ Posts

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.

View

GitHub still doesn’t support IPv6

Published on in 💭 Thoughts

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.

View

My July ‘20 in Review

Published on in ✍️ Posts

Meanwhile the seventh month of this year is over and so here is my monthly review of July 2020.

View

Published on in 💬 Micro

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.

View

Jan-Lukas Else