sqlite db locking with powersync react-native

2 days ago 2
ARTICLE AD BOX

I am using powersync react-native with opsqlite in my mobile client. I download a bundled db in my app and use that to initialize powersync. Now that bundled db has tables which are not synced through powersync. Updates to those are made through small sqlite files.

I download each file and ATTACH it to the main db, extract the updates and then apply them to the database.

While the files are being applied, I can't display data in my UI, data that is already present in my db. It is only when the sqlite file updates are done, I am able to load and see the data.

Read Entire Article