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

Bytebase
Star
Announcement

Introducing Single Sign-On in Bytebase

This article demonstrates the Single Sign-On (SSO) protocols supported by Bytebase. SSO allows users to log in once and access all authorized resources, improving security, user experience, and organizational flexibility.

Candy 2 min read

Announcing Partnership with GitHub to Automate Database Development

Announcement

2 min read

Streamline Database Change Management for TiDB Cloud with Bytebase

Announcement

4 min read

Introducing Terraform Bytebase Provider

Announcement

2 min read

Introducing MongoDB Support in Bytebase

Announcement

2 min read

Learn product updates and database insight.

Bytebase Blog

Announcement

Introducing Single Sign-On in Bytebase

This article demonstrates the Single Sign-On (SSO) protocols supported by Bytebase. SSO allows users to log in once and access all authorized resources, improving security, user experience, and organizational flexibility.

Candy avatar

Candy

2 min read
Explanation

Bytebase 1.12.1 Deep Dive

The second release of the 🐰 year, the version number was upgraded from 1.12.0 to 1.12.1, and although it was a minor upgrade (since no schema changes were involved), it still included 230 code commits

Tianzhou avatar

Tianzhou

2 min read
Announcement

Announcing Partnership with GitHub to Automate Database Development

We are proud to announce the Technology Partnership with GitHub to provide developers with a smooth database development experience.

Mila avatar

Mila

2 min read
Announcement

Streamline Database Change Management for TiDB Cloud with Bytebase

We are proud to announce our partnership with PingCAP, which will help developers and DBAs to more efficiently and safely manage the lifecycle of application database schemas.

Changyu avatar

Changyu

4 min read
Announcement

Introducing Terraform Bytebase Provider

With Terraform Bytebase Provider, teams can codify Bytebase resource configurations, including environments, database instances, and roles via Terraform.

Candy avatar

Candy

2 min read
Explanation

Bytebase 1.12.0 Deep Dive

First release of the Year of Rabbit 🐰 is out, the version number was upgraded from 1.11.0 to 1.12.0. - SQL Review Policy - Price Plan Update.

Tianzhou avatar

Tianzhou

3 min read
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
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
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

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
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 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 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