Pong

August 3rd 2016 R-Tree Revisited on Android

← July 21st 2016 Time-Stamp Registration | ● | August 7th 2016 Track Summary →

Good news for SQLite users on Android:

Older versions of Android (e.g. 4.4) did not have the SQLite R-Tree option enabled. But later versions of Android starting with 5.0 have the R-Tree option enabled bye default.

This means that fast geo-spatial SQLite queries are now supported by the native Android SQLite installation.

The bad news, however, is that the sqlite tool contained in the platform-tool folder of the Android SDK r24.4.1 is not built with R-Tree support enabled. We need to compile the sqlite3 tool by ourselves as follows:

  • Get the SQLite autoconf source 
curl -O http://www.sqlite.org/2014/sqlite-autoconf-3080500.tar.gz
tar zxf sqlite-autoconf-3080500.tar.gz
cd sqlite-autoconf-3080500
  • Build and install a static SQLite library /w rtree support (enabled by default when using autoconf) 
./configure --prefix=/usr/local --disable-shared --enable-static
make
sudo make install


← July 21st 2016 Time-Stamp Registration | ● | August 7th 2016 Track Summary →

Options: