Reactive support via R2DBC and Coroutines Flow

kotlin-orm / ktorm

A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.

https://www.ktorm.org

Apache License 2.0

2.13k stars 147 forks source link

Reactive support via R2DBC and Coroutines Flow #23

Open sdeleuze opened 5 years ago

sdeleuze commented 5 years ago

It would be awesome if Ktorm could be non-blocking and reactive by leveraging R2DBC instead of JDBC exposed via Coroutines and its Flow API instead of Sequence.

vincentlauvlwj commented 5 years ago

Thanks for your suggestion.

I did consider to make Ktorm non-blocking via coroutines. But it requires a huge refactoring of existing code base, so I don't know when it will be released. Maybe in a far future.

corneil commented 5 years ago

My first suggestion would be to change so that a query is applied to a connection object. Then the JDBC and R2DBC specific code can be separated. This would also allow for multiple datasources.

Globegitter commented 5 years ago

I am working on an application where I will have to select data from quite large tables, so an async Flow API with postgresql set to single row mode would make this library perfect for this.