Skip to main content

A command line tool to visualize the differences between two DB states.

Project description

DB Drift

PyPI version Python License Downloads CI Code style: ruff

A command-line tool to visualize the differences between two DB states.

Table of Contents

Installation

Install the package from PyPI:

# Using pip
pip install db-drift

# Using pipx
pipx install db-drift

# Using poetry
poetry add db-drift

# Using pipenv
pipenv install db-drift

# Using uv
uv add db-drift

Features

  • Compare two database states and visualize the differences.

How to Use

Basic usage:

db-drift --source "source.db" --target "target.db"

The tool will generate an HTML report showing the differences between the two database states.

Examples

# Compare two SQLite databases
db-drift --source "old_version.db" --target "new_version.db"

# Specify custom output file
db-drift --source "db1.db" --target "db2.db" --output "my_report.html"

# Show version information
db-drift --version

Options

Option Description Default Required
-v, --version Show version information and exit - No
--dbms Specify the type of DBMS sqlite No
-o, --output Output filename for the drift report drift_report.html No
--source Connection string for the source database - Yes
--target Connection string for the target database - Yes
--verbose Enable verbose logging output No No

Supported DBMS Types

Currently supported database management systems:

  • sqlite - SQLite databases
  • oracle - Oracle databases

Note: Support for PostgreSQL and MySQL is planned for future releases.

Troubleshooting

Common Issues

Getting Help

  • Check the examples directory for working samples
  • Review the issues page for known problems
  • Create a new issue if you encounter a bug or have a feature request

Contributing

Contributions are welcome! If you have any ideas, suggestions, or bug reports, please open an issue or submit a pull request.

Please read our CONTRIBUTING.md file for more details.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Project details


Download files

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

Source Distribution

db_drift-1.3.1.tar.gz (204.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

db_drift-1.3.1-py3-none-any.whl (25.2 kB view details)

Uploaded Python 3

File details

Details for the file db_drift-1.3.1.tar.gz.

File metadata

  • Download URL: db_drift-1.3.1.tar.gz
  • Upload date:
  • Size: 204.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.13.9

File hashes

Hashes for db_drift-1.3.1.tar.gz
Algorithm Hash digest
SHA256 00ee4ac9324007e342a97bcd3bc60721b732e3ba093fe5fbff4359086218b4f4
MD5 be802b04ef02e0d475616408a910ca0d
BLAKE2b-256 3e2a352e93dfaeaa8f8535980d4dac7512891ac82f89a670c1415d9319da2c5b

See more details on using hashes here.

File details

Details for the file db_drift-1.3.1-py3-none-any.whl.

File metadata

  • Download URL: db_drift-1.3.1-py3-none-any.whl
  • Upload date:
  • Size: 25.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.13.9

File hashes

Hashes for db_drift-1.3.1-py3-none-any.whl
Algorithm Hash digest
SHA256 57981c95cb19b16db8a55e9aa4c07a289f3f0421090c496bb62254d1fc66f9a5
MD5 b2bce8a49ede6cc92f2e733809879882
BLAKE2b-256 44cab9165039409cd4acb29ce358a47ed95ecaae0b7df72e657b73c67582155b

See more details on using hashes here.

Supported by

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