goose
alembic
Our great sponsors
goose | alembic | |
---|---|---|
28 | 4 | |
5,554 | 2,456 | |
5.0% | 3.9% | |
8.9 | 8.5 | |
9 days ago | 6 days ago | |
Go | Python | |
GNU General Public License v3.0 or later | 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.
goose
-
Recent improvements to the pressly/goose migration tool
In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:
- How are y'all that are using raw sql doing DB Migrations?
- Why elixir over Golang
- Is there a similar tool or alternative in Go like strong_migrations?
-
How do you handle migrations ?
Next try https://github.com/pressly/goose We have this setup to be run by the CI-CD pipeline to be run before the application is started. BTW, this utility is compatible with https://sqlc.dev , so they work good together.
-
Does this project structure make sense?
For database migration I recommend https://github.com/pressly/goose As it works with sqlc and is a powerful tool for complex migrations. This is something a lot of ORMs are really weak with. I was on a large project with Gorm as the ORM and what a nightmare when we pushed to production!
- Are there any decent ORMs in Golang?
- Don't Mock the Database
-
Writing tests for APIs
goose https://github.com/pressly/goose - data migration and seed data creation
-
A beginner's guide to creating a web-app in Go using Ent
I'm using .sql migration files with tooling similar to https://github.com/pressly/goose . Is there a way to manage my schema with my pre-existing tooling and my queries/CRUD operations with Ent/Atlas?
alembic
-
Understanding a Data Model
SQLAlchemy ORM should support comments if you're using it to create database objects.
-
What migration/versioning tool do you use?
https://github.com/sqlalchemy/alembic for python, especially if you're using SQLAlchemy
-
PostgREST v9.0.0
Agreed, here’s a link to flyway if anyone is curious - https://github.com/flyway/flyway. Many ORMs come with migration systems in your language of choice. For example, SQLAlchemy’s migration tool is Alembic - https://github.com/sqlalchemy/alembic.
- Adding column to DB model results in internal server error, Flask, SQLAlchemy
What are some alternatives?
migrate - Database migrations. CLI and Golang library.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
aerich - A database migrations tool for TortoiseORM, ready to production.
go-migrate - Abstract task migration tool written in Go for Golang services. Database and non database migration management brought to the CLI. [Moved to: https://github.com/g14a/metana]
databases - Async database support for Python. 🗄
liquibase - Main Liquibase Source
SQLAlchemy - The Database Toolkit for Python
pig - Simple pgx wrapper to execute and scan query results
bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
tern - The SQL Fan's Migrator
postgresql-migrations - Simple Schema Migrations for PostgreSQL