Skip to content

v0.1.0

Choose a tag to compare

@github-actions github-actions released this 07 Nov 08:10
· 24 commits to master since this release
5e810c5

The first release of the Spanner provider

This provider serves Spanner's PostgreSQL interface, through PGAdapter, as a
separate executable for Ptah. It reads a live database, compares and plans,
renders and applies changes, keeps the migration history and the migration
lock, lints migrations and writes declared rows. Its support level is best
effort, measured against pgadapter-emulator v0.56.2; the managed service and
GoogleSQL are not covered.

Which Ptah it needs. The provider negotiates contract 25.27 or later, and
reads and plans foreign keys and CHECKs on contract 25.28. Three host changes
it relies on are on Ptah master and not in Ptah v0.22.1: constraint planning of
created tables (stokaro/ptah#5559), dev databases named by their session
(stokaro/ptah#5565) and the rollback prediction of foreign keys
(stokaro/ptah#5585). With v0.22.1, migrations generate of a schema with
foreign keys fails, and a Ptah that still builds in its own Spanner engine
sends some commands to that engine; use the next Ptah release.

Install it with ptah providers install spanner. The pages in docs/ describe
connecting, declarations, migrations and what the provider refuses; they are
published on docs.ptah.run under Extend, Providers, Spanner.

Changelog

  • 51fda36 Add the scaffold of the Spanner provider (#1)
  • 4111017 Carry views and sequences on the common-object wire (#10)
  • 7c92548 Clean dev databases and guard replays on Spanner (#6)
  • 5e810c5 Document the provider for docs.ptah.run (#15)
  • c41323b Initial commit
  • ab1241b Keep migration history, log and tags through the provider (#9)
  • bc5d67b Own the lifecycle of Spanner tables (#4)
  • 6881a2b Pin provider-sdk to the v0.1.0 tag (#2)
  • 3b69f10 Read tables without a primary key and create a table's schema (#12)
  • cdcad2c Read, compare and plan foreign keys and CHECKs on contract 25.28 (#13)
  • 4ea1aaf Read, plan and write a table's row deletion policy (#7)
  • 90e2782 Run the foreign-key migration up again after its down (#14)
  • 5102397 Run the statements an operator writes through the provider (#11)
  • 1c82d1c Serve migration lint for Spanner (#5)
  • 55a56ab Serve tables through Spanner's PostgreSQL interface (#3)
  • 0bbac61 Type, read and write declared rows and run seed files (#8)