migrations - SQL migrations for Golang and PostgreSQL

  •        22

This package allows you to run migrations on your PostgreSQL database using Golang Postgres client. See example for details.

https://godoc.org/github.com/go-pg/migrations
https://github.com/go-pg/migrations

Tags
Implementation
License
Platform

   




Related Projects

node-pg-migrate - Node.js database migration management for Postgresql


Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.) Started by Theo Ephraim, now maintained by Salsita Software. You can specify your database connection information using config.

pg - PostgreSQL ORM for Golang with focus on PostgreSQL features and performance


PostgreSQL ORM for Golang with focus on PostgreSQL features and performance. It supports Basic types, Multidimensional Arrays, Transactions, Prepared statements, Queries retries on network errors, Automatic connection pooling with circuit breaker support, Bulk/batch inserts and updates, Pagination and URL filters helpers, Migrations, Sharding and lot more.

Sql Migrations


Sql Migrations is a database migration framework for .NET.

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


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.


sql-migrate - SQL schema migration tool for Go.


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

scenic - Versioned database views for Rails


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.

pg-migrator - PostgreSQL Migration Tool


PostgreSQL Migration Tool

migration_data - The solution to keep your Rails ActiveRecord migrations up to date


This gem provides functionality to write any code in migrations safely without regression. Sometimes we have to write some Rails code in the migrations and it's hard to keep them in a working state because models which are used there change too often. There are some techniques which help to avoid these pitfalls. For example, define model classes in the migrations or write raw SQL. But they don't help in 100% of all cases. This gem promises to solve this problem in a simple way.

fluentmigrator - Fluent Migrations framework for .net


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.

node-sqlite - SQLite client library for Node


A wrapper library that adds ES6 promises and SQL-based migrations API to sqlite3 (docs).🔥 Want to strengthen your core JavaScript skills and master ES6? I would personally recommend this awesome ES6 course by Wes Bos.

lol_dba - lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed


lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts. Most of the initial code came from rails_indexes and migration_sql_generator. Then run one of the following commands...

pgweb - Web-based PostgreSQL database browser written in Go


Pgweb is a web-based database browser for PostgreSQL, written in Go. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

ragtime - Database-independent migration library


Ragtime is a Clojure library for migrating structured data in a way that's database independent. It defines a common interface for expressing migrations, much like Ring defines a common interface for expressing web applications. A data store is an implementation of the DataStore protocol, and tells Ragtime how to record which migrations are applied to an arbitrary store of data, such as a database.

gh-ost - GitHub's Online Schema Migrations for MySQL


gh-ost is a triggerless online schema migration solution for MySQL. It is testable and provides pausability, dynamic control/reconfiguration, auditing, and many operational perks.gh-ost produces a light workload on the master throughout the migration, decoupled from the existing workload on the migrated table.

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


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.

usql - universal command-line interface for SQL databases


usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

DBeaver - Universal SQL Manager and SQL Client


DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

Kallax - PostgreSQL typesafe ORM for the Go language


Kallax is a PostgreSQL typesafe ORM for the Go language. It aims to provide a way of programmatically write queries and interact with a PostgreSQL database without having to write a single line of SQL, use strings to refer to columns and use values of any type in queries.