Last post Apr 21, 2019 11:28 PM by deepalgorithm
Apr 21, 2019 01:39 PM|InspiredJide|LINK
So I decided to throw this open because I am doing some research and experimentation to pick the best open source database that has a very stable Api on efcore.
I recently tried using Mysql but am having some issues and am seeing some bad reviews that the Official Oracle version is not stable and inconsistent.
So I decided to ask you which Open source database has stable Apis.
Is it Postgre ?. If Mysql has which efcore api orm connector would you recommend aside from that of Oracle.
Please am willing to learn. So I decided to use Opensource cos I thinking of cost since Microsoft SQL db come with production license fees.
Apr 21, 2019 01:58 PM|deepalgorithm|LINK
I would use PostgreSQL.
Apr 21, 2019 02:11 PM|InspiredJide|LINK
Thanks alot. I really appreciate. Please guys I need your advice. let the advice keep rolling so if I need to change libraries I just do it very fast like asap.
Apr 21, 2019 02:49 PM|InspiredJide|LINK
I just found this two libaries
Please which is more stable for mysql
Apr 21, 2019 07:01 PM|deepalgorithm|LINK
None of those. I would use PostgreSQL
Use the one I sent in my 1st response.
If you choose MySQL, then use this:
Apr 21, 2019 08:24 PM|bruce (sqlwork.com)|LINK
there are three popular open source SQL relational databases.
1) mysql - typically the goto database for internet application, but with oracle taking control, worries some. still a very popular api (more than 1 provider), and it is the default for AWS Aurora.
2) PostgreSQL - always been popular. gaining interest after Oracle took over mysql. also used as an api for AWS Aurora.
3) SQLite - favorite internal hosted database. used by webkit browsers, and builtin in to OS/X (used for time machine) , IOS and Android. the EF core team provides the driver for SQLite.
note: as they are open source, unless .net core members are contributing, they may be late supporting the latest version of EF core features.
Apr 21, 2019 10:57 PM|InspiredJide|LINK
I am tempted to use mysql becos of Stored procedures. I use MSSQL stored procedures alot. And it seems that the Storedprocedures of Mysql is very similar to MSSql.
If not for stored procedures I would have used Postgresql without thinking 2 times.
But if I am wrong kindly correct me.
Apr 21, 2019 10:58 PM|InspiredJide|LINK
you did not mention MariaDb. it also becoming popular
Apr 21, 2019 11:28 PM|deepalgorithm|LINK
MariaDB is a fork of MySQL. I still think your best option is PostgreSQL.
And it does support Stored Procedures.