datools
Introduction
datools
is a collection of Python-based tools for working with data in relational databases. While it contains several utilities for smoothing the rough edges of SQL, its most baked component is datools.diff
, an algorithm that's best explained in a blog post and Jupyter Notebook.
To learn more, read the docs or reach out.
Database support
While datools
generates SQL for its operations, different databases
have their nuances. datools
may run on your database today, but in
an attempt to give you some certainty as to databases we know it has
successfully run on, we run all tests in the test suite against the
following databases:
Database | Evaluated by test suite |
---|---|
SQLite | Since v0.1.2 |
DuckDB | Since v0.1.4 |
PostgreSQL | Since v0.1.5 |
Redshift, Snowflake | You provide an instance, I'll make the tests pass |