Best place to close database connection

by

According to this post by a Google engineer (Dianne Hackborn), there’s nothing wrong with leaving the database connection open:

Android made a deliberate design decision that is can seem surprising,
to just give up on the whole idea of applications cleanly exiting and
instead let the kernel clean up their resources. After all, the
kernel needs to be able to do this anyway. Given that design, keeping
anything open for the entire duration of a process’s life and never closing it is simply not a leak. It will be cleaned up when the
process is cleaned up.

So, for simplicity, I would extend the Application class to provide a single well-defined entry point for your code, and open the database connection in its onCreate(). Store the DB connection as a field in your Application, and provide an accessor method to make the connection available to rest of your code.

Then, don’t worry about closing it.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Android SQLite database: slow insertion
  5. Pros and Cons of SQLite and Shared Preferences [closed]
  6. Share SQLite database between 2 android apps?
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Android SQLite Example [closed]
  10. Android database encryption
  11. Import .csv file to Sqlite in Android
  12. Cursor adapter and sqlite example [closed]
  13. How to add new Column to Android SQLite Database?
  14. How to retrieve data from sqlite database in android and display it in TextView
  15. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  16. How do I create a database in android? [closed]
  17. Android SimpleCursorAdapter doesn’t update when database changes
  18. Android SQLite Database, WHY drop table and recreate on upgrade
  19. SQLite simultaneous reading and writing
  20. update sql database with ContentValues and the update-method
  21. Create SQLite database in android
  22. Could not allocate CursorWindow
  23. Saving ArrayLists in SQLite databases
  24. android, how to exec a sql file in sqlitedatabase
  25. SQLiteOpenHelper – creating database on SD card
  26. SQLite android column not found
  27. How to store JSON object in SQLite database
  28. H2 Database vs SQLite on Android [closed]
  29. SQLiteOpenHelper onUpgrade() Confusion Android
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment