Databases feel like magic. You type SELECT * FROM cards WHERE name = 'Pikachu' and an answer comes back, instantly, from millions of rows. I've been coding for 30+ years and I still couldn't have explained to my kids what actually happens in between.

So I built one. PyDB is a small relational database written from scratch in Python, with every idea explained in plain English. It's not meant to replace Postgres. It's meant to be read .

You can try it in one line:

pip install fromscratch-pydb pydb

Enter fullscreen mode

Exit fullscreen mode

Start with a table

A table is just a grid: columns across the top, one row per thing.…