squeal-postgresql
Squeal, a deep embedding of SQL in Haskell (by morphismtech)
beam
A type-safe, non-TH Haskell SQL library and ORM (by haskell-beam)
Our great sponsors
| squeal-postgresql | beam | |
|---|---|---|
| 5 | 5 | |
| 351 | 573 | |
| 0.3% | 0.5% | |
| 5.8 | 5.3 | |
| 21 days ago | 3 months ago | |
| Haskell | Haskell | |
| BSD 3-clause "New" or "Revised" License | MIT 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.
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.
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.
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?
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
-
Writing a simple Haskell Persistence layer using Generics and Reflection
Yep, https://github.com/morphismtech/squeal does this too.
-
Practical Haskell, 3rd edition, is out!
If you want an example of a type-safe SQL eDSL in Haskell that doesn't have those problems (and supports more Postgres features than esquelto), I'd recommend https://github.com/morphismtech/squeal.
- New version of Squeal, 0.9 released
beam
Posts with mentions or reviews of beam.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-02.
-
How to use PostgreSQL with Haskell: beam
Beam “is a highly-general library for accessing any kind of database with Haskell”. Beam makes extensive use of GHC's Generics mechanism — no Template Haskell.
-
How can database libraries be compared to each other?
One anecdotal opinion from a rando reddit user: I prefer beam despite the boilerplate and more complex types because of the authors make a serious attempt at sql-standards compliance: https://github.com/haskell-beam/beam
- A more functional approach
-
Haskell sql multi-engine library
It's actively worked on: https://github.com/haskell-beam/beam Makes heavy use of the type level though.
-
Reflections On Using Haskell For My Startup
The beam library is one example of this: https://github.com/haskell-beam/beam/pulls
What are some alternatives?
When comparing squeal-postgresql and beam you can also consider the following projects:
selda - A type-safe, high-level SQL library for Haskell
mywatch
persistent-mysql-haskell - Persistence interface for Haskell allowing multiple storage methods.
yxdb-utils - Utilities for parsing Alteryx Database format
sqlite-simple - Mid-level bindings for sqlite
positron - Experiment
acid-state - Add ACID guarantees to any serializable Haskell data structure
hocilib - A lightweight Haskell binding to the OCILIB C API
opaleye
DSH - Database-Supported Haskell
hasql - The fastest PostgreSQL libpq-based driver for Haskell
influxdb - InfluxDB client library for Haskell