John A. De Goes

Add support for reading command-line options from file(s)

28

The users command-line app has a top-level command, whose name is ``. For example, if the user was creating a word count CLI, then their top-level command name might be...

Create microsite with compiled examples

2

- [ ] how to use module approach with layer - [ ] use ssh key to logged in into ftp server

Sketch prototype that lifts ordinary Scala code to ZFlow / Remote using Scala 3 macros

1

A prototype that is incomplete could demonstrate the feasibility of lifting ordinary Scala code into `ZFlow`: ```scala ZFlow.define { if (2 + 2 == 4) "foo" else "bar" } :...

Effectively leverage typed errors by defining precise sealed hierarchy of errors

5

Ideally, we would have a `sealed trait` that defines every possible error that can result from JDBC, each as a case class that stores relevant context, including any underlying `Throwable`....

Replace Schema-based derivation of encoder / decoder with ZIO Schema Deriver-based derivation

10

Currently, ZIO JDBC directly converts from Schema to encoders / decoders by generating the appropriate type class instances (JdbcEncoder, JdbcDecoder). This is not ideal, because it means a user does...

Create Getting Started page for microsite

3

Add a page to the microsite that has getting started: - How to add the library to sbt as a dependency - How to create various queries - How to...

Add other helper functions to construct SQL

1

These can be useful to make it easier to create correct SQL. ```scala Sql.select("name", "age") Sql.insertInto("users") Sql.deleteFrom("users") Sql.update("users") ``` /cc @zagyi @yisraelU

Introduce type alias for Sql[ZResultSet]

1

The type `Sql[ZResultSet]` is of special significance: it indicates a fragment of a SQL query, which has probably not yet been completed (to represent fully-formed SQL), nor mapped into any...

The current decoder goes through the intermediate `DynamicValue` and recomputes the conversion steps on every value decoded (there is no per-Schema/Metadata caching).