I have checked the Libraries: SQLite WASM so I can test the app in the browser but I use <plugin name="cordova-sqlite-evcore-extbuild-free" /> when I build the app for iOS and Android with VoltBuilder.
If there something I can put in the config to tell the build process NOT to include “SQLite WASM” when building for native Android / iOS with VoltBuilder?
The reason for this is in case I forget to uncheck SQLite WASM before building for iOS/Android with VoltBuilder.
@Warren_Sundet - thank you for sending me your app. I’m able to build and run it. There are no errors on the Remote Console. What problem should I be seeing?
AppStudio 9.0.2.4 has been released. When building with VoltBuilder, the Sqlite.js and Sqlite.WASM files are no longer included. Please use Cordova Plugins for SQLite on native apps.
I don’t get this I’m sorry. When I try a native SQLite app build from AppStudio I tried unchecking the WASM libraries checkbox and reverting to the Cordova plugin. Didn’t work on IOS. Keeping the WASM Library checked works fine. So I probably won’t change
Thank you for all the work you and your group do to facilitate app development for all of us. Your development environment is amazing!
My app has been on both app stores for over a year. I have developed a major enhancement that I would like to release soon. I want to make sure it has the latest code from every perspective, for both Apple and Android. My app has 2 SQLite databases and uses the cordova-sqlite-storage plugin.
It is not clear to me how the WASM issue affects me with APPStudio 9.x. As you would expect, I usually do most of the debugging using the browser and Voltbuilder to create the native app.
My questions are:
Do I need to include the WASM library as part of the Voltbuilder build or is its inclusion simply to allow me to do debugging in the browser?
Given that I can’t run my app in the browser in AppStudio 9.x, is it acceptable to do the debugging on a second computer with AppStudio 8.5.x and then use 9.x to do the Final Build?
An unrelated question: When an individual uses automated cloud backup on iOS, does a restore to a new phone restore each app from the backup or does it reinstall the app from the app store. I have a user who had Verizon upgrade his phone, using an existing cloud backup. When he tried to use my app on his new phone, a new install had been done and his data was gone. My app stores ALL the data on the phone in a SQLite database, it does not use a server.
I appreciate your clarification on these matters. I do not desire to release a major app upgrade and then in a short period of time find that I need to do another release.
The upcoming deprecation of SQLite in browsers will not affect apps built in VoltBuilder - cordova-sqlite-storage has everything that is needed to run SQLite. No need to include SQLite WASM.
The upcoming SQLite issue will affect all AppStudio users, not just those on AppStudio 9. We’ve added SQLite WASM support to AppStudio 9, so you’ll continue to be able to use SQLite if you’re on the current AppStudio. Using AppStudio 8.5 will not help you.
We’re working on further improvements for SQLite. The current workaround will continue to work until May 28th, 2024, when Chrome is scheduled to have another update affecting this.
When I looked at a few weeks ago, there were still some gaps in the browser tools and examples. We will be revisiting this in plenty of time - I expect it will get easier to solve.
I do not know exactly how iCloud handles restoring application files, though I’m surprised it didn’t restore them. It’s probably worth doing some testing. If a Verizon tech did the upgrade, it’s also possible it was done improperly.