sqlite-simple
sqlite-simple copied to clipboard
Mid-level bindings for sqlite
I missed that specific function because I couldn't put a type constraint (`FromRow`) in some typeclass.
The implementation is based on `postgresql-simple`([FromField](https://hackage.haskell.org/package/postgresql-simple-0.5.3.0/docs/Database-PostgreSQL-Simple-FromField.html#t:FromField), [ToField](https://hackage.haskell.org/package/postgresql-simple-0.6.2/docs/Database-PostgreSQL-Simple-ToField.html#t:ToField)). [`uuid-types`](https://hackage.haskell.org/package/uuid-types-1.0.3) is used because it contains fewer transitive dependencies, but [`uuid`](https://hackage.haskell.org/package/uuid) is used as a dependency for the test case. This fixes #62.
I don't know whether the `FromField` instance is better as-is or whether `(Right ...) (Left ...)` would be more appropriate.
SQLite stores NaN as NULL so we convert them back as NaN. Small program to illustrate issue. ``` haskell go = withConnection ":memory:" $ \h -> do execute_ h "CREATE...
This makes it impossible to use GND or deriving via to derive FromRow instances. This is rather annoying since there is no good reason for type variable to nominal. Fixing...
I have a query that looks like: ```sql SELECT column FROM table WHERE other_column IN (?) ``` I'm trying to port this code to sqlite-simple, but I can't find a...
Tests for parameter conversion have some strange statements: ``` haskell [Only r]