Cloud Fundamentals
/Beginner
MySQL / PostgreSQL
Definition
The two most dominant open-source relational database engines in the world, natively supported and fully managed by every major cloud provider.
Explain Like I'm New
The classic, highly-structured tables of rows and columns. Almost every traditional website on the internet stores user data using one of these two databases.
Real World Example
A company migrates their on-premise PostgreSQL database to AWS RDS PostgreSQL. Because the cloud provider uses the exact same open-source engine, the app doesn't require any code changes to connect to the new cloud database.
Common Use Cases
- •E-commerce platforms
- •User authentication tables
- •Structured relational data
Interview Questions
basic
- Are MySQL and PostgreSQL considered Relational (SQL) or Non-Relational (NoSQL) databases?
intermediate
- What is 'Amazon Aurora' and how does it relate to MySQL/PostgreSQL?