InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises. Learn more →
Top 23 Haskell Database Projects
-
Project mention: Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation | reddit.com/r/PostgreSQL | 2023-02-01
-
erd
Translates a plain text description of a relational database schema to a graphical entity-relationship diagram.
Project mention: D2 is now open source – a new, modern language that turns text to diagrams | news.ycombinator.com | 2022-11-22I like it and the comparison site on https://text-to-diagram.com
I just wanted to drop a reference to Burnt Sushi's ERD tool [0]. It only does one diagram type: Entity Relationship Diagram. It's wonderful. Human-first syntax, code comments, and some simple formatting settings like colors and font sizes that help make more complex diagram pleasing and informative.
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
Tangentially, I would recommend exporting your Pinboard collection periodically to somewhere safe. The service has gotten sketchy in the last year or two. I transitioned mine to a self-hosted instance of Espial.
-
Project mention: How to build a large-scale haskell backend for a photo sharing app (some questions) | reddit.com/r/haskell | 2022-05-28
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.
-
Project mention: How can database libraries be compared to each other? | reddit.com/r/haskell | 2022-12-05
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
-
Project mention: [ANN] hasql-listen-notify: LISTEN/NOTIFY support for hasql | reddit.com/r/haskell | 2023-01-30
The API comes free from all kinds of exceptions. All error-reporting is explicit and is presented using the Either type.
-
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
-
There's an example but I agree that it lacks proper documentation, that's one of the things I'll work on.
-
Project mention: Writing a simple Haskell Persistence layer using Generics and Reflection | reddit.com/r/haskell | 2023-01-21
Yep, https://github.com/morphismtech/squeal does this too.
-
-
acid-state is very cool, it's one of the main things that made me fall in love with Haskell back in the day. However, with this issue still open 6 years after its creation, I don't think it's fit for any real production use: https://github.com/acid-state/acid-state/issues/79
-
HDBC-session
This repository includes a joined query generator based on typefull relational algebra, and mapping tools between SQL values list and Haskell record type.
-
-
Project mention: What databases do you find the most productive to connect to Haskell? | reddit.com/r/haskell | 2022-12-29
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).
-
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
Project mention: How can database libraries be compared to each other? | reddit.com/r/haskell | 2022-12-05There is also groundhog, which I used with sqlite in a toy project, but that was years ago. I can see it had a release this year, which is a good sign.
-
It was brought to my attention that one of these community drivers - the Haskell driver - was experiencing an issue whereby queries were no longer returning results from the MongoDB Atlas clusters their applications were connected to.
-
-
-
-
-
-
-
unexpected '&'
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Haskell Database related posts
- Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation
- [ANN] hasql-listen-notify: LISTEN/NOTIFY support for hasql
- Can't link fresh project - problem with underlying postgrest version not supporting 15.
- Show HN: Rest – Instant RESTful API on Any SQL Database
- Writing a simple Haskell Persistence layer using Generics and Reflection
- Looking for more capable alternative to excel sheets
- Architecture Pitfalls: Don’t use your ORM entities for everything — embrace the SQL!
-
A note from our sponsor - InfluxDB
www.influxdata.com | 2 Feb 2023
Index
What are some of the best open-source Database projects in Haskell? This list will help you:
Project | Stars | |
---|---|---|
1 | postgrest | 19,992 |
2 | erd | 1,654 |
3 | Espial | 603 |
4 | opaleye | 575 |
5 | beam | 534 |
6 | hasql | 479 |
7 | selda | 460 |
8 | bloodhound | 417 |
9 | squeal-postgresql | 330 |
10 | hedis | 316 |
11 | acid-state | 280 |
12 | HDBC-session | 223 |
13 | postgresql-simple | 208 |
14 | esqueleto | 176 |
15 | groundhog | 174 |
16 | mongoDB | 163 |
17 | hw-kafka-client | 135 |
18 | HDBC | 124 |
19 | mysql-haskell | 116 |
20 | Neks | 116 |
21 | sqlite-simple | 114 |
22 | hssqlppp | 108 |
23 | hasql-th | 104 |