cordova-sqlite-storage 16kb support

[bevinGithub]

I have received a notice from Android about recompiling the app with 16 KB native library alignment.
The Following Libraries
base/lib/arm64-v8a/libsqlcipher.so
base/lib/x86_64/libsqlcipher.so

I have Cordova Sqlite Storage version 7.0.0

How do we resolve this issue, l already have Android 15 and NDK 28 and 29 already on an Ionic 8 Capacitor 7.

Below is my Ionic 8 Capacitor 7 Environment.

Ionic:

Ionic CLI : 7.2.1 (C:\Users\bevin\AppData\Roaming\npm\node_modules@ionic\cli)
Ionic Framework : @ionic/angular 8.4.3
@angular-devkit/build-angular : 19.2.0
@angular-devkit/schematics : 19.2.0
@angular/cli : 19.2.0
@ionic/angular-toolkit : 12.1.1

Capacitor:

Capacitor CLI : 7.1.0
@capacitor/android : 7.1.0
@capacitor/core : 7.1.0
@capacitor/ios : not installed

Utility:

cordova-res : 0.15.4
native-run : 2.0.1

System:

NodeJS : v20.15.1 (C:\Program Files\nodejs\node.exe)
npm : 10.7.0
OS : Windows 10

[TDola]

Thanks for saving me the time figuring out what plugin was causing the problem. I hope the maintainer comes back.

[bevinGithub]

Hi TDola, l did manage to figure it out. I did update my Awesome Core from 6 to 8. Updated Sqlite from 6 to 7 then ensure on Android studio the AGP is 8.5.1 or higher. Install the NDK to 28 or higher mine is set to 29. Under project settings select the NDK version 28 or 29 then sync the project. After that build the project and test it on Physical device or Simulator that supports 16Kb.

[tiennpdev]

Thank @bevinGithub , I followed your guide and my app supports 16 KB now. Thanks a lot!
My info:

• AGP: 8.13.0
• NDK version 29
• cordova-sqlite-storage: 7.0.0

[bevinGithub]

Pleasure boss and Happy Coding

[jacobg]

If you use Capactor, aren't you using
https://github.com/capacitor-community/sqlite
instead of this cordova-sqlite-storage?

My app is Cordova (not Capacitor). I'm actually using the other cordova-sqlite-evcore-extbuild-free plugin that Brody made. I got to figure out what to do here. It looks like he built his own .so libraries?

Did you build your own native libraries for this update?

[jacobg]

Oh I see. He did update the native libraries on the dependency repo:
https://github.com/brody4hire/cordova-sqlite-storage-dependencies

[bevinGithub]

If you use Capactor, aren't you using https://github.com/capacitor-community/sqlite instead of this cordova-sqlite-storage?

My app is Cordova (not Capacitor). I'm actually using the other cordova-sqlite-evcore-extbuild-free plugin that Brody made. I got to figure out what to do here. It looks like he built his own .so libraries?

Did you build your own native libraries for this update?

Hi l am using Capacitor and cordova-sqlite, it's just easy for me to use and setup, the community plugin was a bit difficulty for me to setup

[TeoMastro]

Hello. I have a problem with the upgrade. After I upgraded the cordova-sqlite-storage to 7 and its awesome cordova plugin wrapper to 8 and my AGP higher than 8.5.1, I have the following problem:
When I open the device manager in android studio, inside my app's folder I see the databases folder with a .db file in it. This has a Date of 1970-01-01 (last modified) and it contains some older data that are now changed. The app is functional, the data are stored and you cannot tell that something is broken but I noticed that they are actually stored in leveldb, which is located inside the app_webview/LocalStorage/leveldb. This is a key-value stored that acts as a fallback to sqlite. I cannot seem to find a correct solution to make it use the sqlite. When I simply go back to capacitor 6 everything works as expected.

