What's Changed
Added
PostgresFileSystem(story 003) — native Postgres backend with pgvector-backed embeddings, native lexical (tsvector+plainto_tsquery) and semantic search, regex pushdown, and explicit schema verification. Respects the model-declared pgvector operator class (vector_cosine_ops,vector_ip_ops,vector_l2_ops) for both distance operator selection (<=>,<#>,<->) and score normalization.- Native Postgres pattern-search contract — partial trigram GIN + B-tree
text_pattern_opsindexes onvfs_objects.pathand.content;verify_native_search_schemafails fast if the required artifacts are missing. - Native Postgres
meeting_subgraph(story 004) — server-side PL/pgSQL Steiner-tree traversal installed viainstall_native_graph_schema()and verified at startup. - Native MSSQL
meeting_subgraph— T-SQL stored procedure with a TVP (GroverSeedList) seed-list input; override routes through a rawaioodbccursor since SQLAlchemybindparamcan't plumb TVPs. - Native MSSQL pushdown for
predecessors,successors,ancestors,descendants,neighborhood— previously delegated to the in-memory rustworkx path. Seed/exclusion sets bind as JSON strings unpacked viaOPENJSONwith an explicitNVARCHAR(450)schema; multi-hop traversals drive a Python BFS loop over single-hop SQL queries to avoid MSSQL's recursive-CTEUNION ALLcycle hazard. /.vfssidecar namespace (story 002) — canonical/.vfs/<path>/__meta__/...layout for edge storage and metadata. Replaces the prior child-of-file metadata namespace;mkconnis removed.
Changed
- Result schema unified — the
Candidate/Detailchain is collapsed into a flatEntryrow with operation metadata hoisted onto the envelope. Backends and the query executor now reason in terms of column projection instead of shape dispatch. - Constitution rewritten around four primitives (Namespace, Entry, Revision, Operation) with RFC 2119 precedence language.
in_degree/out_degreedropped fromVFSObjectBase,Entryprojection, and result defaults — graph degrees are no longer part of the entry payload.path/parent_pathmax length restored to 4096 soSQLModel.metadata.create_alltargets SQL Server'sVARCHAR(8000)ceiling; deepest sidecar paths (/.vfs/<path>/__meta__/versions) now have headroom.MSSQLFileSystem._grep_impl— WHERE body extracted so the two FROM / ORDER BY branches no longer duplicate the filter body.context/workspace — research/ migrated intocontext/standards/,context/stories/,context/learnings/; legacy docs and demo DB fixtures pruned.
Fixed
VectorType.process_result_value— rejectstr/bytesbefore the iterable fallback so the expectedValueError("expected iterable pgvector value")is raised instead of a downstream per-character float parse error.- CI coverage restored above the 99% gate with focused tests for Postgres inverse-edge projections, path/vector helper error handling, model/result rendering, and routing/parser/base/permission edge cases.
- CI lint / format / type-check regressions from the native search backend work — touched files now pass
ruff check,ruff format --check, andty check src/.
Full Changelog: v0.0.21...v0.0.22