What is the SQLite query to detect if the FTS3 extension module is installed? Or is it possible to get a list of installed extensions with an SQLite3 query? It has to work with pysqlite2.
I know that I can get the list of tables using SELECT * FROM sqlite_master
, I'd like to get something similar for the list of extensions. I also know that CREATE VIRTUAL TABLE v USING FTS3 (t TEXT)
succeeds iff FTS3 is installed, but I'd like to get a query without side effects (not even creating a temporary table).
As a workaround I have opened the ":memory:"
database, and issued the CREATE VIRTUAL TABLE
command above.