Have you considered using an embedded database in an application with SQLite?

Yes, using SQLite in Android applications is a common approach for storing local data. SQLite is a lightweight embedded relational database that does not require a separate server and stores data in a single file.

Advantages of using SQLite:

• Easy to integrate and use.
• Good performance for small to medium-sized data.
• Supports standard SQL.

Example of creating and using an SQLite database in Android with SQLiteOpenHelper:

class MyDatabaseHelper(context: Context) : SQLiteOpenHelper(context, "mydb.db", null, 1) {
    override fun onCreate(db: SQLiteDatabase) {
        db.execSQL("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
    }

    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
        db.execSQL("DROP TABLE IF EXISTS users")
        onCreate(db)
    }
}

// Usage:
val dbHelper = MyDatabaseHelper(context)
val db = dbHelper.writableDatabase
val values = ContentValues().apply {
    put("name", "Ivan")
}
db.insert("users", null, values)

SQLite is suitable for caching, storing settings, small data collections, etc.