tern
bytebase
Our great sponsors
tern | bytebase | |
---|---|---|
13 | 36 | |
785 | 9,905 | |
- | 4.6% | |
5.6 | 10.0 | |
2 days ago | 5 days ago | |
Go | Go | |
MIT License | GNU General Public License v3.0 or later |
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.
tern
-
Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
We have a repo with migrations written in SQL, and we use tern[1] to apply them.
-
database migrations
If you are using postgres and pgx you may want to use tern.
-
Database migration tool
Recently i started using turn its more fun (IMPO) compared to others tool available https://github.com/jackc/tern
-
How do you handle migrations ?
We use https://github.com/jackc/tern library (from the author of the pgx driver). We run migrations in k8s init containers and we do not do rollbacks (only up). Advantages over other popular solutions are:
-
what do you use for migrations? or how do you the sql tables and seeding?
I use tern! It’s the migrator tool written by the same author of pgx the de facto Postgres driver.
I’ve been happy with https://github.com/jackc/tern .
-
orms in go
I use tern for migrations. It’s from the same Author as pgx so everything in that ecosystem plays well.
- Is there a Go alternative to dbdeploy?
-
Does Go have a nice library for database migrations etc without necessarily being a full ORM?
I use https://github.com/jackc/tern + .env files which interpolate with its config for various environments.
-
What migration/versioning tool do you use?
Tern is a great language and framework agnostic solution for SQL migrations https://github.com/jackc/tern
bytebase
-
Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
We have been building https://github.com/bytebase/bytebase for 3+ years. You can think it of as GitHub/GitLab for SQL changes, with integrated GitOps, code review and deployment.
You can further check out this tutorial to get a feel of our GitOps solution
https://www.bytebase.com/docs/tutorials/database-change-mana...
-
Resend – Incident report for February 21st, 2024
We have been working on bytebase (https://github.com/bytebase/bytebase) for 3+ years to address this. With a change review workflow, environment propagations, and try not to disturb the dev flow if possible.
-
PostgreSQL Is Enough
Migrations. All my database logic lives in version control.
Popular tooling like Phoenix, Hasura, etc have good built in migration stories.
https://www.bytebase.com looks really promising.
Hover, I do struggle with one big issue: changing database logic (views, functions, etc) that has other logic dependent on it. This seems like a solvable problem.
-
A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev
bytebase.com — Database CI/CD and DevOps. Free under 20 users and ten database instances
-
Are "Infrastructure as Code" limited to "Infrastructure" only?
Now there are more subdivided practice: * Policy as Code: Sentinel, OPA * Database as Code: bytebase * AppConfiguration as Code: KusionStack, Acorn * ...... (Welcome to add more)
-
🐬Top 5 MySQL GUI Clients to Command MySQL⚡️
Any of the aforementioned provides a UI for users to operate on databases, a SQL Editor, and the ability to export data. On the other hand, if your organization needs are beyond those and demands an extra layer of control over database queries, changes, and admin actions, try out Bytebase.
Bytebase is an open-source Database DevOps and CI/CD tool for teams, designed to centralize the control and secure your organization’s most valuable asset, the database data.
- Version control for database used by C# app
-
Ask HN: How do you test SQL?
We built a GUI based solution called https://github.com/bytebase/bytebase. You may also take a look.
-
Database version control: how do you do it at your company?
You can take a look at https://bytebase.com, open sourced at https://github.com/bytebase/bytebase. It has a modern GUI, can manage both schema and data change, has native VCS integration, and supports backup & restore and Point-in-time-Recovery. It also has a built-in SQL Editor for querying.
What are some alternatives?
migrate - Database migrations. CLI and Golang library.
liquibase - Main Liquibase Source
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
migrations - SQL database migrations for Golang go-pg and PostgreSQL
migra - Like diff but for PostgreSQL schemas
goose - A database migration tool. Supports SQL migrations and Go functions.
jaeger-clickhouse - Jaeger ClickHouse storage plugin implementation
sqldef - Idempotent schema management for MySQL, PostgreSQL, and more
alembic - A database migrations tool for SQLAlchemy.
gorm-seeder - Gorm seeder package
profanity - Ncurses based XMPP client