Sqlite and composer scenes

Solar2D General Questions/Discussion
#1

I’m building an app where almost all of my composer scenes (about 25) need to access (read/write) the same sqlite local database. Until now, i’ve required the sqlite3 module and open a connection to the database in each scene. Is this the best way to go?

Or should I create a database module which opens the connection to the database and each scene could then access this module with the already opened connection?

Or is there another better way? 

#2

I would open it once, and keep a handle to in in a global or a module that is then required from each scene.

#3

I would open it once, and keep a handle to in in a global or a module that is then required from each scene.