Best alternative Android SQLite library?

Question

For some reason I want to avoid Android's official SQLite implementation.

There seem to be very few alternative, and they seem to be very new, not-tested-much libraries with few operations implemented.

I hope to not be too subjective, but here are the features I need:

SQLite format
Has SELECT, INSERT, UPDATE, DELETE
Basic WHERE, with indexes
Indexes are updated (I am not asking for new index creation)
Open Source

Note: I recently ported SQLJet to Android, and I just saw the website of SQLdroid (not sure what it does). I am surprised I can't find any fork of Android's SQLite, that could be acceptable as well.

Since SQLJet is either commercial or GPL it cold cause difficulties with licensing it for cs projects. — Dyonisos, Nov 14 '11 at 15:41
@Dyonisos GPL is perfect for us. Actually our whole project is GPL too. — Nicolas Raoul, Nov 15 '11 at 02:37
Could someone please migrate this question to Software Recommendations? http://softwarerecs.stackexchange.com — Nicolas Raoul, May 30 '14 at 04:55

haotang · Answer 1 · 2014-06-02T04:26:45.510

You can try OrmLite. I think it is convenient for you: lightweight, SQLite support with basic CRUD functionality. And it is easy to learn.

You can fork it from Git

Object Relational Mapping Lite (ORM Lite) provides some lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages. It supports a number of SQL databases using JDBC and also supports Sqlite with native calls to Android OS database APIs

score 1 · Answer 2 · edited May 23 '17 at 12:17

1

Have you checked the BerkeleyDB? (nice paper here)

Or H2?

edited May 23 '17 at 12:17

Community

1
1

answered Oct 14 '11 at 10:43

Regex Rookie

10,432
15
54
88

My app is for *.anki files, which are actually SQLite databases. That's the standard file format for several applications on PC/Mac/Linux/ios/Android, I can't change it. – Nicolas Raoul Oct 14 '11 at 15:49
@Nicolas Raoul Sorry, I didn't realize the file format compatibility is a requirement. – Regex Rookie Oct 14 '11 at 18:42

score 1 · Answer 3 · answered Jan 24 '12 at 17:54

I've been using SQLiteJDBC in a desktop Java app for a couple of years now, with good results. I'm not sure how hard it would be to port to Android, but it includes a pure-java driver generated from the original SQLite sources (It uses NestedVM which compiles everything to a MIPS instruction set, then generates a virtual machine in Java to execute the code - slow, but it works). Otherwise it also has native compiled binaries for several (desktop) platforms.

If you're not concerned about speed, or the size of your .apk (the .jar with just the NestedVM code is about 1.1MB), it might work for you.

Best alternative Android SQLite library?

3 Answers3