Which SQLite design pattern is currently recommended?

I was thinking of implementing a singleton design pattern for a database that my app has rather than going through the costly operation of making and destroying instances of my database.

However, a little while back I'd read that there were a couple of options for Android and SQLite (but I can't remember what, and I can't find the link) and so I was wondering, what design patterns are recommended for these databases, and what are their pros/cons?

Thanks, Liam