esqueleto VS opaleye

Compare esqueleto vs opaleye and see what are their differences.

esqueleto

Bare bones, type-safe EDSL for SQL queries on persistent backends. (by prowdsponsor)
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern API for authentication & user identity.
  • LearnThisRepo.com - Learn 300+ open source libraries for free using AI.
esqueleto opaleye
5 9
177 587
0.0% -
0.0 8.7
over 7 years ago 23 days ago
Haskell Haskell
BSD 3-clause "New" or "Revised" License GNU General Public License v3.0 or later
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.

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 2024-01-15.
  • Revisiting Haskell after 10 years
    8 projects | dev.to | 15 Jan 2024
    Writing Haskell programs that rely on third-party packages is still an issue when it’s a not actively maintained package. They get out of date with the base library (Haskell’s standard library), and you might see yourself in a situation where you need to downgrade to an older version. This is not exclusive to Haskell, but it happens more often than I’d like to assume. However, if you only rely on known well-maintained libraries/frameworks such as Aeson, Squeleto, Yesod, and Parsec, to name a few, it’s unlikely you will face troubles at all, you just need to be more mindful of what you add as a dependency. There’s stackage.org now, a repository that works with Stack, providing a set of packages that are proven to work well together and help us to have reproducible builds in a more manageable way—not the solution for all the cases but it’s good to have it as an option.
  • What databases do you find the most productive to connect to Haskell?
    3 projects | /r/haskell | 29 Dec 2022
    Postgresql-simple is a great library, it makes a nice use of overloaded strings to do the job. Some other nice libraries to keep an eye on are opaleye (postgres specific, which is equally nice but could be a bit difficult to get why the types are so big) and a combination of persistent (not DB specific! can work on postgres, sqlite, but also noSQL DBs like mongo, it's still easy to learn but you lose some things, such as joins due to the power of being agnostic) + esqueleto for type safe joins (be sure to look up the experimental package, it's a more comfortable syntax that will soon become the default one).
  • 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.

opaleye

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

What are some alternatives?

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

mywatch

HDBC - Haskell Database Connectivity

database-migrate - database-migrate haskell library to assist with migration for *-simple sql backends.

HongoDB - A Simple Key Value Store

yxdb-utils - Utilities for parsing Alteryx Database format

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

hocilib - A lightweight Haskell binding to the OCILIB C API

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

mysql-simple - A mid-level client library for the MySQL database, intended to be fast and easy to use.

ampersand - Build database applications faster than anyone else, and keep your data pollution free as a bonus.

rel8 - Hey! Hey! Can u rel8?