Dive into the evolution of SQLite with Turso, a modern, scalable solution for data management! Discover how it pairs with Lightstream for seamless database replication. Learn about PEP 792 and its project status markers, improving Python package classification. Uncover the importance of coverage testing in software development and how Docker images can be transformed into executable files. The hosts share insights with a sprinkle of humor, making it an engaging listen!
27:48
forum Ask episode
web_stories AI Snips
view_agenda Chapters
auto_awesome Transcript
info_circle Episode notes
insights INSIGHT
Turso: Modern SQLite Evolution
Turso evolves SQLite with Rust for a scalable, distributed database with async IO and AI-centric features like vector search.
It’s not production-ready but represents a modern rethinking of SQLite’s architecture and capabilities.
insights INSIGHT
Litestream Enables SQLite Replication
Litestream continuously streams changes from SQLite to cloud blob storage for simple, cheap failover and replication.
This approach keeps using native SQLite but adds fault tolerance and cloud syncing without changing SQLite itself.
insights INSIGHT
PEP 792 Simplifies Project Status
PEP 792 proposes a single project status marker for PyPI packages: active, archived, quarantined, or deprecated.
This clarifies multiple confusing existing status signals and enhances dependency resolution and security.
Get the Snipd Podcast app to discover more snips from this episode
Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Monday 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: Distributed sqlite follow up: Turso and Litestream
Michael Booth:
Turso marries the familiarity and simplicity of SQLite with modern, scalable, and distributed features.
Seems to me that Turso is to SQLite what MotherDuck is to DuckDB.
Mike Fiedler
Continue to use the SQLite you love and care about (even the one inside Python runtime) and launch a daemon that watches the db for changes and replicates changes to an S3-type object store.