News for hackers. Stuff that matters.

A comment on Semantic Diff for SQL. Parent comment

Re:Semantic Diff for SQL by s0ck_r4w on Friday July 29, 2022 @12:29PM (#32278983)
Difftastic seems like a really cool tool. There are a few reasons, however, why it doesn't apply well to use cases I had in mind:

1. It's in JS and not Python. These days a common data (including data tooling) stack revolves around Python and fitting JS into this ecosystem is not straightforwad.

2. Limited dialect support. As far as I can see it only supports "PostgreSQL flavor" (not sure what exactly is meant by "flavor" here). Support for dialects like Spark, Trino, Hive, etc SQL was crucial.

Definitely a worthy mention, though, thank you!

[ Parent | on HN ]
Re:Semantic Diff for SQL by rmccue on Friday July 29, 2022 @12:53PM (#32279263)
Difftastic's wiki also has a breakdown of some structured diff algorithms: https://github.com/Wilfred/difftastic/wiki/Structural-Diffs

(I've been working on a similar problem, effectively diffing an XML tree.)

[ Parent | on HN ]
Re:Semantic Diff for SQL by leeoniya on Friday July 29, 2022 @05:53PM (#32282208)
> It's in JS and not Python

it's in Rust:

https://github.com/Wilfred/difftastic

what am i missing?

[ Parent | on HN ]