On Thu, 2023-09-21 at 01:17 +0530, veem v wrote:
> I see multiple docs on the internet, stating the difference between Mysql and postgres.
> But I want to understand the real views of the experienced folks here.
>
> While we are on AWS and planning to opt for one of the relational databases out of
> mysql and postgres for our application(It is a Hybrid type, mostly dealing with
> batch processing but also supporting OLTP type UI screens etc. and ACID transactions preferred).
>
> What all things/parameters should we keep in mind here for opting a database?
> or in other words how to evaluate the suitable database for our application?
You are asking the wrong people. We here on the PostgreSQL mailing list will tell
you that you shouldn't touch MySQL except with a long stick, and for almost all
use cases PostgreSQL is preferable. The people on MySQL mailing lists or forums
might tell an entirely different story.
I would say something about license and free software, but if you plan to lock
yourself into the cage of a cloud hosted database, that probably doesn't matter much.
Yours,
Laurenz Albe