How Can I See Which Sqlite3 Binary Does The Sqlite3 Python Module Use On Ubuntu 16.04?

How can I see which sqlite3 binary (containing the SQLite relational database management system) does the sqlite3 Python module use on Ubuntu 16.04? I unsuccessfully looked at /usr

Solution 1:

It's not going to use the sqlite3 executable directly if that's what you're thinking. It's going to be linked to the sqlite3 dynamic library installed on your system. To find out which particularly library it's linked to, use ldd on the _sqlite3 python c extension. The _sqlite3 module is the underlying interface that the sqlite3 module relies on.

$ ldd `find /usr/lib/python3.7/ -name '_sqlite3*'` | grep sqlite
    libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f47705a2000)