Bytebase 1.3.1
π New Features
- SQL Review is now available on the GitHub Action Marketplace! π±
Reliable Database change for DevOps and DBA teams.
Want to be notified? Follow us on Twitter.
Support SQL review for PostgreSQL with 13 rules: SQL Review
Support using GitHub.com both as the VCS integration to manage database schemas and as the authentication provider to allow users to use their GitHub.com accounts to log in to Bytebase.
Restore a database to the time point before the last migration with one click.
In-place Point-in-time Recovery for the database (preview version).
Added GET /v1/sql/advise OpenAPI.
It allows users to perform SQL reviews via API after configuring the schema review policy. Users can access its API documentation via /swagger/index.html
once they start their Bytebase service.
Schema Review for SQL Editor
bb CLI is the command-line tool of Bytebase, helping developers integrate MySQL and PostgreSQL schema change into the existing CI/CD workflow. By integrating bb with your existing CI/CD system (GitLab CI, GitHub Actions, etc.), you can bring all best practices of CI/CD to the database.
Add custom project webhook.
The webhooks we currently support are pre-defined and basically can only do notifications, custom webhook can be more flexible to interact with some external systems (for example, external systems want to sense the status of an issue and do some different operations based on the issue status).
Add "Format on save" checkbox on the issue detail page.
With the default check, when the users click the "Create issue" button, the SQL statement will be automatically formatted.
Add "Sync schema afterward" checkbox on the instance create and detail page to allow users to disable the database sync if needed.
Currently, we sync the schema upon adding/patching the instance. This provides a better UX since the user will see the schema after adding the instance. However, for instances having large schemas, the request will timeout and prevents them from adding the instance at all. The added checkbox only appears if connection-related info is changed.
Use the --pg option to specify the database endpoint upon launching Bytebase.
SQL Review Guide lists all the rules in schema change review, from the naming convention of Table, Column, and Index to the designated WHERE clause. We provide rule templates for the MySQL Dev and Prod environments. DBAs can configure the rules manually based on our templates, and generate images for internal reference. Β Meanwhile, we are actively working on the following area:
Currently, we only support MySQL. We will add PostgreSQL support later.
βπ‘ Our official documentation switches from gitbook to bytebase.com/docs. All the documents are now in our GitHub repository. This will help improve our coordination efficiency in documentation greatly. Now developers can follow https://bytebase.com/docs/document-write-guide to commit your changes.
With over a year of hard work and 3500+ commits, we finally reach the milestone to announce our 1.0.0 version and our Team Plan. The Team Plan includes:
The price starts at $29 per instance per month. Please visit our pricing page for more details.
You can visit https://hub.bytebase.com/pricing to purchase a subscription license and manage your team plan subscription in Settings page.