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)
-
0
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.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
For me, I prefer PostgreSQL. also ABP platform uses PostgreSQL
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
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.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
Because of price advantage.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
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.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
