Hey all, what's the best way to plug-in a SQLDelight

SqlDriver

that is persistent and works on Desktop (Linux, Windows, MacOS)? Here's the Github repo. Best I can do is in-memory one:

import app.cash.sqldelight.db.SqlDriver
import app.cash.sqldelight.driver.jdbc.sqlite.JdbcSqliteDriver
import ivy.Database

actual class SQLDelightDriverFactory {
    actual fun createDriver(): SqlDriver {
        val driver: SqlDriver = JdbcSqliteDriver(JdbcSqliteDriver.IN_MEMORY)
        Database.Schema.create(driver)
        return driver
    }
}

What about

JdbcSqliteDriver("jdbc:sqlite:${dbFilePath}")

I'm noob to Desktop, do you have any good sample/snippet for creating the DB file + getting its path?

The

dbFilePath

is just a String with the path to your DB file.

Ahaa, and the JdbcSqliteDriver will handle the DB file creation itself?

Yes or you can also provide an already existing database file.

Thank you very much @Michael Paus! Appreciated - will try it out 🙂

Check out the example - https://github.com/JetBrains/compose-multiplatform/blob/master/examples/todoapp/common/database/src/desktopMain/kotlin/example/todo/common/database/TodoDatabaseDriverFactory.kt