HDBC vs opaleye

HDBC

Haskell Database Connectivity (by hdbc)

#Database

Source Code

opaleye

By tomjaguarpaw

#Database #Opaleye

Source Code

Our great sponsors

Scout APM - Less time debugging, more time building

SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!

SaaSHub - Software Alternatives and Reviews

Our great sponsors

HDBC		opaleye
	Project
0	Mentions	6
116	Stars	559
1.7%	Growth	-
4.9	Activity	9.4
3 months ago	Latest Commit	24 days ago
Haskell	Language	Haskell
BSD 3-clause "New" or "Revised" License	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.

HDBC

Posts with mentions or reviews of HDBC. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning HDBC yet.
Tracking mentions began in Dec 2020.

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 2022-04-21.

What are things that the Haskell scene lacks the most?
4 projects | reddit.com/r/haskell | 21 Apr 2022
Out of memory when building product-profunctors
2 projects | reddit.com/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 | reddit.com/r/haskell | 5 Sep 2021
How to simply do opaleye field type conversion
1 project | reddit.com/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 | reddit.com/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).