vsql_stat_ch extension for the VillageSQL snap (content interface)
Packages the upstream vsql-stat-ch extension (per-statement telemetry
streamed to ClickHouse over its native protocol or HTTP) as a separate
snap that plugs into the villagesql snap through the content interface:
sudo snap install villagesql-stat-ch
sudo snap connect villagesql:extensions villagesql-stat-ch:extensions
sudo snap set villagesql vsql-allow-preview-extensions=ON
sudo snap restart villagesql
sudo villagesql.mysql -uroot -e "INSTALL EXTENSION vsql_stat_ch;"
sudo villagesql.mysql -uroot
-e "SELECT @@vsql_stat_ch.clickhouse_port;"
Preview extension: it uses VEF APIs that may change between VillageSQL
releases and only loads when the server runs with
vsql_allow_preview_extensions=ON.
Needs a villagesql snap built from the repository on or after 2026-10-21:
the 0.0.7 store revisions published before that do not ship the shared
libraries this bundle links against (see docs/extensions.md) and cannot load
it.