Ends in:
1 DAY
23 HRS
43 MIN
18 SEC
Ends in:
1 D
23 H
43 M
18 S
Open Closed

Which database would you prefer? #4968


User avatar
0
portx-dev created

We are troubled with DB selection and provider selection. My experience is MySQL + AWS.

I have a few questions there. ・When using ABP Commercial, what are the advantages and disadvantages of SQL server / MySQL / PostgreSQL?

・In terms of ABP Commercial support, are you the best at supporting SQL server out of the three: SQL server / MySQL / PostgreSQL?

・Are most users of ABP Commercial choosing SQL server + Azure?

  • ABP Framework version: v7.1

7 Answer(s)
  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    Hi,

    When using ABP Commercial, what are the advantages and disadvantages of SQL server / MySQL / PostgreSQL?

    There is no difference for ABP Commercial whether to use SQL server MySQL or PostgreSQL, they are consistent experiences.

    As databases, they have some differences, you can check:

    https://jelvix.com/blog/mysql-postgresql-sql-server

    In terms of ABP Commercial support, are you the best at supporting SQL server out of the three: SQL server / MySQL / PostgreSQL?

    You can choose the database according to your preferences and experience, as I know, the Azure SQLServer is good, the only downside is that it is expensive

    Are most users of ABP Commercial choosing SQL server + Azure?

    As far as I know, more people will use SQLServer. but I'm not sure. we do not have accurate statistics.

  • User Avatar
    0
    portx-dev created

    I found SQLServer to be very expensive. (I want you to answer intuitively.) Which do you think are the most popular ABP Commercial users, MySQL or PostgreSQL?

  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    Hi,

    For me, I prefer PostgreSQL. also ABP platform uses PostgreSQL

  • User Avatar
    0
    portx-dev created

    thank you. Any idea why Abp chose PostgreSQL?

    I have already read the following articles. https://blog.abp.io/abp/Migrating-from-MS-SQL-to-Postgresql We understand that ABP chose PostgreSQL for its price advantage.

  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    Hi,

    Because of price advantage.

  • User Avatar
    0
    portx-dev created

    thank you. Have you considered MySQL? If so, I would like to know why you excluded MySQL.

  • User Avatar
    0
    EngincanV created
    Support Team .NET Developer

    thank you. Have you considered MySQL? If so, I would like to know why you excluded MySQL.

    The license cost for MS-SQL on Azure was significantly higher than PostgreSQL. This is also valid for MySQL. Therefore, after conducting a cost-benefit analysis, we migrated our database to PostgreSQL to save costs. Also, it has more features and good scalability than MySQL, as far as I see.

Made with ❤️ on ABP v9.1.0-preview. Updated on December 02, 2024, 12:35