sqlite-android icon indicating copy to clipboard operation
sqlite-android copied to clipboard

Published 20 hours ago • verified publisher icon requery

Support execPerConnectionSQL

Open R4md4c opened this issue 3 years ago • 1 comments

Recently API 30 has introduced a new API called execPerConnectionSQL, it allows clients to execute PRAGMA statements per connection.

It would be nice if Requery could introduce this API that can work on Pre API 30 devices.

My usecase is that I'd like to stop auto-checkpointing on the DB by performing PRAGMA wal_autocheckpoint=0, however as far as I learned, this needs to be executed per connection, rather than at the start of opening of the DB.

R4md4c avatar Nov 03 '20 13:11 R4md4c

SupportSQLiteDatabase is going to get this method soon for other non-framework bindings like Requery to implement.

https://android-review.googlesource.com/c/platform/frameworks/support/+/1491164/

R4md4c avatar Nov 12 '20 19:11 R4md4c