[Haskell-cafe] recommendation for (best) sqlite3 bindings

Gour gour at gour-nitai.com
Wed Jul 21 00:54:55 EDT 2010


We are looking for recommendation which Haskell bindings for sqlite3
to use for destkop GUI app where we want, among other things to store
*.png and/or *.jpg images. (Yeah, I know about the hint to store
iamges in the filesystem and just store filepaths in the db, but for
portability reasons so that user can easily carry/backup database, we
want everything stored in one file.)

By looking at Hackage, it seems there are 3 candidates:

1) sqlite - bindings by Galois
(http://hackage.haskell.org/package/sqlite) - looks quite complete &
low-level interface

2) direct-sqlite - it says "It is not as complete as bindings-sqlite3 (1),
but is slightly higher-level...it supports strings encoded as UTF8,
and BLOBs represented as ByteStrings." and

3) HDBC-sqlite3 - higher level but without support for BLOBs.

Now, based on the above it looks that 2) is the best one - not
high-level as 2), but adding BLOBs support which, iirc, is missing in

Otoh, having highr-level abstraction ala HDBC is nice, although at the
moment we believe that we won't have need to go to PostgreSQL since it
means that setup would be greatly complicated for the end-user, so
we're staying focused on Sqlite3.

I know there are also Takusen & HSQL, but based on my past experiences
when watching those two projects, it seems they aren not supported as
well as the above itemized ones.

Any recommendation?

May I add that, according to the recent "Merge hsql and HDBC -- there
can only be one!" thread, I can only "+1" for having slight less &
more complete database packages.



Gour  | Hlapicina, Croatia  | GPG key: F96FF5F6
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
Url : http://www.haskell.org/pipermail/haskell-cafe/attachments/20100720/dbe1bcfa/signature-0001.bin

More information about the Haskell-Cafe mailing list