I want to read data from postgresql database into ...

# datascience

[Dieter Konrad]

I want to read data from postgresql database into jupyter notebook. Is there any library for such a task in jupyter kotlin? %use ???

[altavir]

You can use any regular kotlin library to do so. Like https://github.com/JetBrains/Exposed

[Ilya Muradyan]

Search for sql on this page gives exposed (and mysql , but it is not suitable for PostgreSQL DB)

[altavir]

Oh, you already have a descriptor for exposed. I've missed that.

[Carter]

If such a dependency exists outside of jupyter kotlin notebooks, then you can create a JSON file to describe the dependency so that you can import it.

Example of how I imported uuid, datetime, and immutable collections

{
  "description": "My Dependencies",
  "properties": {
    "uuidVersion": "0.2.3",
    "kotlinxImmutableCollectionsVersion": "0.3.3",
    "kotlinxDateTimeVersion": "0.1.1"
  },
  "repositories": [
    "<https://kotlin.bintray.com/kotlin-datascience>",
    "<https://kotlin.bintray.com/kotlinx>"
  ],
  "dependencies": [
    "org.jetbrains.kotlinx:kotlinx-collections-immutable:$kotlinxImmutableCollectionsVersion",
    "com.benasher44:uuid:$uuidVersion",
    "org.jetbrains.kotlinx:kotlinx-datetime:$kotlinxDateTimeVersion"
  ]
}

%use my-dependencies@file[/data/workspace_files/my-dependencies.json]

[Carter]

The documentation for this leaves much to be desired.

[altavir]

for such simple cases it iasier to use Repository/DependsOn/import notations in the notebook. If you need to wrap your own library I recommend to try the new Notebook Api descriptors

[Carter]

i couldn’t get such syntax to work, although if you have examples to share I’m sure that would be helpful.

[altavir]

Here you are: https://github.com/mipt-npm/plotly.kt/blob/dev/plotlykt-jupyter/src/main/kotlin/space/kscience/plotly/PlotlyIntegration.kt

[altavir]

And here is even newer one, using resource builders: https://github.com/mipt-npm/visionforge/blob/dev/demo/jupyter-playground/src/main/kotlin/hep/dataforge/playground/VisionForgePlayGroundForJupyter.kt

[altavir]

oops, wrong link. This one: https://github.com/mipt-npm/visionforge/blob/dev/jupyter/visionforge-gdml-jupyter/src/jvmMain/kotlin/GdmlForJupyter.kt