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

  •        1018

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.

https://github.com/salsita/node-pg-migrate

Dependencies:

lodash : ~4.17.0
mkdirp : ~0.5.1
yargs : ~11.0.0

Tags
Implementation
License
Platform

   




Related Projects

node-sqlite - SQLite client library for Node

  •    Javascript

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.

migrate - Opinionated SQL-powered productive roll-forward migration tool for PostgreSQL.

  •    TypeScript

Opinionated SQL-powered productive roll-forward migration tool for PostgreSQL. To help us develop this software sustainably under the MIT license, we ask all individuals and businesses that use it to help support its ongoing maintenance and development via sponsorship.

Prisma - Next-generation ORM for Node.js and TypeScript

  •    Typescript

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

JavaDB

  •    Java

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.


Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

  •    Perl

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

node-postgres - PostgreSQL client for node.js

  •    Javascript

Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings. It supports Connection pooling, PostgreSQL data-type coercion, Parameterized queries, Named statements with query plan caching, Async notifications with LISTEN/NOTIFY and lot more.

data-migrate - Migrate and update data alongside your database structure.

  •    Ruby

Run data migrations alongside schema migrations. Data migrations are stored in db/data. They act like schema migrations, except they should be reserved for data migrations. For instance, if you realize you need to titleize all your titles, this is the place to do it.

PostGraphile - High-performance GraphQL API for your PostgreSQL database

  •    Typescript

PostGraphile is an instant, highly-performant GraphQL API for your PostgreSQL database, extensible via a powerful plugin system. It allows you to access the power of PostgreSQL through a well designed, extensible, customisable and incredibly performant GraphQL server. It automatically detects tables, columns, indexes, relationships, views, types, functions, comments, and more - providing a GraphQL server that is highly intelligent about your data, and that automatically updates itself without restarting when you change your database schema.

node-migrate - Abstract migration framework for node

  •    Javascript

NOTE: A large refactor is underway for the next major version of this package. Check out the 1.x pull request tracking this work, or to explicitly opt in, install the next tag (npm install migrate@next).When first running the migrations, all will be executed in sequence.

node-db-migrate - Database migration framework for node

  •    Javascript

Database migration framework for node

sql-migrate - SQL schema migration tool for Go.

  •    Go

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

sqlalchemy-migrate - Database schema migration for SQLAlchemy

  •    Python

Fork from http://code.google.com/p/sqlalchemy-migrate/ to get it working with SQLAlchemy 0.8.Inspired by Ruby on Rails' migrations, Migrate provides a way to deal with database schema changes in SQLAlchemy projects.

SQL Workbench - DBMS-independent SQL query tool

  •    Java

SQL Workbench is a DBMS-independent, cross-platform SQL query tool. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. It could compare the data of two database and generate the necessary SQL statements to migrate one to the other.

Database Lab Engine - Thin database clones for faster development

  •    Go

The Database Lab Engine is an open-source experimentation platform for PostgreSQL databases. Instantly create full-size clones of your production database and use them to test your database migrations, optimize SQL, or deploy full-size staging apps.

Flask-Migrate - SQLAlchemy database migrations for Flask applications using Alembic

  •    Python

Flask-Migrate is an extension that handles SQLAlchemy database migrations for Flask applications using Alembic. The database operations are provided as command line arguments for Flask-Script. Note that the FLASK_APP environment variable must be set according to the Flask documentation for this command to work. This will add a migrations folder to your application. The contents of this folder need to be added to version control along with your other source files.

ToroDB Stampede - Provides better analytics on top of MongoDB and make it easier to migrate from MongoDB to SQL

  •    Java

ToroDB helps to transform your NoSQL data from a MongoDB replica set into a relational database in PostgreSQL. There are other solutions that are able to store the JSON document in a relational table using PostgreSQL JSON support, but it doesn't solve the real problem of 'how to really use that data'. ToroDB Stampede replicates the document structure in different relational tables and stores the document data in different tuples using those tables.

migrate - Issues for Prisma Migrate are now tracked at prisma/prisma

  •    TypeScript

Prisma Migrate is now in Preview. You can find the official documentation here and you can read the announcement here. Issues and feature requests for Prisma Migrate are now tracked at prisma/prisma. You can report issues or submit feature requests by creating new GitHub issues. This repository is archived and kept as read-only for historical purposes.






We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.