Jan-Lukas Else

Thoughts of an IT expert

Tags: SQL


“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

Published on in 💬 Micro

Unpopular opinion: SQL is awesome and I really like writing performant SELECT statements.

View

Published on in 💬 Micro

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

View

Writing a SQL database from scratch in Go

Published on in 🔗 Links

Phil Eaton wrote a really cool article. He documented how he used Go to write a rudimentary SQL database including a CLI. It is very interesting to read how commands are parsed and analyzed. The whole thing probably has no practical use (there are already countless mature database systems), but it’s still exciting. I remembered some of the math lectures in the first semester about formal languages.

View

Jan-Lukas Else