When to close SQLite database (using FMDB)
fmdb, sqlite
Solution
I'm the guy who wrote FMDB.
Keep it open unless you change your schema. That's the only reason to close it, and constantly re-opening it is a little hit on performance / battery life.
Problem
When should you close the connection to an SQLite database (using [db close] in FMDB)? Right now I am closing it after running every batch of related queries, but should I rather close when my app closes? What are the pros/cons of doing either way? Thanks