Bytebase 成为 CNCF Landscape 上第一个聚焦在 Database CI/CD 领域的项目 现在查看

Bytebase
Star
Announcement

Introducing MongoDB Support in Bytebase

Bytebase 1.11.0 brings MongoDB support. This blog post walks you through managing MongoDB with Bytebase.

Candy 2 min read

Stop Using Navicat as Your SQL Client

Industry

5 min read

The SQL Editor for Developers and DBAs

Announcement

4 min read

What is Database Change Management (DCM)?

Explanation

4 min read

Three Ways to Integrate Automatic SQL Review into GitHub

Explanation

10 min read

了解数据库行业洞见和产品更新

Bytebase Blog

Explanation

Bytebase 1.11.0 Deep Dive

We are thrilled to announce the first release launch of 2023, marking a new beginning for our product and our valued customers. The version number was upgraded from 1.10.0 to 1.11.0. - MongoDB - Schema Diagram - Schema Editor.

Tianzhou avatar

Tianzhou

2 min read
How-To

Manage Databases in Bytebase with Terraform

This tutorial will guide you to use Terraform Bytebase Provider to manage your databases via Terraform.

Ningjing avatar

Ningjing

9 min read
Announcement

Introducing MongoDB Support in Bytebase

Bytebase 1.11.0 brings MongoDB support. This blog post walks you through managing MongoDB with Bytebase.

Candy avatar

Candy

2 min read
Industry

Stop Using Navicat as Your SQL Client

Navicat is a great single-user SQL client. It, however, has a serious limitation in multi-user scenarios where team collaboration and centralized control is needed. This is where Bytebase comes in, a tool that enables teams to collaborate on database management in a safe and secure way.

Tianzhou avatar

Tianzhou

5 min read
Announcement

The SQL Editor for Developers and DBAs

Introduce the new SQL Editor in Bytebase Console with six highlights - Admin mode, database-based access control, data anonymization, audit logs, collaborative sheets and easy to use.

Candy avatar

Candy

4 min read
How-To

How to Configure Database Access Control and Data Anonymization for Developer

This tutorial will walk you through how database access control and data anonymization works in Bytebase. You’ll need two Bytebase accounts – one DBA and one Developer.

Ningjing avatar

Ningjing

6 min read
Explanation

Bytebase 1.10.0 Deep Dive

Last week, we released Bytebase 1.10.0. Let's take a deeper look into the new features - Audit Log - Terraform Provider to manage user roles in PostgreSQL - Support for large SQL files.

Tianzhou avatar

Tianzhou

2 min read
How-To

Database Change Management with TiDB and GitHub

This tutorial will bring your TiDB schema change to the next level by introducing the GitOps workflow, where you commit the schema change script to the GitHub repository, which will in turn trigger the schema deployment pipeline in Bytebase.

Ningjing avatar

Ningjing

5 min read
How-To

Database Change Management with TiDB

TiDB is an open-source NewSQL database that supports Hybrid Transactional and Analytical Processing workloads. This tutorial will guide you step-by-step to set up database change management for TiDB in Bytebase.

Ningjing avatar

Ningjing

6 min read
How-To

Database Change Management with Snowflake and GitHub

This tutorial will bring your Snowflake schema change to the next level by introducing the GitOps workflow, where you commit the schema change script to the GitHub repository, which will in turn trigger the schema deployment pipeline in Bytebase.

Ningjing avatar

Ningjing

5 min read
How-To

Database Change Management with Snowflake

This tutorial will guide you step-by-step to set up database change management for Snowflake in Bytebase.

Ningjing avatar

Ningjing

6 min read
How-To

VCS Integrated Database CI/CD Workflow Best Practice

If we can develop a complete Database CI/CD workflow, and break the wall between developers and DBAs, will it improve release efficiency?

Changyu avatar

Changyu

9 min read
Explanation

Bytebase 1.9.1 Deep Dive

Last week, we released Bytebase 1.9.1. Let's take a deeper look into the new features - schema editor, mark issues as Need Attention, database access control, and data anonymization.

Tianzhou avatar

Tianzhou

4 min read
Explanation

What is Database Change Management (DCM)?

What is Database Change Management (DCM), the challenges and solution.

Tianzhou avatar

Tianzhou

4 min read
Explanation

Three Ways to Integrate Automatic SQL Review into GitHub

The three ways to integrate Bytebase SQL Review with GitHub. GitHub Action, GitHub App, and GitOps CI

Changyu avatar

Changyu

10 min read
Explanation

Bytebase 1.9.0 Deep Dive

Last week, we released Bytebase 1.9.0. Let's take a deeper look into the new features - Sync Schema for PostgreSQL, SQL Editor Admin Mode, and External Approval via Feishu.

Tianzhou avatar

Tianzhou

4 min read
Explanation

How to Handle Database Schema Change?

The common mistakes when making schema changes and the best practice to avoid those pitfalls.

Tianzhou avatar

Tianzhou

6 min read
Industry

