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)
beam
A type-safe, non-TH Haskell SQL library and ORM (by haskell-beam)
codd | beam | |
---|---|---|
2 | 5 | |
36 | 570 | |
- | 0.0% | |
7.0 | 4.0 | |
26 days ago | 26 days ago | |
Haskell | Haskell | |
GNU General Public License v3.0 or later | MIT 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).
beam
Posts with mentions or reviews of beam.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-02.
-
How to use PostgreSQL with Haskell: beam
Beam “is a highly-general library for accessing any kind of database with Haskell”. Beam makes extensive use of GHC's Generics mechanism — no Template Haskell.
-
How can database libraries be compared to each other?
One anecdotal opinion from a rando reddit user: I prefer beam despite the boilerplate and more complex types because of the authors make a serious attempt at sql-standards compliance: https://github.com/haskell-beam/beam
- A more functional approach
-
Haskell sql multi-engine library
It's actively worked on: https://github.com/haskell-beam/beam Makes heavy use of the type level though.
-
Reflections On Using Haskell For My Startup
The beam library is one example of this: https://github.com/haskell-beam/beam/pulls
What are some alternatives?
When comparing codd and beam you can also consider the following projects:
dbmigrations - A library for the creation, management, and installation of schema updates for relational databases.
mywatch
goose - A database migration tool. Supports SQL migrations and Go functions.
squeal-postgresql - Squeal, a deep embedding of SQL in Haskell
sqitch - Sensible database change management
yxdb-utils - Utilities for parsing Alteryx Database format
hocilib - A lightweight Haskell binding to the OCILIB C API
positron - Experiment
DSH - Database-Supported Haskell
esqueleto - Bare bones, type-safe EDSL for SQL queries on persistent backends.
influxdb - InfluxDB client library for Haskell
HDBC - Haskell Database Connectivity