Ddl-diff Alternatives

Similar projects and alternatives to ddl-diff

prql

106 9,427 9.9 Rust ddl-diff VS prql

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
liquibase

54 4,394 9.9 Java ddl-diff VS liquibase

Main Liquibase Source
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
trustfall

24 2,268 9.3 Rust ddl-diff VS trustfall

A query engine for any combination of data sources. Query your files and APIs as if they were databases!
cargo-semver-checks

18 901 9.3 Rust ddl-diff VS cargo-semver-checks

Scan your Rust crate for semver violations.
usql

21 8,605 9.0 Go ddl-diff VS usql

Universal command-line interface for SQL databases
ArangoDB

17 13,340 9.9 C++ ddl-diff VS ArangoDB

🥑 ArangoDB is a native multi-model database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript extensions.
zillion

11 154 7.2 Python ddl-diff VS zillion

Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
FunSQL.jl

4 138 8.1 Julia ddl-diff VS FunSQL.jl

Julia library for compositional construction of SQL queries
prql-query

3 115 10.0 Rust ddl-diff VS prql-query

Discontinued Query and transform data with PRQL
normconf2022

2 0 10.0 HTML ddl-diff VS normconf2022

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better ddl-diff alternative or higher similarity.

Suggest an alternative to ddl-diff

ddl-diff reviews and mentions

Posts with mentions or reviews of ddl-diff. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-29.

PRQL a simple, powerful, pipelined SQL replacement
19 projects | news.ycombinator.com | 29 Dec 2022

So, after digging about in the docs, I found the Best Practices[0] page which lays out what you describe. I was disappointed to find it is just using idempotent creation statements for procedures and views and putting them all in files that are re-run on each migration step-along with each new roll forward migration-so that new versions of these logic objects replace any old ones. This is not exactly something that liquidbase provides, should be easily replicatable, and I was hoping it'd do diffs to provide similar experience on tables as well.
After some web searching, I came across a project[1] that's trying to do what I describe but it appears to be dead. I'm surprised that migration tools (that I looked through) don't already support such a basic approach that I suspect I'm missing something obvious. Some fundamental block in how SQL works or maybe it doesn't work that well in practice for, in concept, it sounds easy to script using what they call a shadow db and `pg_diff`.
[0]: https://docs.liquibase.com/concepts/bestpractices.html
[1]: https://github.com/cbowdon/ddl-diff