Capabilities

@anvia/memory-drizzle persists ordered memory through application-owned Drizzle tables.

• Loads, appends, clears, and records failed runs.
• Validates persisted messages by default.
• Exposes canonical PostgreSQL table objects and a replaceable schema object.
• Supports read-only inspection.
• Supports atomic summary checkpoints for memory compaction without deleting canonical messages.
• Requires transactional writes for every append; uses advisory locks for scoped writes, which require execute unless lock: 'none'.

The adapter targets PostgreSQL Drizzle schemas; it is not a database-neutral Drizzle adapter. It does not run Drizzle Kit, manage a connection, authenticate tenants, or schedule compaction.

Normal loads and inspection return complete canonical history. The model-facing compaction snapshot returns the latest summary checkpoint plus the unsummarized tail.

See API reference for the exported schema and store types.