DROP COLUMN

[tiagocaus]

It does not work.

db.transaction(function (tx) {
        tx.executeSql("ALTER TABLE checklist DROP COLUMN assinatura_chegada");
});

[MikeDimmickMnetics]

ALTER TABLE DROP COLUMN syntax is new in SQLite 3.35.0. Version 6.0.0 of this Cordova plugin ships with SQLite 3.32.3, so you'll get a syntax error when trying to use this feature.

There is a chain of dependencies:

• This plugin depends on https://www.npmjs.com/package/cordova-sqlite-storage-dependencies, which contains the SQLite source used for iOS builds.
• For Android builds, it uses JAR files built from https://github.com/brodybits/android-sqlite-ndk-native-driver
• android-sqlite-ndk-native-driver in turn references https://github.com/liteglue/sqlite-amalgamation which contains the SQLite source.

To update the SQLite version used by this plugin, therefore, involves:

• Updating the source in https://github.com/liteglue/sqlite-amalgamation, by downloading from SQLite.org
• Updating the submodule reference in https://github.com/brodybits/android-sqlite-ndk-native-driver
• Building the android-sqlite-ndk-native-driver project, and copying the JAR files to https://github.com/brodybits/cordova-sqlite-storage-dependencies
• Releasing that on NPM, or otherwise changing the reference to it in this project
• Changing the referenced version of cordova-sqlite-storage-dependencies here, and updating the SQLite source for iOS.

I don't know what criteria @brodybits uses to update the bundled version of SQLite.