Room with Coroutines in Android Kotlin

Introduction

Room helps you save and read data on your phone easily. Coroutines let you do this work without freezing the app.

You want to save user notes locally and load them smoothly.

You need to fetch a list of saved items without making the app slow.

You want to update or delete data in the background while the user uses the app.

You want to keep your app responsive when working with a database.

Syntax

Android Kotlin

@Dao
interface YourDao {
  @Query("SELECT * FROM your_table")
  suspend fun getAllItems(): List<YourEntity>

  @Insert
  suspend fun insertItem(item: YourEntity)

  @Delete
  suspend fun deleteItem(item: YourEntity)
}

suspend means the function works with coroutines and runs without blocking the app.

Use @Query, @Insert, and @Delete annotations to tell Room what to do.

Examples

This gets all users from the database without freezing the app.

Android Kotlin

@Dao
interface UserDao {
  @Query("SELECT * FROM users")
  suspend fun getUsers(): List<User>
}

This adds a new user to the database in the background.

Android Kotlin

@Dao
interface UserDao {
  @Insert
  suspend fun addUser(user: User)
}

This deletes a user from the database smoothly.

Android Kotlin

@Dao
interface UserDao {
  @Delete
  suspend fun removeUser(user: User)
}

Sample App

This example shows how to create a simple Room database with a User table. It adds two users and then prints them using coroutines to keep the app smooth.

Android Kotlin

import androidx.room.*
import kotlinx.coroutines.*

@Entity(tableName = "users")
data class User(
  @PrimaryKey val id: Int,
  val name: String
)

@Dao
interface UserDao {
  @Query("SELECT * FROM users")
  suspend fun getUsers(): List<User>

  @Insert
  suspend fun addUser(user: User)
}

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

fun main() = runBlocking {
  val db = Room.inMemoryDatabaseBuilder(
    context = androidx.test.core.app.ApplicationProvider.getApplicationContext(),
    AppDatabase::class.java
  ).build()

  val userDao = db.userDao()

  launch {
    userDao.addUser(User(1, "Alice"))
    userDao.addUser(User(2, "Bob"))

    val users = userDao.getUsers()
    users.forEach { println("User: ${it.id} - ${it.name}") }
  }
}

Important Notes

Always call Room database functions from coroutines or background threads to avoid freezing the app.

Use suspend functions in your DAO to work nicely with coroutines.

Room handles database operations safely and efficiently when combined with coroutines.

Summary

Room stores data on the device using simple code.

Coroutines let Room work without stopping the app from running.

Use suspend functions in DAO to run queries smoothly.

Practice

1. What is the main benefit of using Coroutines with Room in Android development?

easy

A. They replace the need for SQL queries.

B. They automatically create database tables.

C. They allow database operations to run without freezing the app UI.

D. They make the app use less memory.

Solution

1. Step 1: Understand Coroutines role

   Coroutines let tasks run in the background without blocking the main app thread.

2. Step 2: Connect Coroutines with Room

   Room uses suspend functions with Coroutines to perform database operations smoothly without freezing UI.

3. Final Answer:

   They allow database operations to run without freezing the app UI. -> Option C

4. Quick Check:

   Coroutines keep UI responsive = A [OK]

Hint: Coroutines keep UI smooth by running tasks in background [OK]

Common Mistakes:

• Thinking Coroutines create tables automatically
• Believing Coroutines replace SQL queries
• Assuming Coroutines reduce app memory usage directly

2. Which of the following is the correct way to declare a suspend function in a Room DAO interface?

easy

A. suspend fun getAllUsers(): List<User>

B. fun getAllUsers(): List<User>

C. async fun getAllUsers(): List<User>

D. fun suspend getAllUsers(): List<User>

Solution

1. Step 1: Recall suspend function syntax

   A suspend function is declared with the keyword suspend before fun.

2. Step 2: Check each option

   suspend fun getAllUsers(): List<User> correctly uses suspend fun. Plain fun getAllUsers(): List<User> lacks the suspend keyword. fun suspend getAllUsers(): List<User> has the keywords in wrong order. async fun getAllUsers(): List<User> uses async which is not valid here.

3. Final Answer:

   suspend fun getAllUsers(): List<User> -> Option A

4. Quick Check:

   suspend keyword before fun = B [OK]

Hint: Remember: suspend keyword always comes before fun [OK]

Common Mistakes:

• Placing suspend after fun
• Using async instead of suspend
• Omitting suspend keyword for coroutine functions

3. Given this DAO function:

 @Query("SELECT * FROM users")
 suspend fun getUsers(): List<User>

What happens when you call getUsers() from a coroutine?

medium

A. The function blocks the main thread until data is fetched.

B. The function suspends the coroutine until data is fetched, then returns the list.

C. The function returns immediately with an empty list.

D. The function throws a compile-time error.

Solution

1. Step 1: Understand suspend function behavior

   A suspend function pauses the coroutine without blocking the thread until the result is ready.

2. Step 2: Apply to Room DAO call

   Calling getUsers() suspends the coroutine until Room fetches data, then returns the list.

3. Final Answer:

   The function suspends the coroutine until data is fetched, then returns the list. -> Option B

4. Quick Check:

   suspend functions pause coroutine, not block thread = C [OK]

Hint: Suspend functions pause coroutine, not block main thread [OK]

Common Mistakes:

• Thinking suspend blocks main thread
• Expecting immediate empty list return
• Assuming compile-time error on suspend

4. You wrote this DAO method:

@Query("SELECT * FROM users")
fun getUsers(): List<User>

When calling getUsers() from a coroutine, what problem will occur?

medium

A. The app will crash with a runtime error about main thread database access.

B. The function will suspend correctly and return data.

C. The function will return null instead of data.

D. The function will compile but never return.

Solution

1. Step 1: Identify missing suspend keyword

   The DAO method is not marked suspend, so it runs on the calling thread.

2. Step 2: Understand Room's main thread policy

   Room forbids database queries on the main thread to avoid freezing UI, causing runtime crash if violated.

3. Final Answer:

   The app will crash with a runtime error about main thread database access. -> Option A

4. Quick Check:

   Non-suspend DAO on main thread causes crash = A [OK]

Hint: Always mark DAO queries suspend to avoid main thread crash [OK]

Common Mistakes:

• Forgetting suspend keyword in DAO
• Expecting null return on wrong thread
• Assuming silent failure without crash

5. You want to insert a list of users into the database using Room and Coroutines. Which DAO method signature correctly supports this operation without blocking the UI?

@Insert
??? fun insertUsers(users: List<User>)

hard

A. fun insertUsers(users: List<User>)

B. async fun insertUsers(users: List<User>)

C. fun insertUsers(users: List<User>): Deferred<Unit>

D. suspend fun insertUsers(users: List<User>)

Solution

1. Step 1: Identify correct coroutine support

   To run database operations without blocking UI, DAO methods must be suspend functions.

2. Step 2: Evaluate options

   suspend fun insertUsers(users: List<User>) uses suspend fun, which is correct. fun insertUsers(users: List<User>) blocks UI. fun insertUsers(users: List<User>): Deferred<Unit> returns Deferred which is not standard DAO signature. async fun insertUsers(users: List<User>) uses invalid async keyword.

3. Final Answer:

   suspend fun insertUsers(users: List<User>) -> Option D

4. Quick Check:

   Use suspend fun for non-blocking Room inserts = D [OK]

Hint: Use suspend fun for DAO inserts to keep UI smooth [OK]

Common Mistakes:

• Omitting suspend causing UI freeze
• Using async keyword incorrectly
• Returning Deferred instead of suspend function