Which is the best DB to use with xamarin form app? RRS feed

  • Question

  • User350058 posted

    I found that Xamarin works with FireBase DB,but still i could not found the steps to do it.i have already created my app with sqlite DB,Since SQLite is local i will not me able to use the dynamically data changes by central DB,i have no idea on what is the option that i should go,i have many option runs around my mind like, * Use local DB SQLite as well as a External DB which is purchased * Use local DB SQLite and Google cloud/Azure DB * Remove the SQLite DB from my App and use FireBase DB

    Which is the best option among all of them or any other suggestion??

    *i dont like to spend much money on the server too* ;) If FirBase is Good could you please provide me the step to setup it .

    Wednesday, October 4, 2017 7:00 PM


  • User240901 posted

    This isn't a complete list, just stuff I have used that I can recommend.

    Ideal solutions for small apps with local storage required only. 1) SQLite (https://github.com/praeclarum/sqlite-net) 2) Settings Plugin (https://github.com/jamesmontemagno/SettingsPlugin) 3) Akavache (https://github.com/akavache/akavache) 4) Realm Database Only (https://github.com/realm/realm-dotnet)

    Ideal solutions for medium apps with some server synchronising requirements (such as app data backup) 1) Realm with Sync (https://github.com/realm/realm-dotnet) 2) Azure SQlite Store (https://github.com/Azure/azure-mobile-apps-net-client)

    Ideal solutions for enterprise apps where you need persistence and an endpoint for an API Note: This is where you probably should role your own with a seperate database and endpoint to query it.

    Databases: 1) MS SQL Server (https://www.microsoft.com/en-us/sql-server/sql-server-2016) 2) MySQL (https://www.mysql.com/) 3) Oracle 12c (http://www.oracle.com/us/corporate/features/database-12c/index.html?printOnly=1) 4) Mongo DB (https://www.mongodb.com/) 5) DB2 (https://www.ibm.com/analytics/us/en/db2/)

    Endpoints: 1) Spring Data Rest (https://projects.spring.io/spring-data-rest/) 2) Django Rest Framework (http://www.django-rest-framework.org/) 3) ASP.Net Web Api (https://www.asp.net/web-api)

    IMO, if you're going balls to the wall with a bespoke solution using any of the last technologies, if is probably worth documenting your REST API as well with something like Swagger.

    • Marked as answer by Anonymous Thursday, June 3, 2021 12:00 AM
    Wednesday, October 4, 2017 8:06 PM