Skip to main content
Yanked

This release has been yanked by its maintainers, and will be ignored by installers, except when explicitly specified.
Consider using release 3.0.1663481299 instead.
Reason given by maintainers: bad version number

migra: Like diff but for Postgres schemas

  • compare schemas

  • autogenerate migration scripts

  • autosync your development database from your application models

  • make your schema changes testable, robust, and (mostly) automatic

migra is a schema diff tool for PostgreSQL, written in Python. Use it in your python scripts, or from the command line like this:

$ migra postgresql:///a postgresql:///b
alter table "public"."products" add column newcolumn text;

alter table "public"."products" add constraint "x" CHECK ((price > (0)::numeric));

migra magically figures out all the statements required to get from A to B.

Most features of PostgreSQL are supported.

Migra supports PostgreSQL >= 9 only. Known issues exist with earlier versions. More recent versions are more comprehensively tested. Development resources are limited, and feature support rather than backwards compatibility is prioritised.

THE DOCS

Documentation is at databaseci.com/docs/migra.

Folks, schemas are good

Schema migrations are without doubt the most cumbersome and annoying part of working with SQL databases. So much so that some people think that schemas themselves are bad!

But schemas are actually good. Enforcing data consistency and structure is a good thing. It’s the migration tooling that is bad, because it’s harder to use than it should be. migra is an attempt to change that, and make migrations easy, safe, and reliable instead of something to dread.

Contributing

Contributing is easy. Jump into the issues, find a feature or fix you'd like to work on, and get involved. Or create a new issue and suggest something completely different. If you're unsure about any aspect of the process, just ask.

Credits

Metadata

Release files for migra 2.0.1611806735

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for migra 2.0.1611806735
File Size Uploaded
migra-2.0.1611806735.tar.gz 9.9 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for migra 2.0.1611806735
File Interpreter ABI Platform
migra-2.0.1611806735-py3-none-any.whl Python 3 none any Details

Total release size: 20.2 kB

Release files / migra-2.0.1611806735.tar.gz

Download URL migra-2.0.1611806735.tar.gz
Size 9.9 kB
Tags Source
SHA-256 checksum
How to use checksums
4cdc88ed2528dd12fae7868e7c17fd74af3091a968ac0f6201d4f05f13871900
BLAKE2b-256 checksum
How to use checksums
2d5aa182e1d65f735d02b3ca26935f223aac3d4ff7e7023b705f550ba0380d64
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.1.4 CPython/3.8.6 Linux/4.15.0-1092-aws

Release files / migra-2.0.1611806735-py3-none-any.whl

Download URL migra-2.0.1611806735-py3-none-any.whl
Size 10.3 kB
Tags Python 3
SHA-256 checksum
How to use checksums
90145e8e5b07113dffd35d278e65bb1d312be89b5de44cd57ba890a904b69020
BLAKE2b-256 checksum
How to use checksums
214e6caae07dea3eeaddecb1925180c4fcad8ff83b9d039a3e2c38cd3ff34740
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.1.4 CPython/3.8.6 Linux/4.15.0-1092-aws

Release history Release notifications | RSS feed

This release

2.0.1611806735 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page