Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support building SQLite with with SQLITE_ENABLE_DBSTAT_VTAB compile option #426

Closed
jcurtis-cc opened this issue May 29, 2023 · 0 comments · Fixed by #428
Closed

Support building SQLite with with SQLITE_ENABLE_DBSTAT_VTAB compile option #426

jcurtis-cc opened this issue May 29, 2023 · 0 comments · Fixed by #428
Assignees
@SRombauts

Comments

@jcurtis-cc
Copy link

It might be handy to be able to configure SQLiteCpp to compile sqlite with the DBSTAT compile option

The DBSTAT virtual table is a read-only eponymous virtual table that returns information about the amount of disk space used to store the content of an SQLite database. Example use cases for the DBSTAT virtual table include the sqlite3_analyzer.exe utility program and the table size pie-chart in the Fossil-implemented version control system for SQLite.

The DBSTAT virtual table is available on all database connections when SQLite is built using the SQLITE_ENABLE_DBSTAT_VTAB compile-time option.

The DBSTAT virtual table is an eponymous virtual table, meaning that is not necessary to run CREATE VIRTUAL TABLE to create an instance of the dbstat virtual table before using it. The "dbstat" module name can be used as if it were a table name to query the dbstat virtual table directly. For example:
@jcurtis-cc jcurtis-cc changed the title Support building SQLite with with DBSTAT compile option Support building SQLite with with SQLITE_ENABLE_DBSTAT_VTAB compile option May 29, 2023
SRombauts added a commit that referenced this issue May 31, 2023
@SRombauts
Add CMake option SQLITE_ENABLE_DBSTAT_VTAB to enable DBSTAT read-only…
8a3df03 
… eponymous virtual table extension when building internal sqlite3 library.

See more here: https://www.sqlite.org/dbstat.html

Fix #426 Support building SQLite with with SQLITE_ENABLE_DBSTAT_VTAB compile option

Disabled by default
@SRombauts SRombauts mentioned this issue May 31, 2023
Merged
@SRombauts SRombauts self-assigned this May 31, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@SRombauts SRombauts

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add CMake option SQLITE_ENABLE_DBSTAT_VTAB and SQLITE_ENABLE_RTREE SRombauts/SQLiteCpp
2 participants
@SRombauts @jcurtis-cc