Skeema v1.3.0 released
Skeema v1.3.0 has been released! This new version primarily focuses on significant enhancements to Skeema’s linter, allowing users to customize the safeguards in their schema change workflow.
Automating Schema Changes at SendGrid
SendGrid’s Data Operations team recently rearchitected their MySQL schema change process. Their goal: safely empower the company’s individual engineering teams to manage their own schema changes, without requiring DBA intervention. Skeema is a key component of their new design.
Skeema v1.2.0 released
Skeema v1.2.0 has been released, including two major new features: support for stored procedures and functions, and improved linter functionality.
Coming soon: GitHub API Integration
Skeema’s command-line client is currently a stateless tool, typically run manually as needed. Some companies are starting to use it in an automated fashion, as part of a CI/CD pipeline, but this can be complex to configure. Fortunately, automated CI/CD using Skeema is about to become a lot easier!
Benefits of declarative schema management
Skeema uses a declarative approach to schema management: the repository reflects a desired end-state of table and object definitions, and the tool figures out how to convert any live database into this state. This contrasts with most preexisting schema management systems, which instead are based on a concept of migrations: an incremental series of files, each defining a schema change operation and its corresponding rollback. In this post, we’ll discuss the differences in these approaches.