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

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for db_drift-1.3.0.tar.gz
Algorithm Hash digest
SHA256 177b37ecae2993568b163c55d4f91909a049b551646a80d495e4e32b0660ea29
MD5 54b3774e0b6e62b827b6a3840a3c4789
BLAKE2b-256 5facb8fb6b4f5bf63e71b7ab289cac597753a2cad37e1378833849375ddd75fb

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for db_drift-1.3.0-py3-none-any.whl
Algorithm Hash digest
SHA256 548bb1b0c9314973921ecc764d8b354d1d8ef01cae396bf2e426d6099f39f831
MD5 4a0f2b1e5fd50c4993acc45424f2edc7
BLAKE2b-256 4ac7a6099419e20344badf46bc732904be1c0ec116c54c2c3810da2fca0132c7

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