As far as keeping track of domain changes you can store DDL files in version control like you mention or use tools like Flyway (https://flywaydb.org) or Liquidbase (https://liquibase.org) which takes care of database migrations. Source: about 2 years ago

I just use SQL directly (or something like JOOQ). For database migrations I use Liquibase. Source: about 2 years ago

Regarding the migrations, there are tools such as https://liquibase.org/ or FlyAway that handle this. Heck, you can even use an ORM that has a migration baked-in but that defeats the purpose of having the migrations in a separate project. Source: about 2 years ago

I've trialled schemachange and liquibase which are change script based tools. I've ruled out a whole load of other tools that are either change script based tools or don't support Snowflake, including the following:. Source: over 2 years ago

Nowadays I prefer to automate database updates and deployment, using Liquibase and its relational database vendor agnostic syntax for that. Especially on production systems. But on local dev environments, I can still use the occasional SQL in a pinch. Source: over 2 years ago

Datahike [0] provides similar functionality to datomic and is open source. It lacks some features however that Datomic does have [1]. [0]: https://github.com/replikativ/datahike. - Source: Hacker News / 7 months ago

You can also consider other durable Datalog options like datahike or datalevin which can work either as lib (SQLite style) or in a client-server setup; if you want to play with bi-temporality XTDB is a rock solid option with very good support and documentation. Source: 11 months ago

Oh really interesting. I didn't know about that. I was actually going threw the old Mendat code base and was considering using that. I would really like a pure Rust version of Datomic for embed use cases. There is all also Datahike, that is going in that direction too. It is maintained and actively developed. https://github.com/replikativ/datahike. - Source: Hacker News / about 2 years ago

Having an Datomic like store backed by something like this. https://github.com/replikativ/datahike Is an Open Source variant of Datomic. Lambdaforge wants to eventually have this work with CRDTs. Using the Matrix ecosystem for this is quite interesting as it solves many problems for you already. - Source: Hacker News / over 2 years ago