{"library":"google-spanner-migrations-runner","type":"library","category":null,"description":"The `google-spanner-migrations-runner` package provides a robust engine for managing schema migrations in Google Cloud Spanner databases, supporting both Google-managed instances and the Spanner emulator. Currently at version 1.13.0, the library receives frequent updates, with minor versions and bug fixes typically released every few months. Unlike ORM-based migration tools, this runner operates directly with `.sql` files, emphasizing a 'migrations-as-code' approach where developers write and test their SQL scripts. It does not generate schema from application code. Key functionalities include applying migrations from a designated directory, validating SQL files, and maintaining a ledger of applied migrations to prevent re-execution. Migrations are applied transactionally and in a specific order, making file naming conventions crucial for successful database evolution. It also features optional annotations for environment-specific migration execution.","language":"javascript","status":"active","version":"1.13.0","tags":["javascript","spanner","sql","google","google-cloud","database","migration","migrations","typescript"],"last_verified":"Wed May 27","install":[{"cmd":"npm install google-spanner-migrations-runner","imports":["import { SpannerMigration } from 'google-spanner-migrations-runner';","import type { MigrationConfig } from 'google-spanner-migrations-runner';","import { SpannerMigration } from 'google-spanner-migrations-runner';\nconst runner = new SpannerMigration(config);\nawait runner.runMigrations();"]},{"cmd":"yarn add google-spanner-migrations-runner","imports":[]},{"cmd":"pnpm add google-spanner-migrations-runner","imports":[]}],"homepage":null,"github":"https://github.com/mdovhopo/google-spanner-migrations-runner","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/google-spanner-migrations-runner","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/google-spanner-migrations-runner/compatibility"}}