On 5/10/16, Marco Silva 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