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

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for db_drift-1.3.7.tar.gz
Algorithm Hash digest
SHA256 aa41c1a33b200a499e743007ebcbe60755b495f61083493e2a7c4a07f1735889
MD5 d3b74e56c8477f3aa39a2d63c31842f7
BLAKE2b-256 48539fe62bc82e79493accfaca762537da59cd1447ecb4b60abde91cdbcca96c

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for db_drift-1.3.7-py3-none-any.whl
Algorithm Hash digest
SHA256 f28213341f65d30c0662ad15a321c1485338d72502fb056187481bbf8af48119
MD5 fb4f12db95986075e64c99ad91169056
BLAKE2b-256 79a8f2167c79b8c75308dc0e31a61605c3a3fb7098a86c76ffee8cf138d7112c

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