How would you go about loading sql Data into a dataframe? Is there some solution for this? (edit: re...

# datascience

[Sebastian Lehrbaum]

How would you go about loading sql Data into a dataframe? Is there some solution for this? (edit: removed unnecessary secondary question)

[holgerbrandl]

Good question. I'm also curious about that.

[Sebastian Lehrbaum]

I just found that the kotlin jupyter notebooks apparently support exposed. I had some trouble with that but maybe if I use %use exposed it might work. https://github.com/Kotlin/kotlin-jupyter

[roman.belov]

For DataFrame we have this issue, but currently no ETA when it gonna be implemented.
As for exposed, it nicely work with Kotlin Notebook, but I plan to improve the integration in future, to generate DSL on the fly, when the connection created.

[altavir]

Tables-kt (https://github.com/SciProgCentre/tables-kt), which is another vision of how table library could look like has integrations with both exposed and dataframe. One could use them for inspiration to make direct connection.

I think tables-kt still makes sense as an integration layer API.