#postgresql #migration #sql #ast #alter #schema #diff

bin+lib declare_schema

CLI / Library for Postgres schema migrations

4 releases

0.0.4 Aug 3, 2024
0.0.3 Aug 3, 2024
0.0.2 Aug 3, 2024
0.0.1 Jul 9, 2024

#1659 in Database interfaces

Download history 181/week @ 2024-07-05 124/week @ 2024-07-12 80/week @ 2024-07-19 79/week @ 2024-07-26 354/week @ 2024-08-02 201/week @ 2024-08-09 96/week @ 2024-08-16 100/week @ 2024-08-23 24/week @ 2024-08-30

471 downloads per month

Apache-2.0

60KB
1.5K SLoC

declare-schema

Experiments with Rust declarative schemas

Use sqlparser-rs for SQL -> AST, then diff ASTs to generate ALTER ASTs, then output SQL.

WARNING: Alpha software, you will likely lose data with this library.

Goal

In application

Include database schema management in to Rust applications without the need for migration steps.

As a CLI

Provide a CLI tool that can generate diffs of schemas and the required ALTER statements for review to detect schema drift.

Easy development experience

When embedded in an application or with a CLI tool keep an easy SQL -> DB flow that is clear to developers with an easy to modify schema.

Current State

Limitations

CREATE EXTENSION - Can be created by name only. Cannot be DROPed.

Dependencies

~17–29MB
~470K SLoC