Artwork

Content provided by Tomasz Nurkiewicz. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Tomasz Nurkiewicz or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

#68: ACID transactions: don't corrupt your data

4:16
 
Share
 

Manage episode 319149226 series 2680464
Content provided by Tomasz Nurkiewicz. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Tomasz Nurkiewicz or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

Transactions in SQL databases are rock-solid. By reading and modifying data within a transaction we limit the risk of data corruption. Actually, there’s an acronym describing transactions: ACID. Which stands for: atomicity, consistency, isolation and durability. A good database engine follows these properties religiously. NoSQL engines, on the other hand, trade ACID properties for availability or speed. Of course, this is a gross simplification. Anyways, NoSQL crowd coined another acronym: BASE. Which stands for: basically available, soft state and eventually consistent. We’ll leave BASE for another episode.

Read more: https://nurkiewicz.com/68

Get the new episode straight to your mailbox: https://nurkiewicz.com/newsletter

  continue reading

98 episodes

Artwork
iconShare
 
Manage episode 319149226 series 2680464
Content provided by Tomasz Nurkiewicz. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Tomasz Nurkiewicz or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

Transactions in SQL databases are rock-solid. By reading and modifying data within a transaction we limit the risk of data corruption. Actually, there’s an acronym describing transactions: ACID. Which stands for: atomicity, consistency, isolation and durability. A good database engine follows these properties religiously. NoSQL engines, on the other hand, trade ACID properties for availability or speed. Of course, this is a gross simplification. Anyways, NoSQL crowd coined another acronym: BASE. Which stands for: basically available, soft state and eventually consistent. We’ll leave BASE for another episode.

Read more: https://nurkiewicz.com/68

Get the new episode straight to your mailbox: https://nurkiewicz.com/newsletter

  continue reading

98 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide