π¨βπ»Databases
I'm planning to go back to SQL databases for better long-term benefits such as complex analytics queries where NoSQL technologies might have hiccups.
Why Postgres?
Better on complex queries
Perfect for enterprise
Open source
Why MySQL?
Great for web apps
Ease of use
Optimized
Small to Medium
Owned by Oracle
Tutorials
π½οΈ Set Up a Postgres on Amazon RDS with PGAdmin: https://www.youtube.com/watch?v=XDMgXZUfa10
π½οΈ Set Up a Postgres on Amazon RDS with DBeaver: https://www.youtube.com/watch?v=XF1ZADfH0EQ
π½οΈ Creating an RDS PostgreSQL Database on the AWS Free Tier: https://www.youtube.com/watch?v=I_fTQTsz2nQ
π½οΈ AWS RDS vs AWS Aurora for MySQL: https://www.youtube.com/watch?v=yHCwjAbwS6M
π½οΈ AWS RDS vs AWS Aurora for Postgres SQL: https://www.youtube.com/watch?v=rQlp2PzklYE
Comparisons
π½οΈ MySQL vs Postgresql vs Microsoft SQL Server by Alex The Analyst: https://www.youtube.com/watch?v=Q7i6zxHVj2Q
π½οΈ SQL vs NoSQL: https://www.youtube.com/watch?v=ruz-vK8IesE
π½οΈ SQL vs NoSQL: https://www.youtube.com/watch?v=t0GlGbtMTio
π½οΈ PostgreSQL vs MySQL: https://www.youtube.com/watch?v=btjBNKP49Rk
π½οΈ How to Choose a Database on AWS: https://www.youtube.com/watch?v=eK_umMYxZfM
Last updated