tern
migrate
Our great sponsors
tern | migrate | |
---|---|---|
12 | 71 | |
770 | 13,720 | |
- | 2.9% | |
5.6 | 7.5 | |
19 days ago | 3 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
-
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
- Most recommended database migration tool? using golang for the record
migrate
- Looking for recommendations for model/schema/migration management in Golang
- API completa em Golang - Parte 1
-
Building RESTful API with Hexagonal Architecture in Go
Golang-migrate is a database migration tool designed for Go applications. It helps manage and apply changes to the database schema as the application grows, ensuring that the code and database structure stay in sync.
-
Python: Just Write SQL
First of all, thank you for SQLAlchemy! If I ever had to make a final choice in how I would interact with a database for a very large project that involves a considerable dev team, I would always bet on SQLAlchemy. Not that I would necessarily like all aspects of it, but when it comes to Python and SQL - “Nobody ever got fired for picking SQLAlchemy.”.
With that out of the way, despite ORMs doing much more than "just writing SQL", it is exactly on that point that I flinch: Most devs should be exposed to SQL. And if your project allows you to build around simple enough abstractions so that you aren't reinventing the wheel, you should definitely be writing SQL. Especially if you don't know SQL yet - which is the growing case of new devs coming into the job market.
You can achieve a lot with SQlAlchemy Core, a tool that I absolutely recommend, but my post is just a simple alternative to get developers to think about their approach. If that results in some devs reconsidering using "full fat" SQLAlchemy and to try SQLAlchemy Core, that's a win for me!
Your gist tries to highlight the difficulty of doing certain things without an ORM. Migrations (as just 1 example) doesn't need to be hard, simple tools like flyway, or migrate (https://github.com/golang-migrate/migrate) achieve a similar result (while also keeping you on the path of writing SQL!). Deep and complex relationships between objects also don't need to be hard - typically people approach this subject with a requirement to be very flexible in the way they want to build queries and objects, but that to me in a sign that maybe they should reconsider their business logic AND reconsider that, just maybe, their project doesn't require all that flexibility, it is fairly straightforward to extend objects and introduce some more complex representations as and when it is needed - will all of this make me write code faster? Absolutely not. That is why you have spent so much time perfecting SQLAlchemy, but then again, I am not advocating for devs to go and replace their usage of ORMs, just presenting an alternative that may or may not fit their needs for a new project + give devs the chance to learn something that the ORM might have taken away.
When it comes to migrations, I've been fine with https://github.com/golang-migrate/migrate
There are a multitude of extra things to consider, but none of those things are, in my opinion, imperative to having success with SQL in Python. Will it be hard to achieve the same level of convenience that modern ORMs provide? Absolutely. But there is always a cost.
I firmly believe that for most projects (especially in the age of "services"), an approach like this is very much good enough. Also, a great way to onboard new developers and present both SQL and simple abstractions that can be applied to many other areas of building software.
- Database migration tool
-
REST API with Go, Chi, MySQL and sqlx
Before we can start using MySQL we need to create a table to store our data. I will be using excellent migrate database migrations tool, it can also be imported as a libraray.
-
How do your teams run DB migrations?
By using an opinionated framework within the app/service (like Flyway, Migrate, Diesel, etc). Schema migrations happen on app/service start-up.
-
From Golang Beginner to Building Basic Web Server in 4 Days!
For building my web server, I chose to use the Gin framework as the foundation of my app. It was incredibly easy to understand and work with, and I was pleasantly surprised by how seamlessly it integrated with writing unit tests for the server. To handle the database, I leveraged the power of go-sqlite and migrate for efficient SQL queries and migrations. These libraries proved to be both powerful and user-friendly, making the development process a breeze.
-
Is there a similar tool or alternative in Go like strong_migrations?
strong_migrations is a famous gem for Ruby projects to catch dangerous migrations in development. Is there an alternative in Go which can be used with https://github.com/golang-migrate/migrate or other migration tools? Or if tools like migrate already have the support, it's just that I'm not aware?
What are some alternatives?
goose
goose - A database migration tool. Supports SQL migrations and Go functions.
pgx - PostgreSQL driver and toolkit for Go
gormigrate - Minimalistic database migration helper for Gorm ORM
sqlx - general purpose extensions to golang's database/sql
clickhouse-go - Golang driver for ClickHouse
go-fixtures - Django style fixtures for Golang's excellent built-in database/sql library.
sqlc - Generate type-safe code from SQL
go-pg-migrations - A Go package to help write migrations with go-pg/pg.
atlas - A modern tool for managing database schemas
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
sql-migrate - SQL schema migration tool for Go.