19.0.0 (2026-05-26)

• build(docker)!: Upgrade postgis to 17-3.5 and switch test container to debian slim (34055ba)
• refactor(schema)!: Move canonical tables from pcio.* to public.* (8e10d36)

Bug Fixes

• Docker: Enable postgis (7e53fda)
• spec,api,docs: Align OpenAPI schemas, API behavior, and documentation for v13 (4561fac)

Documentation

• openapi: Expand ScottishPostcodes for full SPD coverage (5b04b0a)

Features

• api: Return Senedd Cymru constituency from postcode lookups (7b43570)
• ingest: Remove ingest tooling and support-table models (6d37c16)
• models: Delete the model layer (ab51e11)
• PgDump: Expand exported dataset (ebbf184)
• queries: Introduce api/app/queries/db.ts and migrate utils (5a85bc4)
• queries: Migrate outcodes_controller to api/app/queries/outcodes (5fcdb22)
• queries: Migrate places_controller to api/app/queries/places (52e4abd)
• queries: Migrate postcodes_controller to api/app/queries/postcodes (18a69cb)
• queries: Migrate scottish_postcodes_controller to full SPD shape (e4e077c)
• queries: Migrate terminated_postcodes to api/app/queries (62c1440)
• spec,docs: Add Senedd Cymru constituency fields to Postcode schema (c927d3d)
• test: Replace model-driven seed with dump-based pipeline (364811b)

Performance Improvements

• DB: Add partial indexes (5d0c2b2)
• db: tune Postgres for read-only workload, add pg_prewarm (971f267)
• outcodes: Read from pcio.outcodes matview instead of aggregating on the fly (466a283)
• queries: Batch bulk postcode + reverse-geo endpoints into one SQL each (7743d9e)
• test: Strip pnpm install from test image build (480da6d)

BREAKING CHANGES

• All canonical data now lives under the public schema.
  Existing deployments using the old pcio.* layout must reload from the
  new dump (or migrate the schema) before pulling this version. The
  test seed (test/seed/v13.sql.gz) needs regenerating against a public.*
  source dump.
• Postgres major version upgrade. Existing PG16 data volumes
  are not in-place compatible with the PG17 server — operators must drop the
  volume (or pg_upgrade) before pulling the new images. The published pg_dump
  under latest must be regenerated from PG17 to keep the format aligned.
• models: api/app/models/* removed. Any external consumer
  that imported from postcodes.io's compiled output (we don't think
  there is one) must migrate to api/app/queries/*.
• queries: GET /scotland/postcodes/:postcode now returns the
  full SPD record. Existing fields (postcode,
  scottish_parliamentary_constituency,
  codes.scottish_parliamentary_constituency) preserved at their
  canonical names.
• ingest: removed CLIs postcodesio-onspd, postcodesio-scotpd,
  and postcodesio-oson. Ingestion is no longer this package's
  responsibility - consume a published pg_dump instead.
• openapi: GET /scotland/postcodes/:postcode response shape
  expands from 3 fields to a full SPD record. Existing fields
  (postcode, scottish_parliamentary_constituency, codes.scottish_parliamentary_constituency)
  are preserved under their canonical names.
• test: npm scripts setup_test_db, test:seed and test:clear
  have been removed. test:create no longer compiles TypeScript; it
  shells to bin/load_test_seed and expects test/seed/v13.sql.gz to be
  present (regenerate with bin/generate_test_seed against a fully loaded
  dev DB).
• PgDump: This update restructures the database into just three tables:

• onspd (ONS Postcode Directory)
• spd (Scottish Postcode Directory)
• osopennames (OS Open Names)

Tables are now fully denormalised for performance