Introduction
A database is an organized collection of structured data that allows efficient storage, retrieval, manipulation, and management. Databases are accessed using a Database Management System (DBMS) such as MySQL, MariaDB, SQLite, PostgreSQL, and others.
A DBMS provides:
- A query language (SQL)
- User authentication and permissions
- Backup and recovery features
- Concurrency control and transactions
Below is a table of official for popular database systems:
| Database | Type | Official Documentation |
|---|---|---|
| MySQL | Relational | https://dev.mysql.com/doc/ |
| MariaDB | Relational | https://mariadb.com/kb/en/documentation/ |
| SQLite | Relational (embedded) | https://www.sqlite.org/docs.html |
| PostgreSQL | Relational | https://www.postgresql.org/docs/ |
| MongoDB | NoSQL (Document) | https://www.mongodb.com/docs/ |
| Redis | NoSQL (Key–Value) | https://redis.io/docs/ |