sqlite3 fiddle
Published on in 🔗 Links
With all my SQL and SQLite posts, this link is probably also quite interesting: sqlite3 fiddle.
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.
“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.
Published on in 💬 Micro
Unpopular opinion: SQL is awesome and I really like writing performant SELECT statements.
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.
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.