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.

How to Handle Database Schema Change?

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

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.

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.

How schema sync works in Bytebase

Technical details about how Bytebase implements schema synchronization for MySQL.

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.

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.

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.

MotherDuck, from SQLite to the Docker for Data

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

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.

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.

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.

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.

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.

Hacktoberfest 2022 with Bytebase

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

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.

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.

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.

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.

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.

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.

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.

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.

How to Configure ClickHouse SSL Connection

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

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

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

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.

How to install MySQL Shell on Your Mac

Learn how to install MySQL Shell on your macOS.

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.

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.

DBA, Database and Developer - The Decameron

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

Introducing bb - a Bytebase CLI tool to manage database operations

This article describes how to install and run Bytebase CLI bb

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.

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.

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.

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.

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.

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.

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.

GitLab Upgrade from 13 to 14

GitLab upgrade from 13 to 14

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

Run ClickHouse with Docker and Connect Using MySQL Client

Run ClickHouse with Docker, and connect using MySQL client.

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.

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.

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

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

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.