Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

List sqlite3 extensions that are loaded?

Tags:

sqlite

Is there any way to have SQLite3 list the extensions that it has loaded? I'd like to know if the FTS3, FTS4 or FTS5 extension are loaded, without just trying functions and see if they work.

like image 818
vy32 Avatar asked Oct 10 '18 20:10

vy32


People also ask

What are SQLite extensions?

An SQLite extension is a shared library or DLL. To load it, you need to supply SQLite with the name of the file containing the shared library or DLL and an entry point to initialize the extension. In C code, this information is supplied using the sqlite3_load_extension() API.

Is SQLite and sqlite3 the same?

The wiki tag description for both tags is the same: SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The sqlite3 has no synonyms but sqlite has sqlitedatabase as a solitary synonym.

Is SQLite free for commercial use?

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.

Is sqlite3 open source?

SQLite source code is in the public-domain and is free to everyone to use for any purpose.


1 Answers

Use:

sqlite> PRAGMA compile_options;

like image 130
toreric Avatar answered Oct 07 '22 22:10

toreric