Skip to main content

Databases

Overview:

DatabaseNotesBest for
Postgresqlcurrent industry standardselfhosting
Sqlitein single process with code, low latencysmall apps read heavy few concurrent users, embedded, phone apps
Mysqlused in wordpress
Oracle DBsecure and fault tolerant, managedoracle ecosystem

Mysql​

sudo apt install  mariadb-client-compat
mysql -h 127.0.0.1 -P 3306 -u root -p

Sqlite​

.tables

Database Normalization​

FormDescription
1 Normal Form
2 Normal Form
3 Normal Form

Database Migration​

Flyaway

Liquidbase