Haskell Database

Open-source Haskell projects categorized as Database

Top 23 Haskell Database Projects

  • postgrest

    REST API for any Postgres database

    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-22

    I 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.

    [0] https://github.com/BurntSushi/erd

  • 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.

  • Espial

    Espial is an open-source, web-based bookmarking server.

    Project mention: Pinboard addict here. | reddit.com/r/Zettelkasten | 2022-11-29

    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.

  • opaleye

    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.

  • beam

    A type-safe, non-TH Haskell SQL library and ORM (by haskell-beam)

    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

  • hasql

    The fastest PostgreSQL libpq-based driver for Haskell

    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.

  • selda

    A type-safe, high-level SQL library for Haskell

    Project mention: School of Haskell: Basics | news.ycombinator.com | 2022-11-11
  • 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.

  • bloodhound

    Haskell Elasticsearch client and query DSL (by bitemyapp)

    Project mention: [ANN] BloodHound 0.20.0.0 | reddit.com/r/haskell | 2022-05-29

    There's an example but I agree that it lacks proper documentation, that's one of the things I'll work on.

  • squeal-postgresql

    Squeal, a deep embedding of SQL in Haskell

    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.

  • hedis

    A Redis client library for Haskell.

  • acid-state

    Add ACID guarantees to any serializable Haskell data structure

    Project mention: Which nosql | reddit.com/r/haskell | 2022-03-26

    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.

  • postgresql-simple

    Mid-level client library for accessing PostgreSQL from Haskell

  • esqueleto

    Bare bones, type-safe EDSL for SQL queries on persistent backends. (by prowdsponsor)

    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-05

    There 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.

  • mongoDB

    MongoDB driver for Haskell (by mongodb-haskell)

    Project mention: Bug Hunting with the MongoDB Haskell Community | dev.to | 2022-09-21

    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.

  • hw-kafka-client

    Kafka client for Haskell, including auto-rebalancing consumers

  • HDBC

    Haskell Database Connectivity

  • mysql-haskell

    Pure haskell mysql driver

  • Neks

    A dead simple networked key/value store

  • sqlite-simple

    Mid-level bindings for sqlite

  • hssqlppp

    sql parser and type checker in haskell

  • hasql-th

    Template Haskell utilities for Hasql

    Project mention: Parsing SQL | news.ycombinator.com | 2022-08-22

    unexpected '&'

    https://github.com/nikita-volkov/hasql-th#error-example-1

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-02-01.

Haskell Database related posts

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
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com