Bytebase logo

Bytebase

  •  0 ratings
In category: Miscellaneous

About Bytebase

Safe database schema change and version control for DevOps teams, supports MySQL, PostgreSQL, TiDB, ClickHouse, and Snowflake.

  •   565  
  •   0  
  •   0  
  •   0  
Github stats:
  •  Commits: 7,195  
  •   49,000  
  •   328  
  •  Latest commit: Feb 14, 2023  

Deploy this app to Linode with a free $100 credit!

Languages/Platforms/Technologies:
Lincenses:

More about Bytebase

Bytebase

๐Ÿ”ฅ Live Demo โ€ข โš™๏ธ Install โ€ข ๐Ÿ“š Documentation โ€ข ๐Ÿ™‹โ€โ™€๏ธ Get Instant Help

go report Artifact Hub Github Stars

Different database development tasks

Multiple database systems

Unified process

Single tool



๐Ÿชœ

Change

Want to formalize the database change process but don't know how?

Standard Operating Procedure (SOP)
Standardize the database schema and data change process across different database systems, small or large tables and different tenants.

SQL Review
100+ lint rules to detect SQL anti-patterns and enforce consistent SQL style in the organization.

GitOps
Point-and-click GitHub and GitLab integration to enable GitOps workflow for changing database.


๐Ÿ”ฎ

Query

Want to control the data access but don't know how?

All-in-one SQL Editor
Web-based IDE specifically for performing SQL specific tasks.

Data Anonymization
State-of-the-art column level anonymization engine to cover complex situations like subquery, CTE.

Database Access Control
Organization level policy to centralize the database access control.


๐Ÿ‘ฉโ€๐Ÿ’ผ

Admin

Want to enforce organization policy and monitor database activity but don't know how?

Manage Database Resources
A single place to manage environments, database instances, database users for application development, with optional Terraform integration.

Policy Enforcement
Enforce organization wide SQL Review policy, backup policy and data access policy.

SQL Editor Admin mode
CLI like experience without setting up bastion.


๐Ÿ”’

Secure

Want to avoid data leakage, change outage and detect malicious behavior but don't know how?

Centralize Change, Query and Admin Tasks
A single place to perform different tasks on different databases, thus enforce policy and monitor activity accordingly.

RBAC
Two-level RBAC model mapping to the organization wide privileges and application team privileges respectively.

Anomaly Center and Audit Logging
Capture all database anomalies, user actions and system events and present them in a holistic view.


๐Ÿ–– Intro

Bytebase is a Database CI/CD solution for the Developers and DBAs. It's the only database CI/CD project included by the CNCF Landscape. The Bytebase family consists of these tools:

  • Bytebase Console: A web-based GUI for developers and DBAs to manage the database development lifecycle.
  • Bytebase CLI (bb): The CLI to help developers integrate database changes into the existing CI/CD workflow.
  • Bytebase GitHub App and SQL Review GitHub Action: The GitHub App and GitHub Action to detect SQL anti-patterns and enforce a consistent SQL style guide during Pull Request.
  • Terraform Bytebase Provider: The Terraform provider enables team to manage Bytebase resources via Terraform. A typical setup involves teams using Terraform to provision database instances from Cloud vendors, followed by using Bytebase provider to prepare those instances ready for application use.
Topic
๐Ÿ—๏ธ Installation
๐ŸŽฎ Demo
๐Ÿ‘ฉโ€๐Ÿซ Tutorials
๐Ÿ’Ž Design Principles
๐Ÿงฉ Data Model
๐ŸŽญ Roles
๐Ÿ•Š Developing and Contributing
๐Ÿคบ Bytebase vs Alternatives


๐Ÿ—๏ธ Installation

One liner

# One-liner installation script from latest release
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/bytebase/install/main/install.sh)"


๐ŸŽฎ Demo

Live demo at https://demo.bytebase.com

You can also book a 30min product walkthrough with one of our product experts.


๐Ÿ‘ฉโ€๐Ÿซ Tutorials

Manage database from cloud database vendors


๐Ÿ’Ž Design Principles

๐Ÿชถ Dependency Free Start with a single command ./bytebase without any external dependency. External PostgreSQL data store and others are optional.
๐Ÿ”— Integration First Solely focus on database management and leave the rest to others. We have native VCS integration with GitHub/GitLab, Terraform Provider, webhook, and etc.
๐Ÿ’‚โ€โ™€๏ธ Engineering Disciplined Disciplined bi-weekly release and engineering practice.


๐Ÿงฉ Data Model

More details in Data Model Doc.

Data Model


๐ŸŽญ Roles

More details in Roles and Permissions Doc.

Bytebase employs RBAC (Role-Based-Access-Control) and provides two role sets at the workspace and project level:

  • Workspace roles: Owner, DBA, Developer. The workspace role maps to the role in an engineering organization.
  • Project roles: Owner, Developer. The project level role maps to the role in a specific team or project.

Every user is assigned a workspace role, and if a particular user is involved in a particular project, then she will also be assigned a project role accordingly.

Below diagram describes a typical mapping between an engineering org and the corresponding roles in the Bytebase workspace

