bytebase.com
renovate
bytebase.com | renovate | |
---|---|---|
84 | 3 | |
27 | 79 | |
- | - | |
9.8 | 10.0 | |
1 day ago | over 1 year ago | |
TypeScript | Rust | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
bytebase.com
-
🛡️4 Top Database Security Tools in 2024 🏆🔥
Bytebase is an open-source database DevOps tool, it's the GitLab/GitHub for managing databases throughout the application development lifecycle. It offers a web-based collaboration workspace for DBAs, Developers and platform engineers. It consolidates disparate DB tools such as DBeaver, Liquibase, Flyway into a single place.
-
Version control for queries
Or bytebase.com which has a GUI.
-
🐳Run ClickHouse with Docker and Connect Using MySQL Client☄️
If you like this tutorial, you might also be interested in our product Bytebase, an open-source, web-based schema change management tool, that helps you manage ClickHouse database, supporting SQL review, version control, backup and restore etc...
-
How do you manage your database migrations?
bytebase could be a fit. It provides a GitLab like experience for teams to coordinate database changes.
-
How do you handle schema migrations? Building my own tool
You may check a more modern tool bytebase.com. GUI-based, GitOps native, plus an embedded SQL query tool ...
-
How do you manage database structure changes? And deploying code?
For database structure, you may try bytebase.com, whose GitOps workflow could work for you even for the free version. It also has a GUI to trace and approve changes, a query editor and etc.
- Oracle schema change and version control
renovate
-
We built our customer data warehouse all on Postgres
Thanks! Yeah definitely agree that building out declarative table management for Postgres would be a major effort. A few open source projects I've seen in that area include:
https://github.com/sqldef/sqldef (Go)
https://github.com/bikeshedder/tusker (Python but being ported to Rust)
https://github.com/tyrchen/renovate (Rust)
https://github.com/blainehansen/postgres_migrator (Rust)
Some of these are based on parsing SQL, and others are based on running the CREATEs in a temporary location and introspecting the result.
The schema export side can be especially tricky for Postgres, since it lacks a built-in equivalent to MySQL's SHOW CREATE TABLE. So most of these declarative pg tools shell out to pg_dump, or require the user to do so. But sqldef actually implements CREATE TABLE dumping in pure Golang if I recall correctly, which is pretty cool.
There's also the question of implementing the table diff logic from scratch, vs shelling out to another tool or using a library. For the latter path, there's a nice blog post from Supabase about how they evaluated the various options: https://supabase.com/blog/supabase-cli#choosing-the-best-dif...
- Renovate: A new way to handle Postgres schema migration, inspired by Terraform
-
Renovate: A new way to handle Postgres schema migration
If it looks interesting to you, here's the repo with more details: https://github.com/tyrchen/renovate.
What are some alternatives?
Flyway - Flyway by Redgate • Database Migrations Made Easy.
renovate - Universal dependency automation tool.
employee-sample-database - Employee Sample Database for MySQL and Postgres
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
atlas - Manage your database schema as code
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
shmig - Database migration tool written in BASH.
liquibase - Main Liquibase Source
migra - Like diff but for PostgreSQL schemas
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
schemachange - A Database Change Management tool for Snowflake