Mastering SQLDelight Database in Android with Jetpack Compose

Delve into SQLDelight, a robust database library designed for Android projects. You’ll start by setting up SQLDelight in Android Studio and learn to define database schemas using .sq files for type-safe Kotlin mappings. From building tables and queries to managing relationships between entities, you’ll explore key concepts like SQL joins and CRUD operations. Along the way, you’ll implement reactive database interactions with Kotlin Coroutines and Flows, integrate SQLDelight into MVVM architecture with Jetpack Compose, and master techniques for testing and debugging your database. By the end, you’ll have the skills to build scalable, data-driven apps with SQLDelight.

Codelab Objectives

In this codelab, you’ll explore:

  • Understand SQLDelight and its advantages over Room for Android apps
  • Learn to set up SQLDelight with plugins and dependencies in Android Studio
  • Define database schemas using .sq files with type-safe Kotlin mappings
  • Building tables, entities, and database queries with SQLDelight
  • Relationships between objects in database tables/entities
  • Write SQLDelight queries for CRUD operations like Insert, Select, Update, Delete
  • Understanding SQL Joins for handling relational data across tables
  • Testing and Debugging SQLDelight Database
  • Implement reactive database operations with Kotlin Coroutines and Flows
  • Integrate SQLDelight with MVVM architecture and Jetpack Compose UI design

Codelab Content

Meet the instructor

Kaaveh Mohamedi

Content Author & Course Instructor

More courses by the instructor