v0.2.3

compare changes

🚀 Enhancements

• external: Start without a connection in development when it fails (#36)

🩹 Fixes

• package: Cap the implemented interface-database-catalog range (#28)

💅 Refactors

• test: Upgrade the guardrail pack and bring the test rules to zero (#30)
• Drop the redundant formatter ignore and the knip config comments (#31)
• types: Remove type assertions and widened types, rename the shape vocabulary (#33)
• Split the oversize modules and specs, bring function size to zero (#34)
• Clear the residual ratchet findings (#37)

📖 Documentation

• changelog: Upgrade notes of postgres 0.2.2 (#25)

📦 Build

• deps: Adopt @antelopejs/interface-database 0.2.0 (#35)

🏡 Chore

• Adopt the guardrail pack from tooling-configs 0.2.0 (#26)
• Configure Renovate with the shared preset (#27)

🤖 CI

• Test on every Node major the engines range allows (#29)

❤️ Contributors

• Thomas (@Thomasims)
• Antony Rizzitelli (@Upd4ting)

v0.2.2

Upgrade notes

• Implements @antelopejs/interface-database >=0.1.11 <0.2.0 (unique indexes and DuplicateKeyError) (#24).
• unique: true creates the instance-led btree index UNIQUE (unique per instance); the crossInstance __g companion never is. unique together with multi (GIN) is refused at registration.
• Flipping unique rebuilds the index through the __next swap. Non-unique index signatures are unchanged, so existing indexes are not rebuilt.
• Behavior change: SQLSTATE 23505 on managed-table writes now throws DuplicateKeyError with the declared index name and fields, or ("_id", ["_id"]) for the primary key. Other violations are rethrown unchanged; external mode keeps ExternalWriteError.
• Writes to a schema declaring a unique index wait for that index to be built. Adding unique over rows that already share a key fails the rebuild (logged) and the old index keeps serving.

compare changes

🚀 Enhancements

• database: Unique indexes and DuplicateKeyError (#24)

❤️ Contributors

• Antony Rizzitelli rizzitelli.antony@pm.me

v0.2.1

compare changes

🚀 Enhancements

• external: Describe and profile the database through interface-database-catalog (#19)
• external: Sample a few rows of a relation through the catalog (#23)

🤖 CI

• Add a checks job aggregating the node matrix (#22)

❤️ Contributors

• Thomas
• Antony Rizzitelli rizzitelli.antony@pm.me

v0.2.0

compare changes

🚀 Enhancements

• ⚠️ Publish as @antelopejs/postgres on public npm (#21)

📖 Documentation

• Streamline agent guidance and preserve repository contracts (#20)

⚠️ Breaking Changes

• ⚠️ Publish as @antelopejs/postgres on public npm (#21)

❤️ Contributors

• Antony Rizzitelli rizzitelli.antony@pm.me

v0.1.4

compare changes

🚀 Enhancements

• External mode (#18)

📖 Documentation

• Fix the outdated CLI commands in the README (#16)

❤️ Contributors

• Thomas (@Thomasims)
• Antony Rizzitelli rizzitelli.antony@pm.me

v0.1.3

compare changes

🚀 Enhancements

• indexes: Add crossInstance indexes and build them concurrently (#14)

🩹 Fixes

• deps: Align interface packages with the current interface-core line (#11)

🏡 Chore

• Remove .git-blame-ignore-revs (#9)

🤖 CI

• Use shared private release workflow (#8)
• release: Release next from a dedicated branch and restore requireCommits (#10)
• release: Reference the shared release workflows through v1 (#12)
• Pin the antelope core locally instead of installing it globally (#13)

❤️ Contributors

• Antony Rizzitelli rizzitelli.antony@pm.me

v0.1.1

🚀 Enhancements

• Scaffold PostgreSQL database backend (25d1a84)
• query: Add type and value model (439ce1e)
• schema: Converge DDL and add instance lifecycle (d4e50e5)
• query: Compile every ValueProxy expression stage (45a4f57)
• query: Build the relation and read pipeline (de47bbe)
• query: Select rows by key and close the write path (781e98e)
• query: Join, lookup and a query used as a value (dd71d8c)
• query: Group and its sub-stream aggregates (19eb6f4)
• query: Cursors, and the last scaffold error (0fc7250)
• changes: The change log, its triggers and the reaper (1d44791)
• changes: The feed registry, its watermark and the three endings (e9a198d)
• changes: The stages, compiled against a logged event (702268e)
• Report the conditions the adapter used to pass over in silence (aaded20)
• database: Add atomic single-record mutations (#4)

🩹 Fixes

• query: Harden the type and value model (3dec954)
• query: Read a payload's _id as an assertion, not an error (ed82167)
• query: Read a payload's null _id as no key supplied (252cca5)
• query: Close the design review's semantic and structural findings (da1ccfe)
• query: Settle the eight decisions the design review left open (412b7e5)
• Four defects on paths the conformance suite cannot reach (3f26c1a)
• changes: Six defects the conformance suite cannot reach (e92d0a5)
• Three gaps between the adapter and the document contract (7b928bb)
• lookup: Correlate under a plucked projection, so the other key keeps its index (#3)
• release: Publish postgres to the AntelopeJS private registry (#5)

💅 Refactors

• Cap private TSDoc at two lines and drop unresolvable citations (bac0daa)

📖 Documentation

• The README as the whole caller-facing contract (13dd199)
• Split the README's reference material into docs/ (9df0888)
• Publish the behaviour, refusals and feed detail that lived in source (fef09ff)

🏡 Chore

• Replace Biome with oxlint, oxfmt and Knip (#2)

🤖 CI

• Run on Node 22 and 24, since 20 cannot load the test config (9ac2fc6)
• Standardize npm releases (f588cd0)

❤️ Contributors

• Antony Rizzitelli rizzitelli.antony@pm.me
• Fabrice Cst fabrice@altab.be
• Thomas (@Thomasims)
• Thomasims thomas@antelopejs.com