Add Spatialite Support?

[canadaka]

We are a big user of the sqlite plugin with the Trailforks app. We do a lot of spatial queries and are very limited to what we can do with normal SQL.

Any possibility of adding Spatialite support to this plugin? I found that someone forked the plugin and added support. But it's not been updated in 2 years.
https://github.com/DisyInformationssysteme/Cordova-spatialite-storage
http://blog.disy.net/spatialite-phonegap-on-mobile/

[brodycj]

updated:

My apologies for the delay.

I would be open to supporting this kind of feature on an evplus plugin version.

In case of interest it would be best to discuss by private email: chris.brody+brodybits@gmail.com

Happy Holidays!

[brodycj]

I would be happy to deliver a new evplus plugin version with SpatiaLite integrated upon purchase. Please contact chris.brody+brodybits@gmail.com for more information.

Some DIY tips:

For iOS: follow http://blog.disy.net/spatialite-phonegap-on-mobile/

Alternatives for Android:

• integrate with https://github.com/mrenouf/android-spatialite as described in http://blog.disy.net/spatialite-phonegap-on-mobile/
• use cordova-sqlite-storage or cordova-sqlite-ext with sqlite-native-driver.jar rebuilt from https://github.com/liteglue/Android-sqlite-native-driver or https://github.com/brodybits/Android-sqlite-ext-native-driver with SpatiaLite included
• use cordova-sqlite-evcore-extbuild-free with evcore-native-driver.jar rebuilt from
  litehelpers/Android-sqlite-evcore-native-driver-free (ext-master branch) with SpatiaLite included

[brodycj]

Unfortunately I cannot recommend the fork at https://github.com/DisyInformationssysteme/Cordova-spatialite-storage since it is missing fixes for possible data loss risk issues ref: DisyInformationssysteme/Cordova-spatialite-storage#7

If DisyInformationssysteme/Cordova-spatialite-storage#7 is resolved properly then I would be happy to recommend that fork.

In case anyone else publishes a fork with SpatiaLite included I would be happy to review it for possible recommendation.

[brodycj]

I received the following link by email for Spatialite on Android, which should be usable from cordova-sqlite-storage / cordova-sqlite-ext: https://github.com/sevar83/android-spatialite

I found the following links for iOS:

• https://github.com/gstf/libspatialite-ios
• https://gist.github.com/aaronpk/0252426d5161bc9650d8
• https://stackoverflow.com/questions/4793970/how-to-compile-spatialite-for-ios