v0.3.0 - New algorithm for in-db diffing (joindiff) + tons of new features and bugfixes! #334

erezsh · 2022-12-06T13:14:06Z

erezsh
Dec 6, 2022

Big points:

Added a new algorithm for in-db diffing that uses OUTER JOIN, called "joindiff".
- Much faster than the original "hashdiff" algorithm!
- Automatically chosen if both dbs are the same
- Validates that the key column is unique and contains no NULLs (joindiff only)
- Explicitly switch between algorithms using the --algorithm parameter.
New feature to materialize joindiff results to DB
New feature that diffs the schemas when both dbs are the same
Added DuckDB support (thanks @jardayn!)
Better support for alphanumerics
Better support for boolean types
Added --version switch
New and improved database and query interface, named "sqeleton"
Tons of bugfixes and improvements!