[database-devel] New mid-level API for sqlite: sqlite-simple
leon.p.smith at gmail.com
Sat Aug 11 22:31:05 CEST 2012
In the Readme, you mention the type issue is less relevant to
sqlite-simple than the others.
Now, I've not actually used SQLite myself, but I have done some reading
about it. I do understand that values of any type can be stored at any
time in any column (except for the primary key, IIRC), but what happens
to the declared type of a column when you create a table? Is that
completely ignored? Can it be retrieved? Is it also returned somehow
with the results?
I mean, it may still be a good idea to be able to check that somehow.
Though this does add the complication that you still want to be able to use
sqlite-simple with existing databases that don't necessarily follow the
On Sat, Aug 11, 2012 at 2:39 PM, Janne Hellsten <jjhellst at gmail.com> wrote:
> 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 &
> A working prototype can be found here:
> 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
> - but of course I may have missed something obvious.
> Comments, concerns? Let me know!
> On Wed, Aug 1, 2012 at 9:41 PM, Janne Hellsten <jjhellst at gmail.com> 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
> database-devel mailing list
> database-devel at haskell.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the database-devel