pogo-core 0.1.0

Database migration tool for asyncpg

Pogo migrate core - asyncpg migration tooling

pogo-core is a migration tool intended for use with asyncpg and assists with maintaining your database schema (and data if required) as it evolves. Pogo supports migrations written in raw sql, as well as python files (useful when data needs to be migrated).

A migration can be as simple as:

-- a descriptive message
-- depends: 20210101_01_abcdef-previous-migration

-- migrate: apply
CREATE TABLE foo (id INT, bar VARCHAR(20), PRIMARY KEY (id));

-- migrate: rollback
DROP TABLE foo;

Pogo manages these migration scripts and provides utility functions to apply and rollback migrations.

For a user interface, install pogo-migrate instead.

See the docs for more details.

Thanks and Credit

Inspiration for this tool is drawn from yoyo and dbmate.