What’s the difference between ACID and BASE in databases?

23 Eyl 10:00

I keep hearing about ACID and BASE when people discuss relational versus non‑relational databases. Could someone break down what each term actually means, the guarantees they provide, and when you’d prefer one model over the other? Also, are there any practical scenarios where mixing the two concepts makes sense? Would love to hear your explanations.