Skip to main content

Databases

Types​

SQL​

SQL databases are relational databases that store and organizes data in tables with rows and columns. They use SQL for defining, manipulating and querying the stored data.

Also, SQL databases adhere to the principles of ACID transactions and provide a standardized way to interact with the data.

Examples: MySQL, PostgreSQL, Oracle DB, MS SQL Server, SQLite.

In the above definition ACID in an acronym for:

  1. Atomicity: Ensures all operations within a transaction are completed successfully or none of them are.
  2. Consistency: Ensures that the database remains in a valid state before and after the transaction.
  3. Isolation: Ensures transaction are executed independently of each other, preventing interference or data corruption caused by concurrent transactions.
  4. Durability: Guarantees the changes made by the transaction are permanent and will not be lost, even in the event of a system failure.