Our great sponsors
Bare bones, type-safe EDSL for SQL queries on persistent backends. (by prowdsponsor)
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).
I wanted something simple for my pet project, and I loved working with sqlite-simple. But I decided to wrap it into ReaderT, so I wouldn't have to pass connection everywhere. Like this: https://github.com/sudo97/bayes-hs/blob/main/src/DBWork.hs
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
Haskell PostgreSQL library with compile-time type inference
If you need Cassandra specifically, cql-io is pretty good. For a general purpose database I'd go with Postgres. There are many good choices in the Haskell ecosystem, but I really like postgres-typed. It lets you write plain SQL, checks you queries against a live database schema at compile time, and makes sure you use the results correctly as well. It's amazing, I never ran into type related errors and it's pretty seamless.
Choosing the right abstraction level for SQLite library.
2 projects | reddit.com/r/haskell | 17 Mar 2023
What's your favorite Database EDSL/library in Haskell?
4 projects | reddit.com/r/haskell | 28 Feb 2023
[ANN] hasql-listen-notify: LISTEN/NOTIFY support for hasql
2 projects | reddit.com/r/haskell | 30 Jan 2023
Writing a simple Haskell Persistence layer using Generics and Reflection
1 project | reddit.com/r/haskell | 21 Jan 2023
Practical Haskell, 3rd edition, is out!
1 project | reddit.com/r/haskell | 30 Sep 2022