rda.run/komparo
Watch
1
0
Fork
You've already forked komparo
 0
Code Issues Pull requests Projects Releases 6 Packages Wiki Activity Actions
6 releases 6 tags
  • v0.4.1 2a11a16df5

    v0.4.1 Stable

    rdeavila released this 2026-05-11 10:04:49 -03:00 | 0 commits to main since this release

    🚀 Release v0.4.1

    Fixed

    • Migrate URL Support: The migrate command now supports fetching JSON snapshots via HTTP/HTTPS URLs using the -f flag, matching the behavior of the validate command.

    Full Changelog: https://github.com/rda-run/komparo/compare/v0.4.0...v0.4.1

    Downloads
  • v0.4.0 2c74eae386

    Stable

    rdeavila released this 2026-05-09 21:51:04 -03:00 | 2 commits to main since this release

    What's New

    Added

    • Migration Script Generation: New migrate command that generates SQL DDL
      fix scripts (komparo_fix_*.sql) to align a database with an expected schema
      snapshot. This command works with read-only database users and never executes
      DDL directly - the user must review and execute the generated SQL manually.
      • Analyzes differences between snapshot and live database
      • Generates ordered SQL statements respecting dependencies
      • Supports all schema object types: tables, columns, indexes, constraints,
        sequences, views, materialized views, triggers, functions, enums, extensions
      • DDL is organized in sections: DROP, ALTER, RECREATE, CREATE
      • Includes transaction wrapper with COMMIT/ROLLBACK for safe testing

    Installation

    Download the pre-compiled binaries for your operating system from the assets below, or install via Go, or via dnf/yum repo:

    # Linux/MacOS/Windows
curl -fsSL https://install.rda.run/rda-run/komparo@v0.4.0! | bash

# RPM-Based distros
sudo dnf localinstall -y https://rpm.rda.run/repo.rpm
sudo dnf install komparo

    For full documentation, please check the README.

    Downloads
  • v0.3.0 9ee16267ee

    v0.3.0 Stable

    rdeavila released this 2026-03-24 22:40:30 -03:00 | 5 commits to main since this release

    What's New

    Added

    • Environment Variable Support: Added support for loading database connection parameters (e.g., PGSQL_HOST, PGSQL_USER) from a .env file, making the --db flag optional for snapshot and validate commands.

    Security

    • Log Sanitization: The snapshot command now obscures the password in the connection string output (e.g., password=***) to prevent accidental credential leaks in logs.

    Installation

    Download the pre-compiled binaries for your operating system from the assets below, or install via Go, or via dnf/yum repo:

    # Linux/MacOS/Windows
curl -fsSL https://install.rda.run/rda-run/komparo@v0.3.0! | bash

# RPM-Based distros
sudo dnf localinstall -y https://rpm.rda.run/repo.rpm
sudo dnf install komparo

    For full documentation, please check the README.

    Downloads
  • v0.2.0 1f79d54b60

    v0.2.0 Stable

    rdeavila released this 2026-03-24 14:15:26 -03:00 | 8 commits to main since this release

    What's New

    Added

    • Remote JSON Validation: Added support for fetching JSON snapshot files via HTTP and HTTPS URLs in the validate command using the -f flag.

    Installation

    Download the pre-compiled binaries for your operating system from the assets below, or install via Go:

    curl -fsSL https://install.rda.run/rda-run/komparo@v0.2.0! | bash

    For full documentation, please check the README.

    Downloads
  • v0.1.1 622a32963d

    v0.1.1 Stable

    rdeavila released this 2026-03-23 22:21:36 -03:00 | 11 commits to main since this release

    What's New

    Added

    • Colored Terminals: ANSI colored status indicators in the validate divergence table (Missing: Red, Mismatch: Yellow, Extra: Cyan) seamlessly integrated with Go's native tabwriter.

    Installation

    Download the pre-compiled binaries for your operating system from the assets below, or install via Go:

    curl -fsSL https://install.rda.run/rda-run/komparo@v0.1.1! | bash

    For full documentation, please check the README.

    Downloads
  • v0.1.0 0e8e5f183d

    v0.1.0 Stable

    rdeavila released this 2026-03-23 09:49:34 -03:00 | 13 commits to main since this release

    Komparo v0.1.0 - Initial Release 🚀

    We are thrilled to announce the first official release of Komparo (v0.1.0)!
    Komparo is a standalone, fast, and reliable CLI tool written in Go to compare PostgreSQL database schemas and prevent silent schema drifts.

    What's New in v0.1.0

    • Core CLI Foundation: Basic Cobra CLI setup with komparo executable.
    • Snapshot Generation: snapshot command to extract structural schema metadata from a PostgreSQL database into a standardized JSON file.
      • Supports extracting: Tables, Columns, Indices, Constraints, Sequences, Views, Materialized Views, Triggers, Functions, Enums, and Extensions.
    • Validation Engine: validate command to compare a live database against a generated JSON snapshot.
    • Output Formats: Tabular terminal output (default) and structured JSON output (--format json) for CI/CD integration.
    • GitHub Actions: Automated CI pipeline running linting and tests.
    • Cross-Compilation Options: Pre-configured optimized build scripts for Linux, Windows, and macOS available out of the box in the repository Makefile.
    • JSON Schema: Formal specification published for the expected komparo-snapshot-v1.schema.json output format.

    Installation

    Download the pre-compiled binaries for your operating system from the assets below, or install via Go:

    go install github.com/rda-run/komparo@v0.1.0

    Quick Start

    1. Capture the Expected Schema:
    komparo snapshot --db "postgres://user:pass@localhost:5432/ephemeral_db?sslmode=disable" --out expected_schema.json
    1. Validate a Target Database:
    komparo validate --db "postgres://user:pass@prod-db.internal:5432/production_db?sslmode=require" --file expected_schema.json

    For full documentation, please check the README.

    Downloads