Skip to main content

Like `diff` but for PostgreSQL schemas

Project description

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 >= 10 only. Known issues exist with earlier versions. Development resources are limited, and feature support rather than backwards compatibility is prioritised.

THE DOCS

Documentation is at djrobstep.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

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

migra-1.0.1587214226.tar.gz (8.5 kB view details)

Uploaded Source

Built Distribution

migra-1.0.1587214226-py2.py3-none-any.whl (9.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file migra-1.0.1587214226.tar.gz.

File metadata

  • Download URL: migra-1.0.1587214226.tar.gz
  • Upload date:
  • Size: 8.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.0.5 CPython/3.8.2 Linux/4.15.0-1052-aws

File hashes

Hashes for migra-1.0.1587214226.tar.gz
Algorithm Hash digest
SHA256 e4c5a9e3be73e2b20a4c28e0c163483986f334b86b89a2547673f7701d58e6b7
MD5 889d233645d5640d306c733ccabd0113
BLAKE2b-256 e1eccf438a10d3117db410d7dd725f01c1d213c2261e6f80bb87bf0958d6aa81

See more details on using hashes here.

File details

Details for the file migra-1.0.1587214226-py2.py3-none-any.whl.

File metadata

  • Download URL: migra-1.0.1587214226-py2.py3-none-any.whl
  • Upload date:
  • Size: 9.0 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.0.5 CPython/3.8.2 Linux/4.15.0-1052-aws

File hashes

Hashes for migra-1.0.1587214226-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 553a9476b761fba753a2914448e66097a3155768b9a7dee4652cd1fe7e5b9f50
MD5 4c97805c39fcccdd6360e4d2ef3ca721
BLAKE2b-256 a6a6024812a0723e64e5fc1255e346e571d3c2baf56ebd3c35c21ca4b917760c

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page