Why use databases
Databases are used for centralised storage with unrestricted limitations to read, write new data and modify existing data. Storing data in a database can also be efficient, decreases time for looking up data that you can export into another application / format without significant difficulty.Common database types
If you’re hosting a server the most common types of databases you’ll be interacting with are ‘SQL’ based. This will most likely be one of the following solutions:- MySQL (Legacy project)
- MariaDB (Modern MySQL fork)
- MSSQL (The Microsoft edition of MySQL)
.sql file when exported and can be maintained through a common interface like phpMyAdmin, Adminer or MySQL Workbench.
:::tip
You should also be able to move your databases between all three without any major difficulties but this may depend on implementation
:::