vespertide

# Vespertide Database Schema Definition Declarative database schema management. Define tables in JSON, generate typed migrations and SQL. ## Schema Validation (MANDATORY) Every model file MUST include `$schema`. Before saving: ensure no IDE validation errors, then run `vespertide diff`. ```json { "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json", "name": "table_name", "columns": [] } ``` ## Post-Edit Validation (MANDATORY) After EVERY model edit, run: ```bash vespertide diff # Check for parsing errors and expected changes vespertide sql # Preview generated SQL for correctness ``` Only proceed to `vespertide revision` after both pass cleanly. --- ## Installation ```bash cargo install vespertide-cli ``` ## CLI Commands | Command | Description | |---------|-------------| | `vespertide init` | Initialize `vespertide.json` with defaults | | `vespertide new <name>` | Create model template with `$schema` | | `vespertide new <name> -f yaml` | Create model in specific format (`json`/`yaml`/`yml`) | | `vespertide diff` | Show pending changes between migrations and models | | `vespertide sql` | Preview SQL for next migration (default: postgres) | | `vespertide sql -b mysql` | SQL for specific backend (`postgres`/`mysql`/`sqlite`) | | `vespertide log` | Show SQL per applied migration | | `vespertide log -b mysql` | Migration log for specific backend | | `vespertide status` | Show config and sync overvi...