#420: Database Consistency & Isolation for Python Devs

Talk Python To Me

Michael Kennedy

Technology

4.8 • 635 Ratings

🗓️ 26 June 2023

⏱️ 56 minutes

🔗️ Recording | iTunes | RSS

🧾️ Download transcript

Summary

When you use a SQL database like Postgres, you have to understand the subtleties of isolation levels from "read committed" to "serializable." And distributed databases like MongoDB offer a range of consistency levels, from "eventually consistent" to "linearizable" and many options in between. Plus, it's easy enough to confuse "isolation" with "consistency!" We have A. Jesse Jiryu Davis from MongoDB back on the podcast to break it all down for us.

Transcript

Click on a timestamp to play from that location

0:00.0	When you use a SQL database like PostDress, you have to understand the subtleties of isolation levels from read committed to serializable and distributed databases such as MongoDB offer a range of consistency levels from eventually consistent to linearizable and many options in between.
0:18.7	Plus, it's easy enough to confuse isolation with consistency.
0:22.9	To break it all down first, we have A.
0:24.5	Jesse Giro Davis from MongoDB back on the podcast.
0:28.1	This is Talk Python Me.
0:29.5	Episode 420 recorded June 7, 2003.
0:37.2	Music Welcome to Talk Python, a weekly podcast on Python.
0:50.1	This is your host, Michael Kennedy.
0:51.9	Follow me on Massadon, where I'm at M. Kennedy, and follow the podcast using at TalkPython,
0:56.9	both on bostadon.org.
0:59.2	Be careful with impersonating accounts on other instances.
1:01.9	There are many.
1:03.0	Keep up with the show and listen to over seven years of past episodes at TalkPython.fm.
1:08.2	We've started streaming most of our episodes live on YouTube. Subscribe to our YouTube channel over at TalkPython.fm. We've started streaming most of our episodes live on YouTube.
1:12.1	Subscribe to our YouTube channel over at TalkPython.fm slash YouTube to get notified
1:16.3	about upcoming shows and be part of that episode.
1:20.0	This episode is sponsored by Century.
1:22.8	Don't let those errors go unnoticed.
1:24.8	Use Sentry.
1:25.7	Get started today at TalkPythonfm.fm slash Sentry.
1:28.9	And it's brought to you by InfluxDB. InfluxDB is a database purpose built for handling
1:34.3	time series data at a massive scale for real-time analytics. Try it for free at Talkithon.fm.
	...

Please login to see the full transcript.

Previous episode | Next episode

Disclaimer: The podcast and artwork embedded on this page are from Michael Kennedy, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Michael Kennedy and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.