Ask ChatGPT - How to Choose the Right Database for Your Next Project

A conversation with ChatGPT consulting which database to pick for your next software project.

Tianzhou avatar

Tianzhou

12 min read
How-To

How to integrate SQL Review into Your GitLab or GitHub CI/CD

This is a tutorial on how to integrate SQL Review into your GitLab & GitHub CI/CD, so that SQL review is automatically triggered before SQL scripts are merged into your repos.

Mila avatar

Mila

2 min read
Engineering

How schema sync works in Bytebase

Technical details about how Bytebase implements schema synchronization for MySQL.

Zipeng avatar

Zipeng

2 min read
How-To

How to Synchronize Database Schemas

This article briefly describes the general scenarios of database schema synchronization and how to use this feature smoothly in Bytebase with pure UI operations.

Ningjing avatar

Ningjing

4 min read
How-To

How to Manage Database Access Control

Database access control can be a headache for DBAs and engineering teams. In this post, we explore database access control scenarios, and how Bytebase helps you to centralize database access control.

Tianzhou avatar

Tianzhou

6 min read
Explanation

Bytebase 1.8.0 New Features Dive

Last week, we released Bytebase 1.8.0. Let's take a deeper look into the new features - MySQL Sync Schema, Admin Mode for SQL Editor, and External Approval via Feishu.

Tianzhou avatar

Tianzhou

2 min read
Industry

MotherDuck, from SQLite to the Docker for Data

From the SQLite-insipred DuckDB to the real Snowflake challenger and the Docker for data.

Tianzhou avatar

Tianzhou

4 min read
Announcement

Introducing DB Cost, the simple cloud database pricing sheet for AWS RDS and Google Cloud SQL instance

DB Cost is a tool for developers to compare performance and cost differences among cloud database providers.

Xiong avatar

Xiong

5 min read
Explanation

What is a Database Schema?

The database schema describes the logical structure of the database data and is the most critical information of a relational database system.

Tianzhou avatar

Tianzhou

2 min read
Industry

The SQL Review Tool for Developers

Reviewing SQL can be somewhat tedious, yet is essential to keep your database fleet reliable. At Bytebase, we are building a developer-first SQL review tool to empower the DevOps system.

Changyu avatar

Changyu

6 min read
Announcement

CNCF Landscape includes Bytebase as the first-ever database CI/CD solution

Bytebase is now the first solution to be included in the CNCF Landscape that focuses solely on database CI/CD.

Tianzhou avatar

Tianzhou

less than 1 min read
Engineering

Global variable support in Nuxt

We recently introduced a global version variable in our Nuxt docs to ease the documentation update during release. This article describes how we implement this feature.

Xiong avatar

Xiong

5 min read
Announcement

Hacktoberfest 2022 with Bytebase

Bytebase is participating in Hacktoberfest 2022! Join the month long celebration of open source with us.

Mila avatar

Mila

2 min read
Case Study

How a Data Team Uses Bytebase to Manage Schema Change for ClickHouse

We are a data team within a 500-person company. The company has several customer-facing products, and we are a group of data scientists analyzing data to uncover customer, product, and operational insights.

Ningjing avatar

Ningjing

4 min read
How-To

How to Setup Database CI/CD with GitHub, Part 3: Put Them Together

Now that you have finished Part 1 SQL Review GitHub Actions and Part 2 GitOps workflow, this final part will guide you through putting them together to run the whole process.

Ningjing avatar

Ningjing

3 min read
How-To

How to Setup Database CI/CD with GitHub, Part 2: GitHub.com Database GitOps

This second part will guide you through configuring GitHub.com database GitOps with Bytebase. After following these steps, you can trigger database changes by merging sql files into your GitHub repository.

Ningjing avatar

Ningjing

4 min read
How-To

How to Setup Database CI/CD with GitHub, Part 1: Enable SQL Review with GitHub Actions

This first article will guide you to enable SQL Review GitHub actions (developed by Bytebase) when there is a pull request in your repository.

Ningjing avatar

Ningjing

3 min read
How-To

The Database CI/CD Best Practice with GitHub

We already have CI/CD for code delivery, why not the database? Imagine applying and deploying database changes the same way you would application code.

Changyu avatar

Changyu

6 min read
How-To

How to cross compile with CGO using GoReleaser and GitHub Actions

We meet some trouble using goreleaser and cgo at the same time. This blog tells how we found the best practices.

Junyi avatar

Junyi

5 min read
Announcement

gh-ost Based Online Schema Migration for MySQL

Introduce gh-ost based online schema migration and how to perform an online schema migration without downtime in Bytebase.

Candy avatar

Candy

4 min read
Industry

20-Person Start-Up, 30+ SaaS Services, and $1,183 Monthly Bill

A breakdown of the 30+ SaaS services that we use daily at Bytebase, a 20-person 18-month tech startup, and how much they cost us monthly.

Tianzhou avatar

Tianzhou

10 min read
How-To

How to Configure ClickHouse SSL Connection

