Reasons to Use a SQL Database
Many businesses use both relational databases and non-relational databases. While NoSQL databases are gaining popularity due to their speed and scalability, you might prefer highly structured SQL databases in certain cases.
Prerequisite
For an introduction to relational databases and NoSQL databases, see Types of databases.
Understand when to choose a SQL database
You might choose an SQL database for the following reasons:
-
You want to ensure ACID compliance. ACID stands for atomicity, consistency, isolation, and durability. ACID compliance reduces anomalies and protects the integrity of your database by prescribing exactly how transactions interact with the database.
-
Your data is structured and unchanging. If your business isn’t experiencing significant growth that would require additional servers and you’re working only with consistent data, then an SQL database might be adequate.
Next step
Reasons to use a NoSQL database
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.
Updated 11 months ago