On 5/10/16, Marco Silva <marco.prado.bs at gmail.com> wrote: > Hi, > > How do we know how many connections a database has ? Is it possible > to query it using SQL ? Is there a simple command from the sqlite3 > shell client ? >
A "connection" to a database is an open file descriptor. Some operating systems have the ability to show how many times a particular file is open, but others do not, and even among those that do, the mechanism is not standardized. Hence, there is no way of knowing in general how many connections there are on an SQLite database. -- D. Richard Hipp drh at sqlite.org
