zio-sql
zio-sql copied to clipboard
Type-safe, composable SQL for ZIO applications
A sketch of what stored procedures (and maybe table valued functions for SQL server?) might look like, essentially mandraulically adapted from `FunctionDef` with an adapted type tag allowing for returning...
We need to make the tests between different modules more unified and consistent. Starting with FunctionDefSpec (for every db-module): - split the FunctionDefSpec into CommonFunctionDefSpec and CustomFunctionDefSpec - CommonFunctionDefSpec should...
Support JSONB column type. https://www.postgresql.org/docs/current/datatype-json.html
We want users to have an option of HikariCP connection pool in addition to ZIO SQL native one. This should be a wrapper over HikariDataSource that would implement zio.sql.ConnectionPool interface....
Currently if we want to select all columns of the table, we need to explicitly write them like this: `select(name ++ age).from(persons)` It would be nice to support something like...
Lots of tests in ZIO SQL were written in past, when some operators were not yet available. In many places we could simplify, for example: ``` .... val expected =...
Tests in projects: postgres, mysql, sqlserver and oracle are using Testcontainers. We need to add some `slf4j` backend to these projects to be able to see any logs there. Console...