villagesql/villagesql-server

Filed as an extension proposal — buildable on shipped VEF today (scalar functions only). Suitable as a good first extension; use the vsql-extension-builder skill to scaffold and implement. What should the extension do? Wraps Yann Collet's xxHash — an extremely fast non-cryptographic hash family — and exposes 32-, 64-, and 128-bit variants as SQL scalars. Useful for sharding, deduplication, change-detection, and hash-join helpers where the GHz-per-byte throughput of cryptographic hashes is wasted. Proposed repo name: vsql-xxhash (install name vsql_xxhash). SELECT xxh64('[email protected]') % 16 AS shard; SELECT id FROM rows WHERE xxh128_hex(payload) <> stored_digest; What it does Computes XXH32, XXH64, and XXH128 hashes of an input string. 32-bit variant returns a signed INT, 64-bit returns a signed BIGINT, 128-bit returns its hex string (32 lowercase chars). Deterministic and seed-stable across calls and across machines. Not cryptographic. Do not use for passwords, authenticat

Filed as an extension proposal — buildable on shipped VEF today (scalar functions only). Suitable as a good first extension; use the vsql-extension-builder skill to scaffold and implement. What should the extension do? Port of PostgreSQL contrib unaccent to VillageSQL. Strips accents and diacritics from text — turning café into cafe and naïve into naive — so search, indexing, and slug generation can ignore accent variation without lossy casefolding. Proposed repo name: vsql-unaccent (install name vsql_unaccent). SELECT unaccent('Café NAÏVE Zürich'); -- 'Cafe NAIVE Zurich' CREATE INDEX ON people ((unaccent(name))); What it does Folds accented Latin, Greek, and Cyrillic letters to their unaccented ASCII counterparts. Preserves case: É becomes E, é becomes e. Leaves non-letter characters, digits, and ASCII letters untouched. Single-pass, deterministic, and safe to use in indexes and generated columns. Buffer is sized generously so long fields (paragraphs, descriptions) pass

Filed as an extension proposal — buildable on shipped VEF today (scalar functions only). Suitable as a good first extension; use the vsql-extension-builder skill to scaffold and implement. What should the extension do? Port of Supabase's pg_jsonschema to VillageSQL. Validates a JSON document against a JSON Schema and returns either a boolean verdict or a human-readable error message, so schemas can live next to the data and be enforced in CHECK constraints. Proposed repo name: vsql-jsonschema (install name vsql_jsonschema). CREATE TABLE events ( id BIGINT PRIMARY KEY, payload JSON, CHECK (jsonschema_valid('{"type":"object","required":["kind"]}', payload)) ); SELECT jsonschema_errors('{"type":"object","required":["kind"]}', '{}'); -- 'missing required property: kind' What it does Validates a JSON document against a JSON Schema (draft 2020-12 by default) and returns TRUE or FALSE. Returns a single human-readable error message describing the first failing validation rule, or NULL

Filed as an extension proposal — buildable on shipped VEF today (scalar functions + fixed-length custom types). Suitable as a good first extension; use the vsql-extension-builder skill to scaffold and implement. What should the extension do? Port of PostgreSQL contrib isn to VillageSQL. Adds custom types for international standard product identifiers — ISBN, ISSN, EAN13, UPC, and ISMN — with check-digit validation on input and canonical formatting on output. Proposed repo name: vsql-isn (install name vsql_isn). CREATE TABLE books (id ISBN PRIMARY KEY, title TEXT); INSERT INTO books VALUES ('978-0-13-110362-7', 'The C Programming Language'); SELECT isbn_to_ean13(id) FROM books; What it does Defines one fixed-length custom type per identifier family: isbn, issn, ean13, upc, and ismn. Each rejects malformed input and stores in a compact binary form. Validates check digits on INSERT and UPDATE. Bad check digits raise an error rather than silently storing junk. Reformats on output to

Filed as an extension proposal — buildable on shipped VEF today (scalar + aggregate + variable-length custom type). Suitable as a good first extension; use the vsql-extension-builder skill to scaffold and implement. What should the extension do? Port of Citus Data's postgresql-hll to VillageSQL. Adds a hll custom type and the supporting functions to estimate the cardinality of large sets in roughly 12 KB of state, with bounded error and no exact-count scan. Proposed repo name: vsql-hll (install name vsql_hll). SELECT hll_cardinality(hll_agg(user_id)) FROM events; -- ~ distinct users What it does Defines a variable-length hll custom type that stores a dense HyperLogLog sketch (roughly 12 KB at standard precision). Hashes input values of multiple types into the sketch — text, bigint, hex-encoded bytes, and boolean — so the same extension works for string user-IDs, integer keys, and binary tokens. Estimates the cardinality of the underlying set. Unions two sketches, and aggregates