SQLite build scripts for Android

This build scripts generate the following SQLite artifacts for Android:

• Statically Linked CLI

  • sqlite3-static

• Static Library

  • libsqlite3.a

• Dynamically Linked CLI

  • sqlite3-dynamic

• Dynamically Linked Shared Object Library

  • libsqlite3.so

Configure your environment

• Get Android NDK and configure your environment so the command ndk-build can be found in the PATH. This is a build dependency and is necessary to cross-compile and build Android Native Code Applications:

https://developer.android.com/ndk/downloads/index.html

Update SQLite version if needed

• No download is necessary, Makefile will take care of that for you. Use the download link only to choose any sqlite-amalgamation version number and year:

http://www.sqlite.org/download.html

• Update Makefile with desired SQLite version and corresponding year. This will be used to build the full download URL from SQLite site.

  vi Makefile

  ...
  SQLITE_VERSION ?= 3160100
  SQLITE_YEAR    ?= 2017
  ...

Build/Compile

• Make CLI and Library

  make clean
  make

  * Expected output

  [armeabi] Compile thumb  : sqlite3-static-cli <= shell.c
  [armeabi] Compile thumb  : sqlite3-static-cli <= sqlite3.c
  [armeabi] Compile thumb  : sqlite3-a <= sqlite3.c
  [armeabi] StaticLibrary  : libsqlite3.a
  [armeabi] Executable     : sqlite3-static
  [armeabi] Install        : sqlite3-static => libs/armeabi/sqlite3-static

  [armeabi] Compile thumb  : sqlite3-dynamic-cli <= shell.c
  [armeabi] Compile thumb  : sqlite3-dynamic-cli <= sqlite3.c
  [armeabi] Compile thumb  : sqlite3-so <= sqlite3.c
  [armeabi] SharedLibrary  : libsqlite3.so
  [armeabi] Executable     : sqlite3-dynamic
  [armeabi] Install        : sqlite3-dynamic => libs/armeabi/sqlite3-dynamic
  [armeabi] Install        : libsqlite3.so => libs/armeabi/libsqlite3.so

Artifacts

• CLI

  libs/armeabi/sqlite3-static
  libs/armeabi/sqlite3-dynamic

• Library

  obj/local/armeabi/libsqlite3.a
  libs/armeabi/libsqlite3.so

• You may now push SQLite to your Android device

  adb push libs/armeabi/sqlite3-static /sdcard/sqlite3
  adb shell
  mv /sdcard/sqlite3 /data/local/
  chmod 755 /data/local/sqlite3
  /data/local/sqlite3 -help

Note that paths and permissions may vary in your Android device or environment.

Happy hacking!