Android Manage SQLite database connection

Question

I have an app that use a sqlite database. For every query (10 query selects in 10 differents methods) i open the database. It is a good choice to open db when the application is started and close it when application close? For example, creating an static reference to my DB object in MyApplication class (extends Application).

Thanks for your advices.

323go · Accepted Answer · 2013-01-02 20:16:12Z

1

Create a static singleton which keeps references to the db and other oft-used resources, such as this:

class Global {
    private static SQLiteDatabase _db = null;

    public static SQLiteDatabase getDb() {
        if( _db == null ) {
            ... assign & open _db
        }

        return _db;
    }
}

Elsewhere, just reference Global.getDb()

answered Jan 2, 2013 at 20:16

323go

14.3k6 gold badges37 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android Manage SQLite database connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related