Home

Welcome to the libjsqlite-spatialite-android wiki!

Project to create the libjsqlite.so used in geopaparazzi

• 'Configuration used presently '
  • 'Spatialite only'
  • 'Spatialite with Rasterlite2'
• android-ndk-r9c was used to compile this project properly
  • LOCAL_LDLIBS is always ignored for static libraries
• for proper SpatialIndex support, the rtree module must be activated in the sqlite.mk files
  • -DSQLITE_ENABLE_RTREE=1 in the common_sqlite_flags
• in the archive directory there is a archive with the compiled library’s of the latest version:
  • [[20150607.libjsqlite.4.3.0.tar.bz2 - 10.4 MB |https://raw.github.com/geopaparazzi/libjsqlite-spatialite-android/master/archive/20150607.libjsqlite.4.3.0.tar.bz2 ]]
  • [[20150607.libjsqlite.R4.3.0.tar.bz2 - 16.1 MB with RasterLite2 support|https://raw.github.com/geopaparazzi/libjsqlite-spatialite-android/master/archive/20150607.libjsqlite.R4.3.0.tar.bz2 ]]

wget https://raw.github.com/geopaparazzi/libjsqlite-spatialite-android/master/archive/20150607.libjsqlite.4.3.0.tar.bz2

wget https://raw.github.com/geopaparazzi/libjsqlite-spatialite-android/master/archive/20150607.libjsqlite.R4.3.0.tar.bz2

• this version will be used in the next release of geopaparazzi [2015-06-07]:

DaoSpatialite.JavaSqliteDescription
[
 sqlite[3.8.10.2],
 spatialite[4.3.0],
 proj4[Rel. 4.9.1],
 geos[3.4.2-CAPI-1.8.2 r3921],
 spatialite_properties
 [
  HasIconv[1],HasMathSql[1],HasGeoCallbacks[0],HasProj[1],
  HasGeos[1],HasGeosAdvanced[1],HasGeosTrunk[0],HasLwGeom[0],HasLibXML2[1],
  HasEpsg[1],HasFreeXL[0],HasGeoPackage[1],
  target_cpu[armeabi-v7a]
 ],
 rasterlite2_properties[none]
]
recovery_mode[STRICT]

--

• setting compiler specific flags
  • TARGET_ARCH will have the present compiler that is running
    • -mfpu=neon for libwebp-0.4.0.mk
      • must be used for armeabi armeabi-v7a
      • but not used for x86

webp_flags := \
 -DHAVE_CONFIG_H=1 

ifeq ($(TARGET_ARCH),x86)
 LOCAL_CFLAGS   := $(webp_flags)
else 
 ifeq ($(TARGET_ARCH),mips)
  LOCAL_CFLAGS   := $(webp_flags)
 else
  LOCAL_CFLAGS   := -mfpu=neon $(webp_flags)
 endif
endif

---

* `Themes`: * 'Directory structure' * 'Configuration used presently [2015-06-07 - spatialite 4.3.0]' * './configure` commands' * 'Compiling and expected results' * 'Adding new project sources' * 'Known portions of the project that do not work' * 'when the use of `ndk-build clean` fails'

---

* `Projects`:

---

* 'Android_4.3.0.mk - for Spatialite 4.3.0, without Rasterlite2'

---

* 'Android_R4.3.0.mk - for Spatialite 4.3.0, with Rasterlite2'

---

Older Projects that should no longer be used:

---

* 'Android_4.2.1.mk - for Spatialite 4.2.1, without Rasterlite2'

---

* 'Android_R4.2.1.mk - for Spatialite 4.2.1, with Rasterlite2'

---

* 'Android_4.2.0.mk - for Spatialite 4.2.0, without Rasterlite2'

---

* 'Android_R4.2.0.mk - for Spatialite 4.2.0, with Rasterlite2'

---

* 'Android_4.1.1.mk - for Spatialite 4.1.1'

---

• any *.mk files not found above in the project
  • should be considered, for the moment at least, unusable

---

2015-06-08: Mark Johnson, Berlin Germany

---