Geek Answers Handbook

Best Alternative SQLite Android Library?

For for some reason, I want to avoid the official implementation of SQLite for Android.

It seems that there are very few alternatives, and they seem very new, untested - there are many libraries with a small number of implemented operations.

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

  • SQLite format
  • Sets SELECT, INSERT, UPDATE, DELETE
  • Basic WHERE with indexes
  • Indexes updated (I do not ask for a new index to be created)
  • Open source

Note. I recently ported SQLJet to Android, and I just saw the SQLdroid website (not sure what it does). I am surprised that I cannot find the Android SQLite plugin, which may also be acceptable.

+8
android sqlite
source share
3 answers

Have you checked BerkeleyDB ? (good paper here )

Or H2 ?

+1
source share

I have been using SQLiteJDBC in a Java desktop application for a couple of years with good results. I'm not sure how difficult it is to port to Android, but it includes a pure-java driver built from SQLite sources (it uses NestedVM , which compiles everything into a MIPS command set, then creates a virtual machine in Java to execute the code - slowly, but it works). Otherwise, it also has built-in compiled binaries for multiple (desktop) platforms.

If you are not worried about the speed or size of your .apk (.jar with only NestedVM code is about 1.1 MB), this might work for you.

+1
source share

You can try OrmLite . I think this is convenient for you: lightweight, SQLite support with basic CRUD features. And it's easy to find out.

You can branch it from Git

Object Relational Mapping Lite (ORM Lite) provides little functionality for storing Java objects in SQL databases, while avoiding the complexity and overhead of more standard ORM packages. It supports multiple SQL databases using JDBC, and also supports Sqlite with native Android database API calls.

+1
source share

More articles:


All Articles