Python Bytes cover image

Python Bytes

#385 RESTing on Postgres

May 27, 2024
Topics covered in this podcast include PostgresREST, Python async IO, and Python regular expressions. PostgresREST creates RESTful APIs from PostgreSQL databases efficiently. Python async IO mechanics are explored in detail, along with a discussion on parallel programming and Bend. Additionally, Python tools and educational platforms including a book on regular expressions are discussed.
24:04

Podcast summary created with Snipd AI

Quick takeaways

  • PostgREST automates REST API creation from PostgreSQL, improving speed and security.
  • Jacob Padilla's article demystifies Python asyncio through a detailed tutorial.

Deep dives

PostgREST: Web Front-end for Databases

PostgREST is a web server for databases that exposes tables as endpoints for HTTP queries without much API work. It runs automatically and provides a restricted API, suitable for quick database exposure. It leverages Haskell, ensuring performance with 2000 requests/sec on Heroku's free tier, and focuses on delegating work to the database.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode