How to Check 2 SQL Tables Are the Same

1. blog

   1 3 33 10.0

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. data-diff

   2 21 2,899 9.4 Python

   Discontinued Compare tables within or across databases

   

   If the issue happen a lot, there is also: https://github.com/datafold/data-diff

   That is a nice tool to do it cross database as well.

   I think it's based on checksum method.

4. datacompy

   3 4 552 7.9 Python

   Pandas, Polars, Spark, and Snowpark DataFrame comparison for humans and more!

   

5. diffable-sql

   4 1 0 4.5 Python

   

   Slightly related: I recently needed to compare several large databases for schema differences. The output from `pg_dump` isn't very diff-friendly, so I built this[1].

   1. https://github.com/orf/diffable-sql

6. handy_sql_queries

   5 2 1 4.5

   

   This is part of why I don't use MINUS for table value comparisons... All you need is just GROUP BY/UNION ALL/HAVING, using the following technique:

      https://github.com/gregw2hn/handy_sql_queries/blob/main/sql_...

7. dbhub.io

   6 9 384 7.2 Go

   Discontinued A "Cloud" for SQLite databases. Collaborative development for your data. 😊

   

   Not sure if Go code is your kind of thing, but if it is my colleague wrote a SQLite "diff" capability for our online hosting operation:

   https://github.com/sqlitebrowser/dbhub.io/blob/5c9e1ab1cfe0f...

   The code there can also output a "merge" object out of the differences too, in order to merge the differences from one database object into another.

8. dbt-audit-helper

   7 2 356 6.1

   Useful macros when performing data audits

   

   In case you haven't tried dbt (www.getdbt.com / "Data Build Tool") - there's a whole package ecosystem that solves for things like this. The one that came to mind is "dbt-audit-helper": https://github.com/dbt-labs/dbt-audit-helper#compare_relatio...

   It's kind of like PyPI/DockerHub for SQL. Lots of cool stuff in there...here's link to the package hub: https://hub.getdbt.com/

9. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

10. merkle-tree-solidity

    8 1 111 0.0 JavaScript

    JS - Solidity sha3 merkle tree bridge. Generate proofs in JS; verify in Solidity.

    

    Why not hashed merkle tree approach? [0]

    [0] : https://github.com/ameensol/merkle-tree-solidity/blob/master...

Suggest a related project