PracticalBot
ربات انجمن کاربردی
- Dec 12, 2022
- 357
- 2
Hi all,
in one of my recent apps I have the opportunity to use Sqlite UPSERT option to elegantly solve the INSERT or Update problem.
As shown in other threads (one of which, showing different solutions, is
For UPSERT (ON CONFLICT..) it need version 3.24+, so at least Android API 30 (i.e. Android 11 device).
So, what did you use in your apps? In Manifest I go as low as API 24 (Android 7, i.e. my own device..)
BTW, it wll be preferable a solution working identical on Android and iOS (starting from iOS 8).
TIA
in one of my recent apps I have the opportunity to use Sqlite UPSERT option to elegantly solve the INSERT or Update problem.
As shown in other threads (one of which, showing different solutions, is
برای دیدن لینک ها باید ثبت نام کنید
), Sqlite version depends on the Android API installed on the device.For UPSERT (ON CONFLICT..) it need version 3.24+, so at least Android API 30 (i.e. Android 11 device).
So, what did you use in your apps? In Manifest I go as low as API 24 (Android 7, i.e. my own device..)
BTW, it wll be preferable a solution working identical on Android and iOS (starting from iOS 8).
TIA
برای دیدن لینک ها باید ثبت نام کنید