Try to install hpc-coveralls after installing this project's package dependencies. The idea is that hpc-coveralls installation shouldn't affect what libraries get installed, rather hpc-coveralls installation should try to just use the same libraries that snaplet-sqlite-simple depends on. Hopefully this fixes a build break on Travis CI.
These test will exercise at least lookupByUserId backend function which was previously uncovered. The tests come from commit ad60dbf4 from https://github.com/snapframework/snap. Unfortunately that commit is made by "Your Name" from example.com, so I don't know exactly who to attribute this to. :)
Encode empty roles/meta data as NULLs in the database Favor using Data.Text over ByteStrings for storing JSON text in the database. This patch requires the latest sqlite-simple version from github. This will be released shortly on hackage.