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 typing rules. Best, Leon On Sat, Aug 11, 2012 at 2:39 PM, Janne Hellsten <[email protected]> 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 & > 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 <[email protected]> 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 > [email protected] > http://www.haskell.org/mailman/listinfo/database-devel >
_______________________________________________ database-devel mailing list [email protected] http://www.haskell.org/mailman/listinfo/database-devel
