SQLite bindings for Haskell using hsql.
Created attachment 63062 [details] The ebuild for dev-haskell/hsql-sqlite3-1.6
Created attachment 64250 [details] Ebuild using cabal eclass
I've been trying the test HSQL-1.7/examples/Main.hs I've got it working for odbc, postgresql and mysql but not sqlite3. What goes wrong is that the test program can't extract integer fields. It's fine with varchar or string fields but not int ones. The error reported is: The type of id field can't be converted to SqlText type Note that it works ok when we try to extract an int field as a Haskell String but not an int field as a Haskell Int (which is what the example program tries to do). I'll add the postgresql, mysql and odbc backends to gentoo and leave the sqlite3 backend for the moment. If anyone has a patch to make the sqlite3 backend work with the example program then I'll be happy to include that into the gentoo package and add the sqlite3 backend too.
Thanks to Bjorn Bringert for quickly supplying us with a patch which fixes this problem. The patch is now included in the hsql-1.7 ebuild.
Now unmasked in portage.
Closing.