Configure ClickHouse SSL connection and test it by using self-signed CA.

Zipeng avatar

Zipeng

10 min read
Explanation

Dev, SRE, Operations, DevOps - What’s the Difference?

Explain and address the confusion between Developer (Dev), Site Reliability Engineer (SRE), (Operations) Ops and DevOps.

Tianzhou avatar

Tianzhou

6 min read
How-To

Restoring a MySQL Database to a Point in Time

This article describes how Point-in-Time-Recovery (PITR) works in Bytebase and the steps to restore a database using this feature.

Candy avatar

Candy

3 min read
How-To

How to install MySQL Shell on Your Mac

Learn how to install MySQL Shell on your macOS.

Mila avatar

Mila

2 min read
Announcement

Introducing Schema Review Policy for MySQL

This post introduces a new feature - schema review policy, which help DBAs and application developers compose better schema change statements.

Candy avatar

Candy

3 min read
Industry

The Database as Code Landscape

The idea of codifying database schema changes (aka schema migration) is not new. While we are observing an accelerated trend of embracing Database as Code (DaC) across the industry. In this blog, we will review the state-of-the-art in the Database as Code landscape and share our own insight into the current and future trends in this space.

Tianzhou avatar

Tianzhou

13 min read
Industry

DBA, Database and Developer - The Decameron

This is the first of the DDD series, consisting of 10 stories of DBA & Database & developer.

Lucy avatar

Lucy

11 min read
Announcement

Introducing bb - a Bytebase CLI tool to manage database operations

This article describes how to install and run Bytebase CLI bb

Candy avatar

Candy

2 min read
How-To

Get Database Change Notification via Webhook

For better collaboration, DBAs and developers need to be notified when there is any update of the database changes. With Bytebase, you can configure webhooks at a project-level so that Bytebase can post database change notifications to the webhook endpoint.

Candy avatar

Candy

2 min read
How-To

How to use Bytebase with Better Uptime

We use Better Uptime as a way to monitor our websites. With a feature called heartbeats, it is also an easy-to-use tool to monitor Bytebase automatic backup.

Zhe avatar

Zhe

2 min read
Engineering

Database Migration: SQLite to PostgreSQL

This article describes the story of Bytebase migrating its storage from SQLite to PostgreSQL and the challenges on the way.

Danny avatar

Danny

6 min read
Engineering

How Bytebase uses Render

We recently moved most of our hosted service to render.com and also leverage its unique capability to improve our dev workflow. I was responsible for this task.

Zilong avatar

Zilong

3 min read
Engineering

How to build a highly-available service in the Cloud?

This article describes how sharding can help building a highly-available services in the Cloud based on author's years of experience at Google Cloud.

Danny avatar

Danny

6 min read
Industry

Database Review 2021 and 2022 Prediction

What happend in database industry in 2021. OLAP (Snowflake, Databricks, ClickHouse, Firebolt, ClickHouse), OLTP (PostgreSQL, PlanetScale, SQLite) and open source.

Tianzhou avatar

Tianzhou

15 min read
Explanation

What is Database Schema Drift?

Database schema drift is the case where the actual schema in the live database is different from the source of truth. It's also one of the most frequent root cause of the database related outages.

Tianzhou avatar

Tianzhou

3 min read
How-To

GitLab Upgrade from 13 to 14

GitLab upgrade from 13 to 14

Tianzhou avatar

Tianzhou

5 min read
Announcement

Announcing our $3M Seed Round

We are excited to announce that we've raised a $3M seed round, led by Matrix Partners China with participation from Dongxu Huang, co-Founder/CTO of PingCAP (the company behind TiDB).

Tianzhou avatar

Tianzhou

7 min read
How-To

Run ClickHouse with Docker and Connect Using MySQL Client

Run ClickHouse with Docker, and connect using MySQL client.

Zhe avatar

Zhe

8 min read
Explanation

Database Version Control, State-based or Migration-based?

We dive the rationale behind the industry divergence between state-based and migration-based approach. In the end, we also show how Bytebase can help to get the best of both worlds.

Tianzhou avatar

Tianzhou

6 min read
Explanation

Database as Code - the Good, the Bad and the Ugly

Database-as-Code has many benefits in today's DevOps world. However, there exists several missing bricks preventing its wider adoption. We touch many points around Database-as-Code and also explain why Bytebase could help the transition.

Tianzhou avatar

Tianzhou

6 min read
Explanation

SQL Primary Key - UUID or Auto Increment Integer / Serial?

Pros and Cons between choosing UUID or auto increment integer / serial for SQL database.

Tianzhou avatar

Tianzhou

4 min read
Announcement

Announcing Bytebase. Open source, web-based, zero-config, dependency-free database schema change and version control tool for Developer and DBA

Bytebase is a tool for database schema change and version control, its main audience are Developers and DBAs. We want to make Bytebase the industry benchmark solution for managing database schema change.

Tianzhou avatar

Tianzhou

8 min read