Realm vs Sqlite for mobile development

database sqlite mobile xamarin realm
Medo Medo picture Medo Medo · May 11, 2016 · Viewed 27.4k times · Source

Am an Xamarin Developer , I used to use Sqlite as mobile database ,
recently Realm comes to the picture.
Any idea about Differences between them in Performance & ease of use..etc?

What is the best practice of using either one?

Answer

Mohammed Ali picture Mohammed Ali · May 11, 2016

Realm and Sqlite are quite different in many aspects.

Here are two articles you could go through to grasp the main differences:

System Properties Comparison Realm vs. SQLite
5 Reasons Why You Should Choose Realm Over CoreData/SQLite

As suggested by Slavia in the comments, take also a look to this article for a comparison of several ORMs, including Realm.

Related questions

How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More
How do I view the SQLite database on an Android device?

I have a set of data in an SQLite database. I need to view the database on a device. How do I do that? I have checked in ddms mode. The data in file explorer is empty.

Read More
Is it possible to access an SQLite database from JavaScript?

I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database and create queries (and tables) using JavaScript?

Read More