A modern programming language that makes developers happier.

kotlinlang

image.png

Hello everyone!
I use SQLDelight and Paging libraries by CashApp. I wrote a code for pagination according to CashApp's documentations. Everything works good, but when data is updated in database, data in list with pagination on UI isn't updated. Functions 'getRefreshKey' and 'load' are also not recalled

I subscribed to the data change in database. I manually refresh data after changing data in database. It works for me

What's inserting data into your database? Is it by chance a different process, like WorkManager?

SQLDelight will only notify other query watchers that data has changed within the same process, I beleive.

<@U5D6V79TL>
Thank you for your response! I'd like to describe my case a little bit more to help understand my problem better.

I think that I insert data into database only from main process because I have only 1 process per application and don't use WorkManagers at current moment.
By the way, my project is OpenSource project so I could share some code for updating and reading data from DB which I use in my application at this case. Probably, someone can find some mistakes in my approach for getting notifications about updates in DB.

Data reading - <https://github.com/1Coin-FinanceTracker/1CoinClient/blob/add_snackbars/common/src/commonMain/kotlin/com/finance_tracker/finance_tracker/data/repositories/TransactionsRepository.kt#LL32C17-L32C38|click>. Data adding - <https://github.com/1Coin-FinanceTracker/1CoinClient/blob/add_snackbars/common/src/commonMain/kotlin/com/finance_tracker/finance_tracker/data/repositories/TransactionsRepository.kt#LL62C6-L62C6|click>.

I just checkout out your project and it doesn't seem like you're using the <https://cashapp.github.io/sqldelight/2.0.0-alpha05/android_sqlite/androidx_paging/|SQLDelight Paging extension>. Would that help at all? The extension uses Multiplatform Paging under the hood, even though it's not clear from the documentation

<@UD3HXT2QM> Sure, I use Paging library by Cash app (`app.cash.paging:paging-common`), but I don't use SQLDelight Paging extension. I've just checked SQLDelight Paging extension. Unfortunately, SQLDelight Paging is available only from `2.0.0-alpha05` version of SQLDelight, isn't it?

Yep, that sounds right. If you're not comfortable depending on an alpha release, you _should_ be able to copy-paste the <https://github.com/cashapp/sqldelight/tree/master/extensions/androidx-paging3/src/commonMain/kotlin/app/cash/sqldelight/paging3|extension source code> while we wait for SQLDelight `2.0.0` to be released. There aren't that many files in the extension, and it doesn't depend on any internals of SQLDelight (just the public facing APIs).