This is my package.json:
{
"name": "4techman-mobile-ionic",
"version": "1.10.0",
"scripts": {
"ng": "ng",
"start": "ng serve",
"build": "ng build",
"cap-config": "cap-config",
"test": "ng test",
"lint": "ng lint",
"e2e": "ng e2e",
"reset-project-ios": "rm -rf ios && rm -rf node_modules && npm i && ionic cap add ios && npx trapeze run config.yaml -y --ios-project ios/App",
"reset-project-android": "rm -rf android && rm -rf node_modules && npm i && ionic cap add android && npx trapeze run config.yaml -y --android-project android"
},
"private": true,
"dependencies": {
"@angular/common": "^17.3.12",
"@angular/core": "^17.3.12",
"@angular/forms": "^17.3.12",
"@angular/platform-browser": "^17.3.12",
"@angular/platform-browser-dynamic": "^17.3.12",
"@angular/router": "^17.3.12",
"@awesome-cordova-plugins/core": "^8.1.0",
"@awesome-cordova-plugins/in-app-browser": "^8.1.0",
"@awesome-cordova-plugins/preview-any-file": "^8.1.0",
"@awesome-cordova-plugins/sqlite": "^8.1.0",
"@awesome-cordova-plugins/sqlite-porter": "^8.1.0",
"@capacitor/android": "7.4.3",
"@capacitor/app": "^7.0.0",
"@capacitor/app-launcher": "^7.0.0",
"@capacitor/camera": "^7.0.0",
"@capacitor/core": "^7.0.0",
"@capacitor/filesystem": "^7.0.0",
"@capacitor/geolocation": "^7.0.0",
"@capacitor/haptics": "^7.0.0",
"@capacitor/ios": "^7.0.0",
"@capacitor/keyboard": "^7.0.0",
"@capacitor/preferences": "^7.0.2",
"@capacitor/push-notifications": "^7.0.0",
"@capacitor/splash-screen": "^7.0.0",
"@capacitor/status-bar": "^7.0.0",
"@ionic/angular": "^7.8.6",
"@ngx-maintenance/ng2-search-filter": "^1.2.0",
"@ngx-translate/core": "^14.0.0",
"@ngx-translate/http-loader": "^7.0.0",
"@trapezedev/configure": "^7.1.3",
"cordova-plugin-inappbrowser": "^5.0.0",
"cordova-plugin-preview-any-file": "^0.2.9",
"cordova-sqlite-storage": "^7.0.0",
"date-fns": "^2.30.0",
"rxjs": "^7.5.0",
"signature_pad": "^4.2.0",
"swiper": "^11.2.6",
"tslib": "^2.8.1",
"uk.co.workingedge.cordova.plugin.sqliteporter": "^1.1.2",
"uuid": "^9.0.1",
"zone.js": "~0.14.10"
},
"devDependencies": {
"@angular-devkit/build-angular": "^17.3.12",
"@angular-eslint/builder": "^14.4.0",
"@angular-eslint/eslint-plugin": "^14.4.0",
"@angular-eslint/eslint-plugin-template": "^14.4.0",
"@angular-eslint/template-parser": "^14.4.0",
"@angular/cli": "~17.3.12",
"@angular/compiler": "~17.3.12",
"@angular/compiler-cli": "~17.3.12",
"@angular/language-service": "~17.3.12",
"@capacitor/assets": "^2.0.4",
"@capacitor/cli": "^7.0.0",
"@ionic/angular-toolkit": "^8.1.0",
"@types/jasmine": "~4.3.6",
"@types/jasminewd2": "^2.0.13",
"@types/node": "^17.0.45",
"@types/uuid": "9.0.8",
"@typescript-eslint/eslint-plugin": "^6.6.0",
"@typescript-eslint/parser": "^6.6.0",
"eslint": "^7.32.0",
"eslint-plugin-import": "2.22.1",
"eslint-plugin-jsdoc": "30.7.6",
"eslint-plugin-prefer-arrow": "1.2.2",
"jasmine-core": "~4.6.0",
"jasmine-spec-reporter": "~5.0.0",
"karma": "^6.3.9",
"karma-chrome-launcher": "~3.1.0",
"karma-coverage": "~2.0.3",
"karma-coverage-istanbul-reporter": "~3.0.2",
"karma-jasmine": "~5.1.0",
"karma-jasmine-html-reporter": "^2.0.0",
"protractor": "~7.0.0",
"ts-node": "~8.3.0",
"typescript": "~5.4.5"
}
}

NOTE: in a newer project with angular 20 and standalone components the same exact libraries for the cordova-sqlite storage and awesome plugin wrapper works as expected.