[Haskell-cafe] Re: recommendation for (best) sqlite3 bindings
michael at snoyman.com
Sun Jul 25 00:15:23 EDT 2010
Sorry I didn't send it earlier, it must have slipped my mind.
On Sun, Jul 25, 2010 at 3:07 AM, Dan Knapp <dankna at gmail.com> wrote:
> I am the author of direct-sqlite, and I thank you for the bug report.
> I'll be fixing this as soon as I'm able. It's always nice to hear
> about people using my code!
> On Wed, Jul 21, 2010 at 2:10 AM, Michael Snoyman <michael at snoyman.com>
> > On Wed, Jul 21, 2010 at 8:59 AM, Gour <gour at gour-nitai.com> wrote:
> >> 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)?
> > I didn't investigate it, I would imagine it's pretty complete if Galois
> > wrote it. I stuck with direct-sqlite just because it was so incredibly
> > simple (single file, ~15 functions).
> >> 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.
> > That's why I'm sticking with SQL for my current project.
> >> 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...
> > True, it's a very simple fix. In fact, you can just include the sqlite
> > amalgamation file with the code and not worry about library dependencies.
> > Michael
> > _______________________________________________
> > Haskell-Cafe mailing list
> > Haskell-Cafe at haskell.org
> > http://www.haskell.org/mailman/listinfo/haskell-cafe
> Dan Knapp
> "An infallible method of conciliating a tiger is to allow oneself to
> be devoured." (Konrad Adenauer)
> Haskell-Cafe mailing list
> Haskell-Cafe at haskell.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Haskell-Cafe