[ANN] First release of PGX (Pure-OCaml PostgreSQL client)

[BrendanLong]

I’m happy to announce the first release of PGX on opam. PGX is a pure-OCaml PostgreSQL client based on PG’Ocaml.

Since the fork, we’ve made the following improvements:

• More tests (80% coverage on the latest commit)
  • We designed our tests so we write them once and then run them against all three IO backends
  • Tests also run on every commit
• More consistent use of async API’s (we do our best to never use synchronous API’s)
• Addition of Pgx.Value for hopefully easier conversion to and from DB types
• Safe handling of concurrent queries (not any faster, but they won’t crash)
• Improved interface for prepared statements to make it harder to use them wrong
• We include Pgx_async, Pgx_lwt, and Pgx_unix (synchronous) so you don’t have to write your IO module (and possibly get it wrong)
• Probably other things I’ve forgotten by now

We’re still looking for feedback on the API and pull requests are welcome!

[keleshev]

I’ve just discovered this, and looks like a really good piece of work. I hope I’ll be able to try pgx soon.

Are you using any ppx on top of this or any user-level conveniences?

[BrendanLong]

There’s currently not any ppx to go with it. We’ve talked about doing something similar to Diesel in Rust, but none of us really have experience with ppx and the convenience factor hasn’t been worth it for us yet.

(We’re definitely open to new contributions though)