Proper way to handle database connections

Asked Nov 18 '13 at 12:37

Active Dec 17 '13 at 03:33

Viewed 186 times

I was browsing around and I found different ways on how you should implement the database:

This says it should be open the whole time, while
This says it should be opened and closed only when data is being read/written.

which had me thinking, which is really the correct way, when applied to SQLite database running on Android? Should one have the database open during the whole lifetime of the app, or should it only be opened/closed when data is read/written?

What are the advantages and disadvantages of each of these two approaches?

edited May 23 '17 at 11:56

Community

asked Nov 18 '13 at 12:37

Simon Zettervall

1,764
1
15
31

The second link says you should call `open`/`close`; this does not reopen the DB if there is some other reference. – CL. Nov 18 '13 at 15:11
1

Use singleton design pattern. – Bishan Dec 17 '13 at 03:35
I used singleton pattern. – Glenn Dec 17 '13 at 03:36

Proper way to handle database connections

0 Answers0