DATA MANAGEMENT IN MOBILE APPS

5. Example (Kotlin with Room): Kotlin

Example (Kotlin with Room):

Kotlin

@Entity(tableName = "users")

data class User(

    @PrimaryKey(autoGenerate = true) val id: Int = 0,

    @ColumnInfo(name = "name") val name: String,

    @ColumnInfo(name = "email") val email: String

)

 

@Dao

interface UserDao {

    @Query("SELECT * FROM users")

    fun getAllUsers(): List<User>

 

    @Insert

    fun insertUser(user: User)

 

    // ... other DAO methods (update, delete, etc.) ...

}

 

@Database(entities = [User::class], version = 1)

abstract class AppDatabase : RoomDatabase() {

    abstract fun userDao(): UserDao

}

 

// In your Activity:

val db = Room.databaseBuilder(applicationContext, AppDatabase::class.java, "my_database").build()

val userDao = db.userDao()

 

userDao.insertUser(User(name = "John Doe", email = "john.doe@example.com"))

val users = userDao.getAllUsers()

SQLite Integration in iOS (Swift/Objective-C):