How to take backup in sqldelight android and KMM

[gulabsagevadiya]

I just wanted to know that how to generate backup file in android or KMM? Can we import .db file of room database in to sqldelight ?

[dellisd]

You can use any .db file with SQLDelight as long as its schema matches what you've defined in your .sq files.

Likewise, you can just back up your .db file. It's a plain SQLite database file.

[gulabsagevadiya]

But I don't know the method name for take the .db file or any snippet of taking and restoring backup with sqldelight

[dellisd]

There's nothing built into SQLDelight for this. It's something you have to implement yourself.

The specifics are a little different depending on the platform you're targeting, but for example on the JVM:

When you create your JdbcSqliteDriver, you pass it a JDBC string that includes a path to some .db file where the database is located, or where to create the file if it doesn't already exist.
To "backup" that file, you can just copy it. To "restore" that file, you can just copy your backup into the location of that path.

val dbPath = Path("/some/path/to/your/database.db")
val backupPath = Path("/the/backup/location")

val driver = JdbcSqliteDriver("jdbc:sqlite:$dbPath")

// Backup the database file
Files.copy(dbPath, backupPath)

// Restore the database file
Files.copy(backupPath, dbPath)

There are all regular Java file operations, and on Kotlin/Native you would use the equivalents for that platform to copy the database file.