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.3.tar.gz (204.6 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.3-py3-none-any.whl (25.2 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for db_drift-1.3.3.tar.gz
Algorithm Hash digest
SHA256 b8a02b649f23c2aebd9d5143d54eae66c7eb9abd88a2d14a05c188272892515b
MD5 511b39d2099e57234d59720aac5949de
BLAKE2b-256 fc1c17912aa3db72cd1c49e1a9e828685cd60ac2628d6b57383c65ec05296403

See more details on using hashes here.

File details

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

File metadata

  • Download URL: db_drift-1.3.3-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.11

File hashes

Hashes for db_drift-1.3.3-py3-none-any.whl
Algorithm Hash digest
SHA256 eef49135da2843cf057d417df8b5092c75f8cd8f2ef79d8d8525f6885905af4b
MD5 b66b9941b527f45f3738d8cffed37910
BLAKE2b-256 1e4a8344b84d724be40c5d9767f1f213c89b80e771f21e220f4f8635d993d621

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