purescript-postgresql-client
purescript-postgresql-client copied to clipboard
rightfold
It seems that this package is not yet listed as part of the most recent https://github.com/purescript/package-sets release https://github.com/purescript/package-sets/releases/download/psc-0.13.6-20200502/packages.dhall
Some FromSQLValue instances are very difficult to write as a result of limitations in node-postgres
Hello! I am currently writing my own set of ps/pg bindings for a personal project. Mason Mackaman suggested possibly using `postgresql-client` instead. (He also mentioned that @paluh had expressed frustration...
General plan: * There was an idea to split docs into section - I'm not sure if this would work with literate style of the README.... * Drop `Generating SQL...
After upgrading Node to the latest version my application stopped working properly even though there were no code changes. I could trace it down to the function `withConnection` that did...
Currently `withConnection` can leak `Connection` value outside of the bracket. Consider adding two versions : ``` withConnection :: forall a . Pool -> (forall h. Either PGError (Connection h) ->...
The problem is with functions like [`withTransaction`](https://github.com/rightfold/purescript-postgresql-client/blob/680da31ee1c6430fe296788994fe029024c75ade/src/Database/PostgreSQL/PG.purs#L53) or `withConnection` that require a function `(m a -> Aff (Either PGError a))`, where `m` is the constrained monad. AFAIK you must concretize...
After reading through [Thoughts on Type Class Codecs](http://code.slipthrough.net/2018/03/13/thoughts-on-typeclass-codecs/), should we follow suit for encoding/decoding values to/from SQL rows? For example, [`purescript-codec`](https://pursuit.purescript.org/packages/purescript-codec/3.0.0) and its application for JSON, [`purescript-codec-argonaut`](https://pursuit.purescript.org/packages/purescript-codec-argonaut/7.0.2)
This can be implemented using a `WeakMap`, mapping connections to nesting counts.
Pools are safe for concurrent use by multiple Aff threads, but connections are not.