capacitor-community / capacitor-community/sqlite
feat: executeSet with SELECT statements
- Dominant language
- Swift
- Stars
- 661
- Forks
- 158
- PR merge metrics
- No merged PRs in 30d
Description
I am working on an Angular Ionic Project that uses "Database Driven Layouts". Some Pages require a lot of single Select Statements to be executed which is very slow on Android. So i tried to execute all Select queries at once using the "executeSet" Method.
This works fine on Web but on Android this Exception is thrown: "ExecuteSet: unknown error (code 0): Queries can be performed using SQLiteDatabase query or rawQuery methods only."
The Android implementation of the executeSet Method does not consider SELECT statements, which is a major problem since improving performance on Android was the reason i did this in the first place.
I realise that i could also just use a single UNION SELECT Query, which is what i will do now. If there is no intention to make ExecuteSet compatible with SELECT statements then feel free to close this issue.
`let rs = await this.db.executeSet(statements, false, 'all');`
executeSet call with parameters
Contributor guide
Assessment
This issue has not been assessed yet.