codd
Codd is a simple-to-use CLI tool that applies plain postgres SQL migrations with strong and automatic cross-environment schema equality checks (by mzabani)
dbmigrations
A library for the creation, management, and installation of schema updates for relational databases. (by jtdaugherty)
| codd | dbmigrations | |
|---|---|---|
| 2 | - | |
| 36 | 74 | |
| - | - | |
| 7.0 | 0.0 | |
| 26 days ago | 4 months ago | |
| Haskell | Haskell | |
| GNU General Public License v3.0 or later | BSD 3-clause "New" or "Revised" License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
codd
Posts with mentions or reviews of codd.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-03.
-
Announcing codd - a tool to apply postgres SQL migrations
Some possible upsides of codd: - No need to manually write verification SQL. Codd will update schema representation files when you codd add some-migration.sql and will compare those to the actual schema when deploying (I'd say in ways which would be very hard to replicate manually, see an example of what codd checks, giving you the option to rollback if they don't match or proceed but log non-matching db objects. - It seems to be much simpler to set codd up. You need 3 env vars to start, a folder to store your migrations and a self-contained statically linked executable. Just codd add migration.sql your way in after that - This might be very wrong as I couldn't find it explicitly documented, but this GH issue suggests it's not so simple to apply all pending migrations in a single transaction with Sqitch? Maybe it requires some bundling or something along those lines and then it's fine, though. In any case, codd will do this automatically when you run codd up (provided postgresql allows it).
dbmigrations
Posts with mentions or reviews of dbmigrations.
We have used some of these posts to build our list of alternatives
and similar projects.
We haven't tracked posts mentioning dbmigrations yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
When comparing codd and dbmigrations you can also consider the following projects:
goose - A database migration tool. Supports SQL migrations and Go functions.
hocilib - A lightweight Haskell binding to the OCILIB C API
sqitch - Sensible database change management
ampersand - Build database applications faster than anyone else, and keep your data pollution free as a bonus.
classy-influxdb-simple
mywatch
yxdb-utils - Utilities for parsing Alteryx Database format
HongoDB - A Simple Key Value Store
HaskRel - Haskell as a DBMS including the relational algebra
wheb-mongo - Haskell WAI Framework
libpq - Haskell bindings for libpq
mbtiles - Haskell MBTiles Library