H2 Database vs SQLite on Android [closed]

Closed. This question is opinion-based. It is not currently accepting answers开发者_运维问答.

---

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.

Closed 9 months ago.

The community reviewed whether to reopen this question 9 months ago and left it closed:

Original close reason(s) were not resolved

Improve this question

Because of the lack of Unicode support on the embedded SQLite database in Android

I am mostly interested in performance and stability of H2 Database vs Android SQLite

Are you guys using it? Should I be aware of any H2 database shortcomings?

---

Things are much better than I have expected. I now have an Android phone (HTC Desire, Android 2.2) and I made a first test.

Opening and closing a database is relatively slow so far (opening an existing database for the second time takes 0.2 seconds, closing about 0.2 seconds), but otherwise it looks like H2 performs quite well on Android, even if the Dalvik VM is not yet as optimized as a desktop JVM. It's too early to give concrete numbers, but Android is now a supported platform.