Add PostgreSQL/JSONB backend (extend SqliteDocumentStore pattern). Optimize query generation for nested JSON paths. ## Acceptance Criteria - [ ] PostgreSQL/JSONB backend implementation - [ ] Follows SqliteDocumentStore pattern - [ ] Optimized query generation for nested JSON paths - [ ] Integration tests with PostgreSQL
Activity
raederan commentedon Nov 16, 2026
Status of the acceptance criteria, and which PR covers what:
SqliteDocumentStorepatternHow to proceed:
ci-test-backends, the branch of feat(backend): add PostgresDocumentStore and test it on PostgreSQL 16-18 in CI #180.mainwithout squashing, so every commit reaches the changelog. feat(backend): add PostgresDocumentStore and test it on PostgreSQL 16-18 in CI #180 then carries both PRs.Refs #35toCloses #35once feat(backend): query nested JSON paths with a GIN index in PostgresDocumentStore #181 is in.Scope notes for the query part (#181):
|) instead of guessing.