erd vs esqueleto

erd

Translates a plain text description of a relational database schema to a graphical entity-relationship diagram. (by BurntSushi)

#Database

Source Code

esqueleto

Bare bones, type-safe EDSL for SQL queries on persistent backends. (by prowdsponsor)

#Database

Source Code

hackage.haskell.org

Our great sponsors

Scout APM - Less time debugging, more time building

SonarQube - Static code analysis for 29 languages.

SaaSHub - Software Alternatives and Reviews

Our great sponsors

erd		esqueleto
	Project
3	Mentions	2
1,581	Stars	177
-	Growth	0.0%
0.8	Activity	0.0
9 months ago	Latest Commit	over 5 years ago
Haskell	Language	Haskell
LicenseRef-PublicDomain	License	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.

erd

Posts with mentions or reviews of erd. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-10-20.

Ask HN: Open-source DB- ERD tool
1 project | news.ycombinator.com | 23 Nov 2021
What’s everyone’s favourite documentation tools?
3 projects | reddit.com/r/dataengineering | 20 Oct 2021
Recommendations for a CLI-tool to generate DB diagrams?
2 projects | reddit.com/r/PostgreSQL | 28 Dec 2020

Only tool I've come across is erd but have not personally used it. We use LucidChart for our ERDs at work. They have an API to export to PNG and to create documents within it. The documentation for the API is dense, but it is something I am hoping to take a hack day or two to try to understand and see if I can automate generating and updating our own ERDs.

esqueleto

Posts with mentions or reviews of esqueleto. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-02-03.

Notes on Luca Palmieri's Zero to Production in Rust
1 project | reddit.com/r/rust | 26 Jun 2022

Using esqueleto in one of my haskell projects was a huge time sink and a major barrier to entry for colleagues.
Go performance from version 1.2 to 1.18
14 projects | news.ycombinator.com | 3 Feb 2022

In Haskell: https://hackage.haskell.org/package/esqueleto
Either it analyzes the given SQL to determine the in/out types of each SQL query, or it calls the database describe feature at compile-time.

What are some alternatives?

When comparing erd and esqueleto you can also consider the following projects:

opaleye

classy-influxdb-simple

HDBC - Haskell Database Connectivity

hasql - Performant PostgreSQL driver with a flexible mapping API

squeal-postgresql - Squeal, a deep embedding of SQL in Haskell

groundhog - This library maps datatypes to a relational model, in a way similar to what ORM libraries do in OOP. See the tutorial https://www.schoolofhaskell.com/user/lykahb/groundhog for introduction

beam - A type-safe, non-TH Haskell SQL library and ORM

mysql-haskell - Pure haskell mysql driver

yxdb-utils - Utilities for parsing Alteryx Database format

mongoDB - MongoDB driver for Haskell

hocilib - A lightweight Haskell binding to the OCILIB C API

esqueleto vs opaleye

erd vs classy-influxdb-simple

erd vs HDBC

esqueleto vs hasql

esqueleto vs squeal-postgresql

esqueleto vs groundhog

erd vs squeal-postgresql