capacitor-community / capacitor-community/sqlite

feat: executeSet with SELECT statements

Open
#668 0 comments 0 reactions 0 assignees View on GitHub
feature needs: triage
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.