Re: How to choose a database

Hope below comparison helps to some extent in taking the decision in regards to AWS offering prospect. And ofcourse this has to be thought through along with the type of business one deals with, say for example, you said financial transaction which must consider consistency as key feature etc. I am, not sure of yugabyte db feature details but it would be great if anybody can add to that and any other databases. And any additional features can be added if missed. And ofcourse these are all not the hard liners and can change with future developments but just to provide some idea about the offerings. And not to mention, please correct me if any of the features has been wrongly put.

https://gist.github.com/oraclelearner/16c9191822601936c3f4b179f4523f7a

On Mon, 24 Apr, 2023, 8:41 am Mladen Gogala, <gogala.mladen_at_gmail.com> wrote:

> On 4/23/23 14:34, Lok P wrote:
>
> And i think finally the OP is asking about, if we consider choosing a
> database for a brand new application which is going to be hosted on cloud
> (say e.g. AWS), how should one choose between cockroach, yugabyte, and
> aurora for OLTP/RDBMS OR between Snowflake and Redshift for OLAP app?
>
> You choose a database, like you would choose anything else, like a car.
> You take into account the price, the performance and familiarity. How would
> you choose a car? You would first think about the purpose of buying a car.
> Do you need a pickup truck, SUV, family sedan or sporty toy for showing
> off, like Porsche or Camaro? The same thing is with the databases: do you
> need a data warehouse DB like Snowflake, do you need an OLTP database like
> Aurora, EnterpriseDB or DB2? What do you need the database for? How well
> versed are your developers in the particular DB flavor? What color of the
> database do you need? Allegedly, mauve takes the least RAM.
>
> There is insufficient information for a sensible answer.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l