{"repo":"mzabani/codd","free":true,"listed":false,"github":"https://github.com/mzabani/codd","clone":"git clone https://github.com/mzabani/codd.git","description":"Codd is a simple-to-use CLI tool that applies plain postgres SQL migrations atomically with strong and automatic cross-environment schema equality checks.","language":"Haskell","stars":43,"topics":["migration","postgresql","database","sql"],"license":null,"category":"databases-storage","readme_excerpt":"What is Codd? - What is Codd? - Installing Codd - 1. Self-contained executable - 2. Nix - 3. Docker - Get codd up and running in 15 minutes - Guides - Start using codd with an existing database - Add background migrations to update large datasets without downtime - Codd's limits and robustness - Frequently Asked Questions - Why does taking and restoring a database dump affect my expected codd schema? Codd is a CLI tool that applies plain SQL migrations atomically (when PostgreSQL allows it) and includes schema equality checks that practically ensure your development database's schema matches the database schema in every other environment, checking table columns' names, types, order, available functions, roles, table privileges, object ownership, row security policies, database encoding and much more. These schema equality checks happen automatically; you only need to write .sql files and codd add migration-file.sql them. No configuration files, JSON, or YAML; just 3 environment variables and .sql files and you can use codd. It's also meant to be really simple to use: codd reads SQL files from folders you choose and applies migrations in order. Any special features for these migrations are typically special top-level comments in those SQL files, but you won't need them most of the time. Setting your environment up to use codd from scratch takes 15 minutes. In day to day usage, you will typically run codd add new-migration.sql and/or codd up , and very likely no other commands.","default_branch":null,"files":null,"tree":[],"storefront":"/r/mzabani","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mzabani/codd/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}