# v0.57.0 — Documentation Excellence

> **Full details:** [v0.57.0.md-full.md](v0.57.0.md-full.md)

## What's New

v0.57.0 delivers four new tutorials, resolves all P2/P3 quality gaps from
the Round 2 documentation audit, and applies a full consistency pass
across all 83 documentation files.  After this release the documentation
meets the world-class standard planned for the v1.0 stable release.

### DOC-NEW-24: New — docs/tutorials/FIRST_DASHBOARD.md

End-to-end tutorial: build the backend for a real-time analytics
dashboard over a sample e-commerce dataset.  Covers creating source
tables, defining aggregate stream tables (revenue by region, hourly
order counts, top-products chain), querying for dashboard consumption,
and optional Grafana data-source configuration.

### DOC-NEW-25: New — docs/tutorials/EVENT_SOURCING.md

End-to-end tutorial: use stream tables as read-model projections over
an event-sourced write model.  Models an order-processing domain —
an immutable events table drives current-order-state, customer-lifetime-
value, and inventory-level projections.  Includes a CQRS pattern section
and event-replay / backfill guidance.

### DOC-NEW-26: New — docs/tutorials/BACKFILL_AND_MIGRATION.md

Step-by-step tutorial for migrating a manually-maintained materialized
view to a stream table with zero downtime: pre-migration assessment,
`pgtrickle.validate_query()` compatibility check, parallel running and
output verification, consumer cutover, and rollback procedure.

### DOC-NEW-27: New — docs/tutorials/SECURITY_HARDENING.md

Step-by-step security hardening guide: create dedicated roles with
minimum privilege, secure CDC trigger ownership, protect change buffers
from direct reads, enable audit logging for stream table DDL.  Includes
copy-paste SQL templates for all GRANT statements and a verification
checklist.

### DOC-P2-11: SECURITY_GUIDE.md — Copy-Paste Role Templates

A new "Copy-Paste Templates" section provides `CREATE ROLE` and `GRANT`
statements for `pgtrickle_admin`, `pgtrickle_user`, and
`pgtrickle_readonly`, removing the need to infer SQL from prose
descriptions.

### DOC-P2-12 – DOC-P2-17: Quality Polish

WHATS_NEW.md backfilled for v0.1–v0.7; HYBRID_SEARCH_PATTERNS patterns
2–3 expanded to match the quality of pattern 1; `partition_key` syntax
documented in PER_TENANT_ANN_PATTERNS.md; INSTALL.md link inconsistencies
fixed; PERFORMANCE_COOKBOOK.md §13 gains worked examples;
SECURITY_MODEL.md supply-chain items resolved.

### DOC-CONS-28 – DOC-CONS-31: Full Consistency Pass

A sweep across all 83 documentation files enforcing:

- **Terminology** — `stream table`, `differential refresh`,
  `change buffer`, `refresh frontier` used consistently.
- **Capitalisation** — `pg_trickle` lowercase; `PostgreSQL` not
  `Postgres`; `pgtrickle` schema name.
- **Code style** — SQL keywords uppercase; all function calls use
  `pgtrickle.` prefix; all code blocks carry a language hint.
- **Cross-links** — every internal link verified to resolve correctly.