I want to run certain clean-up tasks on the SQLite database only and only when there is only 1 connection(self) to SQLite.
I do not want to lock the database during the cleanup process. The main application(s) using the SQLite DB is given 1st preference. the cleanup application is executed at low priority and will stop doing the clean up of there is any database connection other than the cleanup application. The cleanup tool will connect SQLite check number of active connection, if found one will do some clean up tasks like deleted few tables, cleaning up tables etc. I don't want to manage a flag system and looking for coming out of the box from sqlite or may be from windows API. can use Process Explorer<http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx> but how to get it programmatically . http://stackoverflow.com/questions/12138260/how-can-i-count-the-number-of-open-connections-in-an-sqlite-database Is there any way to know a number of active connection SQLite has ? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
