There were already several posts about using db4o on Android. But what about SQLite, which comes together with Android SDK? The best way to select between the 2 databases is to compare. Now you can do it easily:
- download simple comparison application DBCompare
- read supporting documentation
- modify DBCompare code to support your application model and make a decision based on the results.
DBCompare uses db4o and SQLite side-by-side to perform simple persistence operations: store, select, query, delete, modify. It also compares open and close database operations and hot backup ability. DBCompare uses very simple objects for its tests, so it can't be considered a reliable benchmark, as the real-world objects tend to be much more complex. However, if you already have an idea of how your object model will look like - you will find it easy to modify the application to support your object model (or part of it) and perform some simple tests.