PRAGMAs as functions ?
(1) By HowardKapustein (howardk) on 2021-05-16 23:05:57 [link] [source]
Does SQLite provide read access to (some/most/which) PRAGMAs?
I'm specifically interested in user_version with a secondary interest in other informational functions e.g.
sqlite> select user_version(); Error: no such function: user_version sqlite> select data_version(); Error: no such function: data_version sqlite> select application_id(); Error: no such function: application_id sqlite> select page_size(); Error: no such function: page_size sqlite> select cache_size(); Error: no such function: cache_size
plus statistics via
sqlite3_config options per https://www.sqlite.org/c3ref/c_config_covering_index_scan.html
(which for some inexplicable reason are doc'd on the webpage named c_config_covering_index_scan.html)
Perhaps there's a compile option I've overlooked? Running with...
sqlite> pragma compile_options; 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
(2) By anonymous on 2021-05-17 02:12:45 in reply to 1 [link] [source]
(3) By HowardKapustein (howardk) on 2021-05-18 21:44:00 in reply to 2 [source]
Doh! I saw that and entirely misread the
pragma_foo() text and examples. My bad. Sorry about that, and thanks