Top 4 Rust Migration Projects

reshape

16 1,617 7.4 Rust

An easy-to-use, zero-downtime schema migration tool for Postgres

Project mention: Show HN: Reshape – Zero-downtime schema migrations for Postgres | news.ycombinator.com | 2023-11-16
postgres_migrator

7 76 5.1 Rust

A postgres migration generator and runner that uses raw declarative sql.

Project mention: We built our customer data warehouse all on Postgres | news.ycombinator.com | 2024-02-02

Thanks! Yeah definitely agree that building out declarative table management for Postgres would be a major effort. A few open source projects I've seen in that area include:
https://github.com/sqldef/sqldef (Go)
https://github.com/bikeshedder/tusker (Python but being ported to Rust)
https://github.com/tyrchen/renovate (Rust)
https://github.com/blainehansen/postgres_migrator (Rust)
Some of these are based on parsing SQL, and others are based on running the CREATEs in a temporary location and introspecting the result.
The schema export side can be especially tricky for Postgres, since it lacks a built-in equivalent to MySQL's SHOW CREATE TABLE. So most of these declarative pg tools shell out to pg_dump, or require the user to do so. But sqldef actually implements CREATE TABLE dumping in pure Golang if I recall correctly, which is pretty cool.
There's also the question of implementing the table diff logic from scratch, vs shelling out to another tool or using a library. For the latter path, there's a nice blog post from Supabase about how they evaluated the various options: https://supabase.com/blog/supabase-cli#choosing-the-best-dif...
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.
models

2 50 0.0 Rust

A tool for automated migrations for PostgreSQL, SQLite and MySQL. (by tvallotton)
rust-starter-pack

1 12 7.0 Rust

Rust Starter Pack - With Tokio Axum, Sqlx, Docker, DB Migrations, Codegen, and more! Project is inspired by Ardan Labs Ultimate Service.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-02-02.