[database-devel] New mid-level API for sqlite: sqlite-simple

Hi again! I finally found some time to work on the below idea of creating a sqlite-simple package that's modeled after postgresql-simple & mysql-simple. A working prototype can be found here: https://github.com/nurpax/sqlite-simple I still need to do a bit of work on it to clean things up and add a bit more functionality. In particular, FromField instances are currently limited to only Ints and Strings - this is obviously not adequate for real use. I consider this to be ready for first release on hackage once I've done some more testing and closed the issues on https://github.com/nurpax/sqlite-simple/issues?milestone=1&state=open - but of course I may have missed something obvious. Comments, concerns? Let me know! Cheers, Janne On Wed, Aug 1, 2012 at 9:41 PM, Janne Hellsten wrote:

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