title: Should I open a single or multiple connections to a local SQLite database?
body: <p>I am in the process of writing a Xamarin.Forms app. I have a database manager class which handles inserting, deleting, etc. from a local SQLite database. Since the DB file is locally stored on a single device, only one user will ever be accessing the DB at any given time. I'm not reading/writing to the DB often, but when I do, I'm grabbing a lot of data. </p>
  
  <p>My question is this: Should I create a single connection to the DB and simply reuse that over and over throughout the entire application, or is it better to create a new connection every time I access the DB? Creating a new connection each time would probably be more flexible (for my app anyway), but I'm worried about the overhead. </p>