#385 RESTing on Postgres

Topics covered in this episode:


PostgresREST
How Python Asyncio Works: Recreating it from Scratch
Bend
The Smartest Way to Learn Python Regular Expressions
Extras
Joke

Watch on YouTube

About the show

Sponsored by Mailtrap: pythonbytes.fm/mailtrap

Connect with the hosts


Michael: @mkennedy@fosstodon.org
Brian: @brianokken@fosstodon.org
Show: @pythonbytes@fosstodon.org


Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Tuesdays at 10am PT. Older video versions available there too.

Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it.

Michael #1: PostgresREST


PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
Speedy

First the server is written in Haskell using the Warp HTTP server (aka a compiled language with lightweight threads).
Next it delegates as much calculation as possible to the database.
Finally it uses the database efficiently with the Hasql library

PostgREST handles authentication (via JSON Web Tokens) and delegates authorization to the role information defined in the database. This ensures there is a single declarative source of truth for security.


Brian #2: How Python Asyncio Works: Recreating it from Scratch


Jacob Padilla
Cool tutorial walking through how async works, including

Generators Review
The Event Loop
Sleeping
Yield to Await
Await with AsyncIO

Another great async resource is:

Build your Own Async

David Beasley talk from 2019




Michael #3: Bend


A massively parallel, high-level programming language.
With Bend you can write parallel code for multi-core CPUs/GPUs without being a C/CUDA expert with 10 years of experience.
It feels just like Python!
No need to deal with the complexity of concurrent programming: locks, mutexes, atomics... any work that can be done in parallel will be done in parallel.


Brian #4: The Smartest Way to Learn Python Regular Expressions


Christian Mayer, Zohaib Riaz, and Lukas Rieger
Self published ebook on Python Regex that utilizes

book form readings, links to video course sections
puzzle challenges to complete online

It’s a paid resource, but the min is free.


Extras

Brian:


Replay - A graphic memoir by Prince of Persia creator Jordan Mechner, recounting his own family story of war, exile and new beginnings.


Michael:


PyCon 2026


Joke: Shells Scripts