Software Alternatives & Reviews

Amazon RDS for PostgreSQL VS MySQL

Compare Amazon RDS for PostgreSQL VS MySQL and see what are their differences

Amazon RDS for PostgreSQL logo Amazon RDS for PostgreSQL

PostgreSQL as a Service

MySQL logo MySQL

The world's most popular open source database
  • Amazon RDS for PostgreSQL Landing page
    Landing page //
    2021-10-29
  • MySQL Landing page
    Landing page //
    2022-06-17

Amazon RDS for PostgreSQL videos

Amazon RDS for PostgreSQL/Amazon Aurora PostgreSQL Operational Best Practices | AWS Events

MySQL videos

MySQL IN 10 MINUTES (2020) | Introduction to Databases, SQL, & MySQL

More videos:

  • Review - A Review of MySQL Open Source Software

Category Popularity

0-100% (relative to Amazon RDS for PostgreSQL and MySQL)
Databases
5 5%
95% 95
Relational Databases
4 4%
96% 96
Cloud Hosting
100 100%
0% 0
NoSQL Databases
0 0%
100% 100

User comments

Share your experience with using Amazon RDS for PostgreSQL and MySQL. For example, how are they different and which one is better?
Log in or Post with

Reviews

These are some of the external sources and on-site user reviews we've used to compare Amazon RDS for PostgreSQL and MySQL

Amazon RDS for PostgreSQL Reviews

We have no reviews of Amazon RDS for PostgreSQL yet.
Be the first one to post

MySQL Reviews

MariaDB Vs MySQL In 2019: Compatibility, Performance, And Syntax
MySQL: MySQL is an open-source relational database management system (RDBMS). Just like all other relational databases, MySQL uses tables, constraints, triggers, roles, stored procedures and views as the core components that you work with. A table consists of rows, and each row contains a same set of columns. MySQL uses primary keys to uniquely identify each row (a.k.a...
Source: blog.panoply.io
20+ MongoDB Alternatives You Should Know About
MySQL® is another feasible replacement. MySQL 5.7 and MySQL 8 have great support for JSON, and it continues to get better with every maintenance release. You can also consider MySQL Cluster for medium size sharded environments. You can also consider MariaDB and Percona Server for MySQL
Source: www.percona.com

Social recommendations and mentions

Based on our record, Amazon RDS for PostgreSQL should be more popular than MySQL. It has been mentiond 14 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

Amazon RDS for PostgreSQL mentions (14)

  • Deploying Django Application on AWS with Terraform - Part 1
    Yay! We have now deployed our Django web application with ECS Service + Fargate on AWS. But now it works with SQLite file database. This file will be recreated on every service restart. So, our app cannot persist any data for now. In the next article we’ll connect Django to AWS RDS PostgreSQL. - Source: dev.to / about 1 month ago
  • gactive: Active-active Replication Extension for PostgreSQL on Amazon RDS
    Today, AWS announces the general availability of pgactive: Active-active Replication Extension for PostgreSQL, available for Amazon Relational Database Service (RDS) for PostgreSQL. Pgactive lets you use asynchronous active-active replication for streaming data between database instances to provide additional resiliency and flexibility in moving data between database instances, including writers located in... Source: 7 months ago
  • Hosting my Software
    Best practice would definitely be setting up a separately hosted database (I swear I'm not an AWS shill) for production as this ensures much better data integrity. Plus it manages backups etc. For you. Source: about 1 year ago
  • Render/Heroku to AWS migration
    For Postgres I’d use RDS for Postgres and for your Node app well I mean you’ve got a plethora of options. Elastic Beanstalk, ECS, App Runner, EC2, etc. If you really want to go the 0 managed hardware approach I’d go with App Runner if your application is already containerized and if not then Elastic Beanstalk. Source: over 1 year ago
  • Ask HN: What is your distributed and fault-tolerant PostgreSQL setup?
    How cash strapped? Personally, I would just use something managed like AWS's RDS for PostgreSQL https://aws.amazon.com/rds/postgresql/ Then you don't need to worry too much about administrative tasks. As a bonus, you can start out small and easily scale as you grow, versus self-managed. It doesn't have to be AWS. You can find similar offerings from pretty much any cloud provider. - Source: Hacker News / over 1 year ago
View more

MySQL mentions (4)

  • I have a recurring issue with a MySQL DB where I continually run out of disk space due to logs being filled. I've tried everything I can think of. Can anyone think of anything else I should try?
    So, I did a quick read through the mysql reference and found a bunch of flush related commands. I tried:. Source: 11 months ago
  • MMORPG design resources
    MySQL: Any SQL or DB knock-off, really... mysql.com - mariadb.org - sqlite.org. Source: over 1 year ago
  • Probably a syntax error
    15 years and five strokes ago. I was a Unix sysadmin. ALthough I was never an actual programmer, I did maintenance/light enhancement for the organization's website, in php. Now, as self-administered cognative therapy, I'm going back to it. This is an evil HR application that uses the mysql.com employees sample database. The module below enables the evil HR end user to generate a list of the oldest workers so... Source: almost 3 years ago
  • An absolute nightmare with mysql 8.0.25
    I always use the packages from mysql.com, that way I don't have to deal with strange configuration stuff along those lines, but anyway, I'm afraid I'm out of ideas. Surely someone else would have run in to the same issue here though. Source: almost 3 years ago

What are some alternatives?

When comparing Amazon RDS for PostgreSQL and MySQL, you can also consider the following products

Amazon Aurora - MySQL and PostgreSQL-compatible relational database built for the cloud. Performance and availability of commercial-grade databases at 1/10th the cost.

PostgreSQL - PostgreSQL is a powerful, open source object-relational database system.

Application Load Balance - Automatically distribute incoming traffic across multiple targets using an Application Load Balancer.

Microsoft SQL - Microsoft SQL is a best in class relational database management software that facilitates the database server to provide you a primary function to store and retrieve data.

Neon Database - Postgres made for developers. Easy to Use, Scalable, Cost efficient solution for your next project.

MongoDB - MongoDB (from "humongous") is a scalable, high-performance NoSQL database.