History / SQL Compatibility Report

docs: mod-first overhaul of all wiki pages + static-metric guard compliance 14 pages rewritten for the Arma 3 mod audience (mission makers first, developers second): Home, Getting-Started, SQL-Dialect, SQL-Compatibility-Report, CBA-Settings, TCP-Connector, Standalone-Server, Security, Production-Readiness, Module-Guide, Patch-Framework, Plugins, Building, Development-Setup. - Every feature claim verified against the real engine/binary + source (window fns, prepared stmts, cursors, triggers/FK/CHECK, WITH RECURSIVE, FULL OUTER/NATURAL/USING joins, EXCEPT/INTERSECT, EXPLAIN, VACUUM/REINDEX, SAVEPOINT, UPSERT, RETURNING, composite PKs) - 30KB response contract documented as fail-loud with cursor hint (never silent truncation); cursor paging worked examples - APL-SA license (mod) — fixes the earlier MIT error - NO static repo-metrics: no test counts, no sweep counts, no MSRV, no edition, no version strings — references live sources instead (CI badges, Cargo.toml rust-version, sweep/test commands) - Function names verified against addons/database/ (5 short a3sql_fnc_ aliases + a3sql_database_fnc_* full names) - Fixed wrong claims found during verification: live_patch matching empty rules, listener bind default, plugin register_function syntax, dirty-flag namespace key, autosave debounce

MBarkerUK committed Aug 3, 2026

docs: SQL Compatibility Report — SQF-persistence corpus, composite PK gap Corpus grew to 4 domains (stats/admin/loadouts/sqf_persistence) — the new file models what mods actually do without SQL: profileNamespace key-value, ACE-Arsenal blobs, stat counters, event feeds, per-player state maps. 71/71 pass. Gap table updated (composite PKs added).

MBarkerUK committed Jul 31, 2026

docs: add SQL Compatibility Report page — test your mod's SQL against the real engine New corpus (tools/sql_corpus/) models realistic mod workloads (stats, admin, loadouts). The report runner executes them through the real extension binary and produces a per-domain pass/fail report. Documents the gap table (self-referential UPDATE, auto rowid, date modifiers, SQLite functions — all fixed) and how mod developers test their own SQL.

MBarkerUK committed Jul 31, 2026