this post was submitted on 28 Aug 2025
386 points (99.2% liked)

Programmer Humor

26071 readers
1114 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] CosmicTurtle0@lemmy.dbzer0.com 12 points 4 days ago (1 children)

You've gotten good answers from other folks but I'll provide a ELI5:

Basically a set of rules in the database to make sure that it is immediately consistent.

NoSQL databases offer eventual consistency in exchange for speed so they are generally not considered to be ACID compliant.

Most traditional databases (MySQL, postgresql, etc.) are.

There are a couple of emerging companies that try to tackle speed for traditional databases. CockroachDB offers a postgress-based database that scales more like NoSQL while still offering ACID transactions.

TiDB is a similar company but for MySQL.

[โ€“] mcv@lemmy.zip 3 points 4 days ago

Not all NoSQL databases are the same. Neo4j is acid compliant, and lightning fast for complex relationships that relational databases struggle with.