Haskell Database

Open-source Haskell projects categorized as Database | Edit details

Top 23 Haskell Database Projects

  • postgrest

    REST API for any Postgres database

    Project mention: Five Easy to Miss PostgreSQL Query Performance Bottlenecks | news.ycombinator.com | 2022-01-18

    For OLAP-style use-cases, I wouldn't recommend SQLite, but rather something equally (apparently) unfashionable: stored procedures.

    In both cases, the goal is to save the time spent round-tripping queries and responses to the DB. But with OLAP, you more-than-likely have a large dataset that needs its own dedicated beefy DB to process. So rather than moving the data to the code (with e.g. SQLite), move the code to the data (by moving as much of your business layer as possible into the DB. Or possibly all of it, ala https://postgrest.org/.)

  • erd

    Translates a plain text description of a relational database schema to a graphical entity-relationship diagram.

    Project mention: Ask HN: Open-source DB- ERD tool | news.ycombinator.com | 2021-11-23
  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • opaleye

    Project mention: Embedded Pattern Matching | reddit.com/r/haskell | 2021-09-05
  • beam

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

    Project mention: Reflections On Using Haskell For My Startup | reddit.com/r/haskell | 2021-02-17

    The beam library is one example of this: https://github.com/haskell-beam/beam/pulls

  • Espial

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

    Project mention: I closed a lot of browser tabs | news.ycombinator.com | 2021-08-10

    you could run my self-hosted bookmarking site locally (which includes basic notes) https://github.com/jonschoning/espial

  • selda

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

  • hasql

    Performant PostgreSQL driver with a flexible mapping API

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • bloodhound

    Haskell Elasticsearch client and query DSL (by bitemyapp)

  • squeal-postgresql

    Squeal, a deep embedding of SQL in Haskell

  • hedis

    A Redis client library for Haskell.

  • acid-state

    Add ACID guarantees to any serializable Haskell data structure

    Project mention: Hey Rustaceans! Got an easy question? Ask here (15/2021)! | reddit.com/r/rust | 2021-04-12

    Is there anything like acid-state in Rust?

  • 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

    Project mention: Async Control Flow | reddit.com/r/haskell | 2021-03-21

    Hmm, you are right, the bracket I pointed to is unrelated. I guess the fix is in catchAny, which doesn't catch ThreadKilled. So not it's not rolling the transaction back in case of asynchronous exceptions. My point is that it probably should not rollback even on synchronous exception. BTW the issue is well know, see for example here

  • esqueleto

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

  • 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

  • mongoDB

    MongoDB driver for Haskell (by mongodb-haskell)

  • hw-kafka-client

    Kafka client for Haskell, including auto-rebalancing consumers

  • Neks

    A dead simple networked key/value store

  • HDBC

    Haskell Database Connectivity

  • mysql-haskell

    Pure haskell mysql driver

  • sqlite-simple

    Mid-level bindings for sqlite

  • hssqlppp

    sql parser and type checker in haskell

  • hasql-th

    Template Haskell utilities for Hasql

    Project mention: Haskell doesn't make sense without pure functions | reddit.com/r/haskell | 2021-10-02

    I'd consider hasql-th a good example in what concerns databases. Otherwise, I just use aeson together with deriving-aeson and lens-aeson.

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 2022-01-18.

Haskell Database related posts


What are some of the best open-source Database projects in Haskell? This list will help you:

Project Stars
1 postgrest 18,266
2 erd 1,519
3 opaleye 550
4 beam 495
5 Espial 448
6 selda 446
7 hasql 437
8 bloodhound 406
9 squeal-postgresql 312
10 hedis 304
11 acid-state 259
12 HDBC-session 221
13 postgresql-simple 211
14 esqueleto 177
15 groundhog 167
16 mongoDB 150
17 hw-kafka-client 126
18 Neks 116
19 HDBC 112
20 mysql-haskell 111
21 sqlite-simple 110
22 hssqlppp 104
23 hasql-th 96
Find remote Database jobs at our new job board 99remotejobs.com. There is 1 new remote job listed recently.
Are you hiring? Post a new remote job listing for free.
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.