Hey all, what's the best way to plug-in a SQLDelight `SqlDriver` that is persistent and works on Des...

# compose-desktop

[Iliyan Germanov]

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
    }
}

[Michael Paus]

What about

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

[Iliyan Germanov]

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

[Iliyan Germanov]

We don't care about migrations or anything. Just need the minimal code to get it running simalrly to how it runs on Android via the SQLite driver

[Michael Paus]

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

[Iliyan Germanov]

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

[Michael Paus]

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

[Iliyan Germanov]

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

[Arkadii Ivanov]

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