opaleye vs squeal-postgresql

opaleye

By tomjaguarpaw

#Database #Opaleye

Source Code

squeal-postgresql

Squeal, a deep embedding of SQL in Haskell (by morphismtech)

#Database #Postgresql #SQL #Haskell

Source Code

Our great sponsors

InfluxDB - Access the most powerful time series database as a service

SonarQube - Static code analysis for 29 languages.

ONLYOFFICE ONLYOFFICE Docs — document collaboration in your environment

Our great sponsors

opaleye		squeal-postgresql
	Project
9	Mentions	5
581	Stars	341
-	Growth	2.1%
8.2	Activity	5.0
15 days ago	Latest Commit	30 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.

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 | reddit.com/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 | reddit.com/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).
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).
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/

squeal-postgresql

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

Choosing the right abstraction level for SQLite library.
2 projects | reddit.com/r/haskell | 17 Mar 2023

You may want to have a look at squeal that someone mentioned the other day in the comments of this post.
What's your favorite Database EDSL/library in Haskell?
4 projects | reddit.com/r/haskell | 28 Feb 2023

https://github.com/morphismtech/squeal, because, to my knowledge, it's the only option that both maintains deep type safety without losing the expressive power of SQL. It can even typecheck your database migrations. There's even a tool to generate the types of your schema based on an existing database: https://github.com/mwotton/squealgen