Sobes.tech
Junior — Middle

Milliseid meetodeid ja tööriistu kasutad andmebaasiga suhtlemiseks?

sobes.tech AI

Vastus AI-lt

To interact with a database in Android, the following methods and tools are most commonly used:

  • SQLite — an embedded relational database. You can use the SQLiteOpenHelper class to work with it.
  • Room — a library from Google that simplifies working with SQLite by providing a convenient ORM layer and annotation support.
  • ContentProvider — for data exchange between applications.
  • Realm or ObjectBox — alternative NoSQL databases for mobile applications.

Example of using Room:

@Entity
data class User(
    @PrimaryKey val id: Int,
    val name: String
)

@Dao
interface UserDao {
    @Query("SELECT * FROM user")
    fun getAll(): List<User>

    @Insert
    fun insert(user: User)
}

@Database(entities = [User::class], version = 1)
abstract class AppDatabase : RoomDatabase() {
    abstract fun userDao(): UserDao
}

// Initialization
val db = Room.databaseBuilder(
    context,
    AppDatabase::class.java, "database-name"
).build()

// Usage
val users = db.userDao().getAll()