Difftastic seems like a really cool tool. There are a few reasons, however, why ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		s0ck_r4w on July 29, 2022 \| parent \| context \| favorite \| on: Semantic Diff for SQL 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!

rmccue on July 29, 2022 | [–]

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.)

leeoniya on July 29, 2022 | [–]

> It's in JS and not Python

it's in Rust:

https://github.com/Wilfred/difftastic

what am i missing?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact