Podchaser Logo
Home
#385: RESTing on Postgres

#385: RESTing on Postgres

Released Monday, 27th May 2024
Good episode? Give it some love!
#385: RESTing on Postgres

#385: RESTing on Postgres

#385: RESTing on Postgres

#385: RESTing on Postgres

Monday, 27th May 2024
Good episode? Give it some love!
Rate Episode

Topics covered in this episode:

Watch on YouTube

About the show

Sponsored by Mailtrap: pythonbytes.fm/mailtrap

Connect with the hosts

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:

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:

Joke: Shells Scripts

Show More
Rate

Join Podchaser to...

  • Rate podcasts and episodes
  • Follow podcasts and creators
  • Create podcast and episode lists
  • & much more

Episode Tags

Do you host or manage this podcast?
Claim and edit this page to your liking.
,

Unlock more with Podchaser Pro

  • Audience Insights
  • Contact Information
  • Demographics
  • Charts
  • Sponsor History
  • and More!
Pro Features