Jan-Lukas Else

Thoughts of an IT expert

🔗 Links

This is a collection of links I stumbled across and found worth sharing. Also see the blogroll for links to blogs I regularly read.


sqlite3 fiddle

Published on in 🔗 Links

With all my SQL and SQLite posts, this link is probably also quite interesting: sqlite3 fiddle.

View

“Common Table Expressions in SQL”

Published on in 🔗 Links

I’m currently working in a project that involves a lot of data processing and therefore databases. This means that we often come into contact with SQL at work and have to write an SQL query at least once a day.

View

“Friendlier SQL with DuckDB”

Published on in 🔗 Links

I come into contact with SQL almost every day, be it at work (Oracle Database) or while developing my blog software (SQLite). I don’t find SQL as bad as some others might, but sometimes SQL could be better.

View

“Cool Things People Do With Their Blogs”

Published on in 🔗 Links

I do from time to time forays through the Internet and like to visit cool blogs. Wouter has created a list with a few examples and even mentioned my blog in it. 🤓

View

“How Telegram Became the Anti-Facebook”

Published on in 🔗 Links

I read this very long article about Telegram today and somehow it left me with mixed feelings. The article is also from WIRED, but it offers more balanced coverage than an article from a year ago.

View

How many things do I own?

Published on in 🔗 Links

Even though starting my job has put me in a situation where I can sometimes afford stuff just like that, and maybe buy the occasional thing without thinking much when I should have before, I still make sure to keep the number of things I own low.

View

“Consider SQLite”

Published on in 🔗 Links

I am convinced of SQLite. For many use cases where other databases like MySQL, MariaDB or PostgreSQL are often used, SQLite would suffice, given the right design and architecture.

View

Ntfy.sh

Published on in 🔗 Links

I subscribe to the Hacker News front page via RSS. There is a lot of stuff there that I just mark as read without taking a closer look. But sometimes something catches my eye and I take a closer look. Today “Show HN: A tool to send push notifications to your phone, written in Go” is one of them.

View

web0?

Published on in 🔗 Links

With all the hype (or bullshit) about “web3”, it’s good to see a counter movement as well. Whether this site is really “web0” or just pre-“Web 2++” (my term for websites overloaded with frameworks, JavaScript and CSS) remains to be debated…

View

“The Web Is Fucked”

Published on in 🔗 Links

Kev Quirk has written a manifesto showing what bothers him about today’s web:

View

Next

Jan-Lukas Else