Role Mapping


๐Ÿ•Š Developing and Contributing

Tech Stack

  • Bytebase is built with a curated tech stack. It is optimized for developer experience and is very easy to start working on the code:

  • It has no external dependency.

  • It requires zero config.
  • 1 command to start backend and 1 command to start frontend, both with live reload support.

  • Interactive code walkthrough

  • Life of a schema change
  • SQL Review

  • Follow Life of a Feature.

Dev Environemnt Setup

Prerequisites

  • Go (1.19 or later)
  • pnpm
  • Air (our forked repo @87187cc with the proper signal handling). This is for backend live reload. ```bash go install github.com/bytebase/air@87187cc

Steps

  1. Pull source.
git clone https://github.com/bytebase/bytebase
  1. Start backend using air (with live reload).
air -c scripts/.air.toml

Change the open file limit if you encounter "error: too many open files".

ulimit -n 10240

If you need additional runtime parameters such as --backup-bucket, please add them like this:

air -c scripts/.air.toml -- --backup-region us-east-1 --backup-bucket s3:\\/\\/example-bucket --backup-credential ~/.aws/credentials
  1. Start frontend (with live reload).
cd frontend && pnpm i && pnpm dev

Bytebase should now be running at http://localhost:3000 and change either frontend or backend code would trigger live reload.


๐Ÿคบ Bytebase vs Alternatives

Product Comparison

Bytebase vs Flyway, Liquibase

Either Flyway or Liquibase is a library and CLI focusing on schema change. While Bytebase is an one-stop solution covering the entire database development lifecycle for Developers and DBAs to collaborate.

Another key difference is Bytebase doesn't support Oracle and SQL Server. This is a conscious decision we make so that we can focus on supporting other databases without good tooliing support. In particular, many of our users tell us Bytebase is by far the best (and sometimes the only) database tool that can support their PostgreSQL and ClickHouse use cases.

Star History Chart

Bytebase vs Yearning, Archery

Either Yearning or Archery provides a DBA operation portal. While Bytebase provides a collaboration workspace for DBAs and Developers, and brings DevOps practice to the Database Change Management (DCM). Bytebase has the similar Project concept seen in GitLab/GitHub and provides native GitOps integration with GitLab/GitHub.

Another key difference is Yearning, Archery are open source projects maintained by the individuals part-time. While Bytebase is open-sourced, it adopts an open-core model and is a commercialized product, supported by a fully staffed team releasing new version every 2 weeks.

Star History Chart

๐Ÿ‘จโ€๐Ÿ‘ฉโ€๐Ÿ‘งโ€๐Ÿ‘ฆ Community

Hang out on Discord

Follow us on Twitter


๐Ÿค” Frequently Asked Questions (FAQs)

Check out our FAQ.


๐Ÿ™‹ Contact Us

  • Interested in joining us? Check out our jobs page for openings.
  • Want to solve your schema change and database management headache? Book a 30min demo with one of our product experts.

Comments (0)

Please login to join the discussion on this project.

Bytebase Reviews (0)

Overall Rating

None

based on 0 ratings

Please login to review this project.

No reviews for this project yet.

↑ back to top

pCloud Lifetime

Popular Projects

FluxBB

in Social Networks and Forums
 33k    0    0    0  

Nextcloud

in File Transfer & Synchronization
 20k    1    1    0  

Libreddit

in Social Networks and Forums
 7k    0    1    0  

CasaOS

in Self-hosting Solutions
 5k    0    0    0  

Dashboard

in Personal Dashboards
 5k    0    0    0  

Audiobookshelf

in Audio Streaming
 5k    0    1    0  

Mediagoblin

in Photo and Video Galleries
 4k    0    0    0  

Most Discussed

Nextcloud

in File Transfer & Synchronization
 20k    1    1    0  

Tube Archivist

in Automation
 3k    0    1    0  

OneDev

in Project Management
 2k    0    0    0  

iodine

in Proxy
 2k    0    0    0  

Alf.io

in Booking and Scheduling
 2k    0    0    0  

sysPass

in Password Managers
 1k    0    0    0  

Misskey

in Social Networks and Forums
 2k    0    0    0  
Linux VPS from $11/yr.
RackNerd VPS for $11.38/mo

Top Rated Projects

Gitea

 1 rating
in Project Management

Bagisto

 1 rating
in E-commerce

LinkAce

 1 rating
in Bookmarks and Link Sharing

Pydio

 1 rating
in File Transfer & Synchronization

Audiobookshelf

 1 rating
in Audio Streaming

Nextcloud

 1 rating
in File Transfer & Synchronization

Seafile

 1 rating
in File Transfer & Synchronization

Categories

You May Also Be Interested In

Octave Online logo
Octave Online cover

Octave Online

Infrastracture behind a web UI for GNU Octave, the libre alโ€ฆ

Databunker logo
Databunker cover

Databunker

Network-based, self-hosted, GDPR compliant, secure databaseโ€ฆ

ViMbAdmin logo
ViMbAdmin cover

ViMbAdmin

Provides a web based virtual mailbox administration system โ€ฆ