sqlite-simple
sqlite-simple copied to clipboard
nurpax
Mid-level bindings for sqlite
Hello! I noticed today that when I `INSERT` with `executeMany`, there are multiple insert queries instead of a single query. SQLite supports lists of values to insert mutliple rows in...
The [documentation for `execute`](http://hackage.haskell.org/package/sqlite-simple-0.4.9.0/docs/Database-SQLite-Simple.html#v:execute) says "Execute an INSERT, UPDATE, or other SQL query that is not expected to return results.". However, ultimately `execute` calls `Database.SQLite3.prepare` [whose documentation](http://hackage.haskell.org/package/direct-sqlite-2.3.15/docs/Database-SQLite3.html#v:prepare) says "Unlike exec,...
If I have an existing parser, it would be nice to have an easy way to use that to parse database contents, like maybe: ``` fieldWithParser :: String -> (Text...
Hi Nurpax, my current software uses large tables, and therefore FromRow instances are getting a bit hard to manage, with all these "field" that I must count. I think it...
I'm trying to run a query that is essentially `select * from t where c like '%?%'` where the `?` is provided as argument. However the placeholder isn't recognized and...
When hitting conversion errors in type conversion in row/field parsers, the function in: http://www.sqlite.org/c3ref/column_database_name.html might be useful for more descriptive error message - it'd be helpful to show the name...
It is possible to somehow use SQLite's `RETURNING` clause with `sqlite-simple`? https://www.sqlite.org/lang_returning.html SQLite's `RETURNING` clause enables `INSERT` / `UPDATE` / `DELETE` statements to return values from each each row that...
