search

storesafe / cordova-sqlite-storage-help

Help forum for Cordova sqlite plugin projects
2 stars 1 forks source link

Add Spatialite Support? #32

Open canadaka opened 7 years ago

canadaka commented 7 years ago

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 commented 6 years ago

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 commented 6 years ago

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:

brodycj commented 6 years ago

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: https://github.com/DisyInformationssysteme/Cordova-spatialite-storage/issues/7

If https://github.com/DisyInformationssysteme/Cordova-spatialite-storage/issues/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 commented 4 years ago

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: