opaleye VS esqueleto

Compare opaleye vs esqueleto and see what are their differences.

esqueleto

Bare bones, type-safe EDSL for SQL queries on persistent backends. (by prowdsponsor)
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
opaleye esqueleto
9 5
597 177
- 0.0%
8.3 0.0
16 days ago over 7 years ago
Haskell Haskell
BSD 3-clause "New" or "Revised" 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.

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's your favorite Database EDSL/library in Haskell?
    4 projects | /r/haskell | 28 Feb 2023
    If you ever have any questions about Opaleye I'm happy to help. Feel free to open an issue to ask about anything any time.
  • Persistent vs. beam for production database
    2 projects | /r/haskell | 9 Feb 2023
    Sounds like Opaleye isn't on your list of choices, but if it is then feel free to ask me any questions, any time by filing an issue (I'm the Opaleye maintainer).
  • How to build a large-scale haskell backend for a photo sharing app (some questions)
    1 project | /r/haskell | 28 May 2022
    Opaleye is Posgres-only, and Postgres does such a good job of optimizing queries that performance issues basically don't arise. I have a long-standing invitation to improve Opaleye's query generation as soon as anyone can produce a repeatable example of a poorly-performing query. In Opaleye's eight years, no one ever has. There's a thread where two reports have come close, but it's still not clear that that's simply due to using a six year old version of Postgres.
  • What are things that the Haskell scene lacks the most?
    4 projects | /r/haskell | 21 Apr 2022
  • Out of memory when building product-profunctors
    2 projects | /r/haskell | 13 Mar 2022
    Nice! Well done. If you have any more questions about product-profunctors or Opaleye then please let me know. It's best to ask by [opening an issue](https://github.com/tomjaguarpaw/haskell-opaleye/issues/new).
  • Embedded Pattern Matching
    1 project | /r/haskell | 5 Sep 2021
  • How to simply do opaleye field type conversion
    1 project | /r/haskell | 21 Jul 2021
  • Against SQL
    8 projects | news.ycombinator.com | 10 Jul 2021
    The only way out that I can see is to design embedded domain specific languages (EDSLs) that inherit the expressiveness, composability and type safety from the host language. That's what Opaleye and Rel8 (Postgres EDSLs for Haskell do. Haskell is particularly good for this. The query language can be just a monad and therefore users can carry all of their knowledge of monadic programming to writing database queries.

    This approach doesn't resolve all of the author's complaints but it does solve many.

    Disclaimer: I'm the author of Opaleye. Rel8 is built on Opaleye. Other relational query EDSLs are available.

    [1] https://github.com/tomjaguarpaw/haskell-opaleye/

  • Combining Deep and Shallow Embedding of Domain-Specific Languages
    1 project | /r/haskell | 31 Jan 2021
    For an example of how this plays out in practice observe Opaleye's MaybeFields (generously contributed by Shane and /u/ocharles at Circuithub). The definition is essentially identical to Optional from the paper. Instead of a specialised typeclass Inhabited we use the ProductProfunctor NullSpec (which happens to conjure up an SQL NULL, but it could be any other witness).

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.
  • How to use PostgreSQL with Haskell: persistent + esqueleto
    1 project | dev.to | 3 Oct 2023
    However, we can use Esqueleto (”a bare bones, type-safe EDSL for SQL queries”) with Persistent's serialization to write type-safe SQL queries. It’s unlikely that you want to use Persistent by itself with SQL, so let’s use and review them together.
  • 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).
  • Notes on Luca Palmieri's Zero to Production in Rust
    1 project | /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 opaleye and esqueleto you can also consider the following projects:

mywatch

yxdb-utils - Utilities for parsing Alteryx Database format

HDBC - Haskell Database Connectivity

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

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

hocilib - A lightweight Haskell binding to the OCILIB C API

HongoDB - A Simple Key Value Store

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

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

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

rel8 - Hey! Hey! Can u rel8?

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

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured