#385: RESTing on Postgres

Play on YouTube

Watch the live stream replay

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