Android SQLite alternatives

android sqlite android-sqlite database-performance
Jake Marzen picture Jake Marzen · Feb 3, 2015 · Viewed 15.1k times · Source

I'm building a simple android RPG. Each player has access to a maximum of about 50 soldiers. Each soldier has some stats (class, hp, attack, etc), and three inventory slots. There will be only about 100 items in the game to fill these inventory slots. I was hoping to set up a relational database that would have a table for soldiers, a table for items owned, and a few other various tables.

Speed is my main concern. SQLite is the obvious first choice. However, it seems to be very bulky and geared towards databases with 1000's of rows. Is there a better option for small databases? I don't need complex queries or anything, just a way to store data and back it up to a server.

Answer

Andy B picture Andy B · Feb 3, 2015

There are two nice libs that make data persistance in Android much quicker and simpler to implement as follows;

Cupboard > https://bitbucket.org/littlerobots/cupboard (backed by sqlite)

Realm > http://realm.io/news/realm-for-android/

Realm is the newer one and seems slightly better but both seem to have similar implementations.

Hope this helps.

Related questions

How to perform an SQLite query within an Android application?

I am trying to use this query upon my Android database, but it does not return any data. Am I missing something? SQLiteDatabase db = mDbHelper.getReadableDatabase(); String select = "Select _id, title, title_raw from search Where(title_raw like " + "'%…

Read More
Set default value of an integer column SQLite

I am creating an SQLite database in android. db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" + KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NAME + " TEXT NOT NULL, " + KEY_WORKED + " INTEGER, " + KEY_NOTE + " INTEGER);"); Is it possible to set the default value of …

Read More
When is SQLiteOpenHelper onCreate() / onUpgrade() run?

I have created my tables in my SQLiteOpenHelper onCreate() but receive SQLiteException: no such table or SQLiteException: no such column errors. Why? NOTE: (This is the amalgamated summary of tens of similar questions every week. Attempting to provide a "canonical" …

Read More