ByteBase - Web-based, zero-config, dependency-free database schema change and version control tool for teams

  •        160

Bytebase is a web-based, zero-config, dependency-free database schema change and version control management tool for developers and DBAs. It is for developers to collaborate on database schemas changes. It helps to construct a single pipeline to propagate the schema change across multiple environments. It can also store the schemas in VCS and trigger a new pipeline upon commit push.

Developers first submit their SQL statement for DBA to review. After review is approved, the SQL statement will then be applied to the corresponding database. "Version controlled schema" aka "Database-as-code" is a practice to store the database schema in a version control system (VCS) just like how application code is stored. The database schema consists of a bunch of database migration scripts.

https://bytebase.com
https://github.com/bytebase/bytebase

Tags
Implementation
License
Platform

   




Related Projects

Database Lab Engine - Thin database clones for faster development

  •    Go

The Database Lab Engine is an open-source experimentation platform for PostgreSQL databases. Instantly create full-size clones of your production database and use them to test your database migrations, optimize SQL, or deploy full-size staging apps.

Prisma - Next-generation ORM for Node.js and TypeScript

  •    Typescript

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

goose - Goose database migration tool - fork of https://bitbucket.org/liamstask/goose

  •    Go

Goose is a database migration tool. Manage your database schema by creating incremental SQL changes or Go functions.This will install the goose binary to your $GOPATH/bin directory.

Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

  •    Perl

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

Evolve - Database migration tool for .NET and .NET Core projects. Inspired by Flyway.

  •    CSharp

Database migration tool for .NET and .NET Core. Inspired by Flyway. Evolve is an easy migration tool that uses plain SQL scripts. Its purpose is to automate your database changes, and help keep those changes synchronized through all your environments and development teams. This makes it an ideal tool for continuous integration / delivery.


scenic - Versioned database views for Rails

  •    Ruby

Scenic adds methods to ActiveRecord::Migration to create and manage database views in Rails. Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema format to SQL. Scenic provides a convention for versioning views that keeps your migration history consistent and reversible and avoids having to duplicate SQL strings across migrations. As an added bonus, you define the structure of your view in a SQL file, meaning you get full SQL syntax highlighting in the editor of your choice and can easily test your SQL in the database console during development.

sql-migrate - SQL schema migration tool for Go.

  •    Go

SQL Schema migration tool for Go. Based on gorp and goose.Using modl? Check out modl-migrate.

fluentmigrator - Fluent Migrations framework for .net

  •    CSharp

Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations. Migrations are a structured way to alter your database schema and are an alternative to creating lots of sql scripts that have to be run manually by every developer involved. Migrations solve the problem of evolving a database schema for multiple databases (for example, the developer's local database, the test database and the production database). Database schema changes are described in classes written in C# that can be checked into a version control system.This will also build the whole solution.

SQLBoiler - Generate a Go ORM tailored to your database schema.

  •    Go

SQLBoiler is a tool to generate a Go ORM tailored to your database schema.It is a "database-first" ORM as opposed to "code-first" (like gorm/gorp). That means you must first create your database schema. Please use something like goose, sql-migrate or some other migration tool to manage this part of the database's life-cycle.

schemats - Generate typescript interface definitions from SQL database schema

  •    TypeScript

Using Schemats, you can generate TypeScript interface definitions from (Postgres, MySQL) SQL database schema automatically. For an overview on the motivation and rational behind this project, please take a look at Statically typed PostgreSQL queries in Typescript .

lobos - A library to create and manipulate SQL database schemas with migrations support.

  •    Clojure

Lobos is a SQL database schema manipulation and migration library written in Clojure. It currently support supports H2, MySQL, PostgreSQL, SQLite and SQL Server. If you have any questions, please join the mailing list.

Liquibase - Source control for your Database

  •    Java

Liquibase is a database-independent library for tracking, managing and applying database schema changes. It s main functionality includes Database refactoring, Update database to current version, Versioned approach to maintain schema, Database diff report, Rollback database changes to particular date/time and lot more.

squasher - Squasher - squash your old migrations in a single command

  •    Ruby

Squasher compresses old ActiveRecord migrations. If you work on a big project with lots of migrations, every rake db:migrate might take a few seconds, or creating of a new database might take a few minutes. That's because ActiveRecord loads all those migration files. Squasher removes all the migrations and creates a single migration with the final database state of the specified date (the new migration will look like a schema). @note if you use Rbenv don't forget to run rbenv rehash.

Data Access Objects (DAO) for PHP

  •    PHP

Data Access Objects (DAO) code generator which reads schema directly from your database. PreparedStatement PHP class similar to JDBC. Database-neutral XML DDL Schema engine and SQL generator. Supports MySQL. Support for other databases coming.

PolarDB - Share-nothing, Distributed database based on PostgreSQL

  •    C

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication.

pgdiff - Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match

  •    Go

pgdiff compares the schema between two PostgreSQL 9 databases and generates alter statements to be manually run against the second database to make them match. The provided pgdiff.sh script helps automate the process. pgdiff is transparent in what it does, so it never modifies a database directly. You alone are responsible for verifying the generated SQL before running it against your database. Go ahead and see what SQL gets generated.

UnitOfWork - A plugin for Microsoft

  •    CSharp

A plugin for Microsoft.EntityFrameworkCore to support repository, unit of work patterns, and multiple database with distributed transaction supported. In MySQL, physically, a schema is synonymous with a database. You can substitute the keyword SCHEMA instead of DATABASE in MySQL SQL syntax, for example using CREATE SCHEMA instead of CREATE DATABASE. Some other database products draw a distinction. For example, in the Oracle Database product, a schema represents only a part of a database: the tables and other objects owned by a single user.

QuestDB - Fast relational time-series database

  •    Java

QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports.






We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.