On Thu, May 23, 2019 at 7:39 AM Keith Medcalf <kmedc...@dessus.com> wrote:
> You can check if what you need is available on a connection and either > load it if needed or just abort: > > sqlite> select * from pragma_function_list order by 1, 2; > name builtin > ------------------------- ---------- > aavg 0 > ... > sqlite> select * from pragma_collation_list order by 1, 2; > seq name > ------------------------- ---------- > 0 ROT13 > ... > sqlite> select * from pragma_module_list order by 1; > name > ------------------------- > approximate_match > carray > completion > ... > > sqlite> select * from pragma_compile_options; > compile_options > ALLOW_COVERING_INDEX_SCAN > ... > Keith, as can be seen below, those pragma_*list eponymous vtables are you referring to as not built-in. I wasn't even aware one could get the function-list at all. Did you implement that as a pure extension w/o changing the official SQLite source code? Are all your extensions Open-Source, on GitHub or somewhere? Thanks, --DD C:\Users\ddevienne>sqlite3 SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> select * from pragma_module_list; Error: no such table: pragma_module_list sqlite> select * from pragma_function_list; Error: no such table: pragma_function_list sqlite> select * from pragma_compile_options; COMPILER=gcc-5.2.0 ENABLE_DBSTAT_VTAB ENABLE_FTS3 ENABLE_FTS5 ENABLE_JSON1 ENABLE_RTREE ENABLE_STMTVTAB ENABLE_UNKNOWN_SQL_FUNCTION THREADSAFE=0 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
