Databases
Overview:
| Database | Notes | Best for |
|---|---|---|
| Postgresql | current industry standard | selfhosting |
| Sqlite | in single process with code, low latency | small apps read heavy few concurrent users, embedded, phone apps |
| Mysql | used in wordpress | |
| Oracle DB | secure and fault tolerant, managed | oracle ecosystem |
Mysql
sudo apt install mariadb-client-compat
mysql -h 127.0.0.1 -P 3306 -u root -p
Sqlite
.tables
Database Normalization
| Form | Description | |
|---|---|---|
| 1 Normal Form | ||
| 2 Normal Form | ||
| 3 Normal Form |
Database Migration
Flyaway
Liquidbase