
Hi list, I've been looking for better Haskell sqlite bindings for few months now. So far I've tried or investigated the following sqlite packages: - hdbc-sqlite3 - sqlite - direct-sqlite At the same time I've played around a bit with postgresql-simple. I've come to quite like the postgresql-simple API and would like to have a access API for sqlite. Unfortunately, all the existing sqlite bindings seem to offer a much lower level interface. I'm thinking that if no *-simple style Haskell library exists for sqlite3, I'd like to create one. I've exchanged a few e-mails about this with Leon and with his help have a few ideas on how to go about it. Leon suggested that the design should be two libraries: one low-level library that can be unsafe to use directly and another medium-level package that's built on the low-level library. The medium part would borrow pretty directly from existing *-simple packages. I dabbled a bit with my own low-level sqlite bindings but later came to realize that the direct-sqlite package (http://ireneknapp.com/software/) seems to be pretty close to what I'd need. So I'm thinking that could be the low-level part of sqlite-simple. Does this seem like a useful thing to build? (I know I'd need it.) Does something like this already exist? Thanks! Janne

sounds useful. You can also check out Michael Snoyman's sqlite
bindings used in Persistent:
http://hackage.haskell.org/package/persistent-sqlite and the one in
groundhog:https://github.com/lykahb/groundhog/blob/master/backends/sqlite/Database/Sql...
On Wed, Aug 1, 2012 at 11:41 AM, Janne Hellsten
Hi list,
I've been looking for better Haskell sqlite bindings for few months now.
So far I've tried or investigated the following sqlite packages:
- hdbc-sqlite3 - sqlite - direct-sqlite
At the same time I've played around a bit with postgresql-simple. I've come to quite like the postgresql-simple API and would like to have a access API for sqlite.
Unfortunately, all the existing sqlite bindings seem to offer a much lower level interface.
I'm thinking that if no *-simple style Haskell library exists for sqlite3, I'd like to create one.
I've exchanged a few e-mails about this with Leon and with his help have a few ideas on how to go about it.
Leon suggested that the design should be two libraries: one low-level library that can be unsafe to use directly and another medium-level package that's built on the low-level library. The medium part would borrow pretty directly from existing *-simple packages.
I dabbled a bit with my own low-level sqlite bindings but later came to realize that the direct-sqlite package (http://ireneknapp.com/software/) seems to be pretty close to what I'd need. So I'm thinking that could be the low-level part of sqlite-simple.
Does this seem like a useful thing to build? (I know I'd need it.)
Does something like this already exist?
Thanks!
Janne
_______________________________________________ database-devel mailing list database-devel@haskell.org http://www.haskell.org/mailman/listinfo/database-devel
participants (2)
-
Greg Weber
-
Janne Hellsten