You don't have to close your database every time if you manage it with a ContentProvider. I've used SQLite on Android like that without many issues, although the boilerplate can be too much using SQLite as is. You can also create views to avoid including queries in java code.