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

Gour gour at gour-nitai.com
Wed Jul 21 01:59:39 EDT 2010

On Wed, 21 Jul 2010 08:06:49 +0300
>>>>>> "Michael" == Michael Snoyman <michael at snoyman.com> wrote:

Michael> For the sqlite backend for persistent, I took direct-sqlite
Michael> and modified it slightly. I have a long history of using the
Michael> sqlite3 C API, so the API felt very familiar to me.

So, it seems you're satisfiew with direct-sqlite?

What is missing in 1st package (Galois bindings)?

btw, after some research, I've concluded that NOSQL (Redis, MongoDB)
are not good solutions in our use-case since we want to have extensive
querying support and using sqlite3 with SQL seems better option.

Michael> If I'm not mistaken, direct-sqlite does not build as-is on
Michael> hackage because it's missing a reference to the C library.

Hmm...you're right.

Apparently Archlinux package built OK; but loading it into ghci gives:

ghc: /usr/lib/direct-sqlite-1.0/ghc-6.12.1/HSdirect-sqlite-1.0.o:
unknown symbol `sqlite3_column_blob'

Thank you.

Michael> However, if you take my approach and just include the code in
Michael> your library, you can fix that easily enough.

It looks it's the problem with package's cabal file...



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/20100721/3606b272/signature.bin

More information about the Haskell-Cafe mailing list