John A. De Goes

Each time a new / fresh connection to the database is attempted (as part of growing the connection pool), we can increment counters that track successes & failures using ZIO...

This can be powered by ZIO 2.0 metrics.

Support Prepared Statements

1

Parameterized queries can offer higher performance.

**ISSUE** ZIO SQL was created before ZIO JDBC, and as a result, had to re-create some low-level interface to JDBC, including an asynchronous connection pool, and ZIO wrappers around JDBC...

Depends on https://github.com/zio/zio-sql/issues/148 We need a full-stack test for Oracle. We need an automated ZIO Test that, when run, will execute a simple query, such as `select 1`, against a...

Create UPDATE query examples

3

We need a few examples of UPDATE queries under different schemas, both to validate the design and flesh out edge cases, as well as to show people how to use...

Add dialect-specific extension point to Expr

1

Currently, `Expr` is closed, and subtypes of the `Sql` module cannot add new expressions. This is inconvenient as different dialects of SQL support different constructs. To support extensibility, we can...

Implement partial success

1

Currently, when a `SELECT` is executed, if any row contains a null and the user's data model cannot accommodate it, then the whole query will fail. It would be more...

Currently only the "first" decoding error is captured in `unsafeExtractRow`. But by extending `DecodingError` with some sort of `DecodingError.Both` that can hold two errors, we could capture two decoding errors,...

Feel free to pick one and try to document, asking help for any questions you have about usage or purpose! - [ ] `TypeTag` - [ ] `IsNumeric` - [...