diffport 0.4.0

Database summary diff reporting tool

Diffport is a database summary diff reporting tool. It helps in maintaining, diffing and reporting summaries from a database based on a set of watchers. It currently works (and is tested) under postgres.

Usage

Diffport works by using a set of watchers to take snapshots of database at different times and then producing a difference report when asked for it. It uses a config file specifying these watchers and their own specific configuration needs. An example follows:

# diffport.yaml
- name: number-of-rows
  config:
    groupby:
      - <groupby-column-one>
      - <groupby-column-two>
    table: <table-name>

- name: tables-in-schema
  config:
    - <schema-one>
    - <schema-two>

The first watcher (number-of-rows) keeps the count of rows in table <table-name, grouped by columns <groupby-column-one> and <groupby-column-two>. The second watcher tables-in-schema keeps the list of tables in each of the schema provided in its config.

For more details and usage instructions, head over to the project’s documentation here.