Connection Status of SQLite in IOS

Question

Is there a way one can check the connection status of a SQLite DB in IOS. I do not want to keep opening the db connection again and again. As a work around, I have put the SQLite DB object into a static variable and check if the object is NIL, else use the object as is.

Is there a simpler and cleaner way to do this

Answer 1

A lot of SQLite Wrappers for iOS provide this functionality. Here is a library I wrote for handling SQLite connections which you can use to check the status of a connection: https://github.com/ziminji/objective-c-sql-query-builder