Search Results for "database diff"

sqldef is a schema migration tool that automatically generates SQL migration statements by comparing database schemas. Instead of writing migrations manually, developers define the desired schema, and sqldef computes the difference. It's compatible with MySQL, PostgreSQL, SQLite, and others, making migrations safer and more maintainable.

...Migrations are run atomically inside a transaction. Supports creating and dropping databases (handy in development/test). Supports saving a schema.sql file to easily diff schema changes in git. Database connection URL is defined using an environment variable (DATABASE_URL by default), or specified on the command line.

DoltgreSQL is an experimental Postgres fork that adds Git-like version control to your database. It allows users to commit, branch, merge, and revert changes to data and schema, bringing collaborative workflows to SQL databases. DoltgreSQL is designed for teams who want full auditability and control over every change made in their data layer.

...You can use sq diff to compare tables, or entire databases. sq has commands for common database operations to copy, truncate, and drop tables.

Greenmask is a powerful open-source utility that is designed for logical database backup dumping, obfuscation, and restoration. It offers extensive functionality for backup, anonymization, and data masking. Greenmask is written in pure Go and includes ported PostgreSQL libraries that allows for platform independence. This tool is stateless and does not require any changes to your database schema. It is designed to be highly customizable and backward-compatible with existing PostgreSQL...