Tag Archives: database

haskelldb: high level, type safe database queries for Haskell

The venerable haskelldb high level database interface for Haskell is now packaged up for Arch.

HaskellDB is a combinator library for expressing queries and other operations on relational databases in a type safe and declarative way. All the queries and operations are completely expressed within Haskell, no embedded (SQL) commands are needed.

The code base is around a decade now, and quite mature, but it has only recently been brought into the cabal and hackage world, making it trivial to package up and distribute. You can find all the packages here:

This release of haskelldb is layered over medium-level database interface suite, hdbc., so it can reuse the hdbc backends. The layers of Haskell database libs packaged up looks something like:

  1. High level: haskelldb, Takusen
  2. “Normal” level: HDBC, hsql
  3. Low level: sqlite, anydbm, hsSqlite3, PostgreSQL, BerkeleyDB

Low level ones typically just wrap the C interfaces underneath, providing few new safety guarantees. Medium level ones generally present a “sensible” Haskell API to the exposed db libraries, while the high level ones attempt to abstract out significant safety or productivity by embedding concepts deeper into the language.

Different libraries support different C backends, I’ll attempt to break that down here:

mysql postgres sqlite odbc oracle notes
hdbc Documented in RWH
haskelldb
High level
takusen Chooses backend(s) via compile time flag
hsql ? ? Less active?

Also of note is haskell-couchdb , and even haskell-hs3, for a different storage needs.

Finally, if you want to step away from calling out  to C altogether, and go for something purely in Haskell, there’s haskell-tcache, a transactional cache with configurable persistence in 100% Haskell using transactional memory.

HDBC 2.0: industrial database bindings for Haskell

I’ve updated the John Goerzon’s HDBC bindings in AUR to HDBC 2.0, including the

  • sqlite
  • postgres
  • odbc

backends. Update with:

yaourt --aur -S haskell-hdbc

and pick your preferred backend.

Arch Haskell News: Jan 24 2009

A regular update of Haskell in Arch Linux

Arch now has 864 Haskell packages in AUR.

That’s an increase of 37 new packages in the last 13 days, or 2.8 new Haskell apps and libraries a day so far in January. Well done everyone!.

The current 28 day moving average of releases:

Noteworthy updates

New and updated packages

The Arch Haskell Team maintains the Haskell toolchain on Arch Linux. You can join us in #arch-haskell on freenode.org, or on the mailing list.

HDBC’s new MySQL backend

The new mysql backend to the venerable HDBC Haskell database library, is now in Arch (as is HDBC). Read about HDBC in RWH.

Arch Haskell News: Jan 11 2009

A regular update of Haskell in Arch Linux.

Welcome to the first Arch Haskell News of 2009.

Arch now has 827 Haskell packages in AUR.

That’s an increase of 93 new packages in the last 48 days, or 1.9 new Haskell apps and libraries a day over the holiday season. Well done everyone!.

Noteworthy

New and updated packages

The Arch Haskell Team maintains the Haskell toolchain on Arch Linux. You can join us in #arch-haskell on freenode.org, or on the mailing list.http://www.haskell.org/mailman/listinfo/arch-haskell

HDBC: Haskell database suite: updated

HDBC, John Goerzon’s industrial strength database suite for Haskell has been updated in Arch. You can now get the latest versions of:

This library is the one described in the book “Real World Haskell”.

Arch Haskell News: Nov 02 2008

A weekly update of Haskell in Arch Linux.

Arch now has 672 Haskell packages in AUR.

That’s an increase of 33 new packages in the last 14 days. Growth appears to be holding steady at just over 2 new packages a day on Hackage in October.

Noteworthy

New and updated packages this week

For more information about Haskell on Arch Linux, see the wiki page, or join us online, on IRC, #arch-haskell @ freenode.