<noscript />

kodeco.com uses JavaScript extensively to offer the best possible user experience. JavaScript is currently disabled in your browser, and so we are unable to display all of our wonderful content. Please enable JavaScript in your browser and refresh this page.

Episodes

SQLDelight in Android: Getting Started

14 episodes · 1 hr, 25 mins

Preparation & Setup

Part 1: 11 Episodes · 67 minutes

01. Prepare Your Project 4:16
Locked 02. Configure SQLDelight 4:34
Locked 03. Add Tables to the Database 6:12
Locked 04. Instantiate the Database 5:49
Locked 05. Understand SQLDelight's Type System 7:15
Locked 06. Add Functions to Tables 8:56
Locked 07. Use Grouping Statements 3:57
Locked 08. Utilize Transactions & Rollbacks 7:00
Locked 09. Write Migrations for Your Database 6:52
Locked 10. Create Views for Reusable Sub-Queries 4:57
Locked 11. Validate & Test Database Code 7:23

Advanced SQLDelight Integrations

Part 2: 3 Episodes · 17 minutes

Locked 12. Integrate with RxJava 5:29
Locked 13. Integrate with Kotlin Coroutines 5:12
Locked 14. Integrate with Android Paging 7:09

SQLDelight in Android: Getting Started

Aug 3 2021 · Kotlin 1.4, Android 11, Android Studio 4.1

Part 2: Advanced SQLDelight Integrations

14. Integrate with Android Paging

Notes: 14. Integrate with Android Paging

For more insight into what the Android Paging library can do for apps beyond what’s covered here, check out the official docs on the subject.

Heads up... You’re accessing parts of this content for free, with some sections shown as ostupnepyp text.

Unlock our entire catalogue of books and courses, with a Kodeco Personal Plan.
Unlock now

00:02The Android Paging library helps developers deal with segmented access to long lists of data. Assuming that the power users of our bug collector app could aggregate hundreds and thousands of collections over time, the performance of the app may start to degrade over time when all data is pulled from the database at the same time.

dependencies {
    implementation "com.squareup.sqldelight:android-paging-extensions:$sqldelightVersion"

    // Android Paging
    implementation "androidx.paging:paging-runtime-ktx:2.1.2"
}

+count:
+SELECT count(*) FROM collection;

all:
-SELECT * FROM collection;
+SELECT * FROM collection
+LIMIT :limit OFFSET :offset;

-fun listCollections(): Query<Collection> {
+fun listCollections(): DataSource.Factory<Int, Collection> {
    return database.collectionQueries.all()
}

fun listCollections(): DataSource.Factory<Int, Collection> {
-    return database.collectionQueries.all()
+    return QueryDataSourceFactory(
+
+    )    
}

fun listCollections(): DataSource.Factory<Int, Collection> {
    return QueryDataSourceFactory(
+        queryProvider = database.collectionQueries::all,
+        countQuery = database.collectionQueries.count(),
+        transacter = database.collectionQueries
    )
}

-private val collectionQueryListener = object : Query.Listener {
-    override fun queryResultsChanged() {
-        refreshState()
-    }
-}

-private val collectionQuery = repository.listCollections()
+private val collectionQuery = repository.listCollections().toLiveData(pageSize = 3)

+private val observer = Observer<PagedList<Collection>> { collections ->
+    _state.value = State.Result(
+        collections = collections
+    )
+}

init {
-    refreshState()
-
-    collectionQuery.addListener(collectionQueryListener)
+    collectionQuery.observeForever(observer)
}

override fun onCleared() {
-    collectionQuery.removeListener(collectionQueryListener)
+    collectionQuery.removeObserver(observer)
}

-private fun refreshState() {
-    _state.value = State.Result(
-        collections = collectionQuery.executeAsList()
-    )
-}


sealed class State {
    object Loading : State()
-    data class Result(val collections: List<Collection>): State()
+    data class Result(val collections: PagedList<Collection>): State()
}

-class CollectionListAdapter : ListAdapter<Collection, CollectionHolder>(diffCallback) {
+class CollectionListAdapter : PagedListAdapter<Collection, CollectionHolder>(diffCallback) {

  override fun onBindViewHolder(holder: CollectionHolder, position: Int) {
    // Ensure a formatter is available to format the collection's timestamp.
    // Create the object when the first ViewHolder is being bound
    val formatter = this.formatter ?: holder.itemView.resources
      .getDateTimeFormatter(R.string.timestamp_format)
      .also { this.formatter = it }

    // Style
    val item = getItem(position)
-    holder.idTextView.text = "#${item.collectionId}"
-    holder.nameTextView.text = item.name
-    holder.creationTextView.text = item.creationTime.format(formatter)
-
-    // Listeners
-    holder.layout.setOnClickListener { _clickEvents.offer(item.collectionId) }
+
+    if (item != null) {
+        holder.idTextView.text = "#${item.collectionId}"
+        holder.nameTextView.text = item.name
+        holder.creationTextView.text = item.creationTime.format(formatter)
+        holder.layout.setOnClickListener { _clickEvents.offer(item.collectionId) }
+    } else {
+        holder.idTextView.text = "..."
+        holder.nameTextView.text = null
+        holder.creationTextView.text = null
+        holder.layout.setOnClickListener(null)
+    }
}

SQLDelight in Android: Getting Started

Part 2: Advanced SQLDelight Integrations

14. Integrate with Android Paging

Episode complete

About this episode

Instructors

Contributors

Sign up/Sign in

Sign up/Sign in

Sign up/Sign in

Notes: 14. Integrate with Android Paging

All videos. All books. One low price.

All videos. All books.
One low price.