postgresql-simple
postgresql-simple copied to clipboard
lpsmith
Mid-level client library for accessing PostgreSQL from Haskell
Hello, TSVector type of Postgres is the following: https://www.postgresql.org/docs/8.3/datatype-textsearch.html Example of tsvector: "'cat':2 'dog:5 'animal':10" To add the FromField instance we need a parser. Do you have an example of...
It would be nice if the `gfromRow` and `gtoRow` functions were exported so we could build our own generic instances from them.
I took a stab at adding an `Interval` ADT to this library as per this conversation: https://github.com/lpsmith/postgresql-simple/issues/176 Let me know your thoughts or any changes you'd like to see. FYI...
`RangeBound` has too many constructors. In general Postgres ranges do not have the concept of `PosInfinity` or `NegInfinity`. So it would be preferable for these to be replaced with a...
If you query PostgreSQL directly, valid ranges are accepted and invalid ranges throw an error. ``` test=> select '[1,5]' :: int4range; int4range ----------- [1,6) (1 row) test=> select '[5,1]' ::...
[connectPostgreSQL](https://github.com/lpsmith/postgresql-simple/blob/be85ee90b35a35f5de099d820cd18c7239c4eea0/src/Database/PostgreSQL/Simple/Internal.hs#L226) executes several `SET` commands automatically right after connecting to database: ```haskell let settings | version < 80200 = "SET datestyle TO ISO;SET client_encoding TO UTF8" | otherwise = "SET...
Would it be reasonable to drop the connection lock here? https://github.com/lpsmith/postgresql-simple/blob/14d00c22713aab7d55a81a81b47cc5bb7280398f/src/Database/PostgreSQL/Simple/Copy.hs#L135 I'm working on some code that needs to interleave (blocking) getCopyData and putCopyData. It seems to work for me...
Sometimes PostgreSQL gets confused about types if there's no explicit typing; I've noticed it with a non-empty array (`PGArray`) of enum elements, which gets recognized as `text[]` instead of `user_role[]`...
`thyme` supplies alternative `UTCTime` etc. types to the ones from `time`; it would be nice if they could be supported too.
So, I've been notificing a pattern in some of my own code (and similarly in postgresql-simple code). There seems to be quite a bit of duplication of functions depending on...
