any serverless/embedded (like sqlite) database rec...

# random

[Laurent Laborde]

any serverless/embedded (like sqlite) database recommendation ? i want to store some configuration data and “states” (think of it as a load/save in a game, except that i’m not making a game but a simulation). Since i’m doing all this stuff for self-teaching purpose, i might as well take something i don’t know. (i’m a database administrator, the only “serverless” dbms i know is sqlite). it’s not specifically kotlin related so i’m just posting it here. (and it’s not that important either since i could make sqlite fit the need). i’ve heard about objectbox.

[Laurent Laborde]

intellij idea support is a must though

[Gleb Minaev]

As I remember H2 can be embeded DB within JVM-based application. So it has interop with Kotlin via Java.

Also, it has IDEA Ultimate support.

[Laurent Laborde]

i’ll check H2. thx

[Laurent Laborde]

(and i have the whole jetbrains suite)

[Big Chungus]

Firebase? Or do you mean embedded db rather than serverless (as in cloud-based but without a dedicated server)?

[Big Chungus]

Also are you after sql or nosql?

[Laurent Laborde]

i mean embedded

[Laurent Laborde]

i’ll use H2 since this is a database i don’t know.

[Laurent Laborde]

nosql is ok, but i have a strong preference for sql 🙂

[ephemient]

sqldelight also has an idea plugin

[andyg]

H2 is an amazing DB... fast, flexible, powerful. Good choice.