RDBMS.md

RDBMS (Relational Database Management System)

• Relational databases are normally row based
• Postgres and MySQL are most widely used

Postgres vs MySQL

• Postgres:
  • object-relational database
  • open source, easy to install, highly extensible
  • implements Multi-version Concurrency Control (MVCC) without read locks
  • protecting data integrity at the transaction level
• MySQL
  • purely relational database
  • most popular
  • better performance on large scale of data (larger than millions)

Reference

• MySQL vs PostgreSQL -- Choose the Right Database for Your Project | Okta Developer
• Why Uber Engineering Switched from Postgres to MySQL | Uber Engineering Blog