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.
PostgREST automates REST API creation from PostgreSQL, improving speed and security.
Jacob Padilla's article demystifies Python asyncio through a detailed tutorial.
Benn language enables parallel code execution on CPUs and GPUs without deep expertise.
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.
Python Async IO Exploration
A Python Async IO article by Jacob Padilla explores the workings of async IO from scratch, breaking down concepts like generators, event loops, and asynchronous operations. The article aims to demystify the magic of async IO and offers a detailed guide for understanding its inner workings, presenting a thorough breakdown for building a mental model.
Benn: Parallel Programming Runtime
Benn is a programming language and runtime that facilitates parallel code execution on multi-core CPUs and GPUs without deep expertise in C or CUDA. It allows writing Python-like code that runs in parallel, automatically managing the underlying parallelism and computation graphs for enhanced performance.
Upcoming PyCon Locations and Prince of Persia
The upcoming PyCon locations are discussed, with Long Beach, California set for 2026, potentially drawing larger crowds due to its attractive destination. Additionally, a memoir by Jordan Mechner, the creator of Prince of Persia, delves into the family's history and the development of the iconic video game, offering insights into his inspirations and experiences.
Work Hack Joke: Bash Script in Python
A humorous work-related joke is shared where a boss instructs a developer to rewrite a Bash script in Python, leading to a comedic approach of simply importing sub-process and calling the original Bash script from Python, showcasing a creative workaround for the task.