What's an ACID compliant database?

retool.com · 1,790 words · saved by 1 readers

When you’re building and maintaining an application, the last thing you want to worry about is data integrity; Charging a customer the wrong amount or losing their data can be catastrophic. Thankfully, the databases you’re using — like MySQL and Postgres — take special measures to make sure that doesn’t happen. But what’s going on behind the hood? Most modern SQL DBs use transactional standards like ACID to ensure data integrity and keep your users from seeing wrong or stale data, and this post explores how they work. Data Scientists worry about long analytical queries and warehousing, but for developers, databases are all about transactions. A database transaction is a series of logically grouped database operations: insert a row here, update a record there, and more stuff like that. Your application code is constantly making transactions every time you sign up a new user or that user updates their account information. The thing about transactions, though, is that they can go very wro

What's an ACID compliant database? | Retool Blog Skip to main content // Retool Blog Sign up for Retool B B B u u u i i i l l l d d d & & & L L L e e e a a a r r r n n n 246 R R R e e e a a a d d d s s s & & & R R R e e e p p p o o o r r r t t t s s s 47 S S S h h h o o o p p p T T T a a a l l l k k k 19 R R R e e e l l l e e e a a a s s s e e e s s s 45 N N N e e e w w w s s s r r r o o o o o o m m m 20 What's an ACID compliant database? Justin G. Retool Jan 21, 2020 Copy Link Table of contents 01 All the things that can go wrong with your transactions 02 Dirty Reads 03 Non-Repeatable Reads 0

What's an ACID compliant database?

related reading