Rubius / Realmius

Realtime sync engine for Realm mobile database (Xamarin) with DotNet backend
Apache License 2.0
18 stars 8 forks source link

Ability to change database backend #19

Open bugproof opened 6 years ago

bugproof commented 6 years ago

I see the project uses Entity Framework? Would it be hard to change it to MySQL or other db?

jromerus commented 6 years ago

Hi, I'm checking this project and it's really amazing. It would be great it could work with other databases or provide some documentation of how to implement a new provider.

Regards, José Enrique

jromerus commented 6 years ago

It would also be very useful if the same instance could work with several databases so could avoid several Realmius instances (one per database).

Shaddix commented 6 years ago

We haven't tested it with MySQL, but as part of migration to EFCore we plan to make it work at least with PostgresSQL

jromerus commented 6 years ago

Sounds great. However I will try to made a fork to actual version and test against mysql. In fact I have started and have found few problems with sql server tied type such as DateTimeOffset. At first I will try to simply replace those types in order to see if it works or it has negative impact.

jromerus commented 6 years ago

I can't find the way to solve DateTimeOffset dependencies in order to implement a mysql connector layer. So thinking about new releases, what do you think about pull apart a server logic layer from a server backend layer? That way it would be easier to implement a db connector with desired technology (nor only EFCore, but also Xpo or nhibernate)