Provides Android NDK build of SQLite with an optimized JSON-based data interface and a workaround for large SELECT results, with a low-level API for Cordova SQLite evplus plugin versions.
Based on:
by Christopher J. Brody aka Chris Brody mailto: [email protected]
License: GPL v3 (https://www.gnu.org/licenses/gpl-3.0.txt) or commercial license options
android-sqlite-evplus-ndk-driver-free provides build of a JAR with the following:
- single
EVNDKDriver
class with native Java interface to the needed C functions - automatic build for current Android NDK targets (
armeabi-v7a
,x86
,x86_64
,arm64-v8a
) that is accessible from the native Java interface, with the following user defined functions:REGEXP
integrated from brodybits / sqlite3-regexp-cached (based on http://git.altlinux.org/people/at/packages/?p=sqlite3-pcre.git by Alexey Tourbin, public domain)BASE64
andBLOBFROMBASE64
integrated from brodybits / sqlite3-base64, using brodybits / libb64-core (based on http://libb64.sourceforge.net/ by Chris Venter, public domain)
This is accomplished by using GlueGen around the C module.
Minimum API level: android-22 (Android 5.1)
NOTE: This project references multiple subprojects, which may be resolved by: $ make init
(as described below).
WARNING: The reference handles that are returned by the EVNDKDriver
library functions are raw C pointer values. If someone uses a reference handle that is not valid, or no longer valid with the EVNDKDriver
library the behavior is undefined (may crash, for example). It is NOT recommended to use this API directly unless you really understand how this library works internally.
__3.40.0__
See the following reference for installing older android-ndk
cask using Homebrew: https://www.jverdeyen.be/mac/downgrade-brew-cask-application/
To install android-ndk
version r16b
, for example:
brew cask install https://raw.githubusercontent.com/Homebrew/homebrew-cask/4570652dc6a3a8f7fd2be1053dd43547a2c78e26/Casks/android-ndk.rb
Note that homebrew-cask
seems to have restored maintenance of the android-ndk
cask, as discussed in Homebrew/homebrew-cask#58883
.
See also for some historical android-ndk
cask information:
- https://github.com/Homebrew/homebrew-cask/commits/master/Casks/android-ndk.rb
- https://github.com/Homebrew/homebrew-cask/commits/5e9f77552aef2ffa29efe8a9b916d89686b96c7f/Casks/android-ndk.rb
- https://github.com/Homebrew/homebrew-cask/blob/5e9f77552aef2ffa29efe8a9b916d89686b96c7f/Casks/android-ndk.rb
FUTURE TODO: better documentation of API and some internal details
-DSQLITE_THREADSAFE=1
-DSQLITE_DEFAULT_SYNCHRONOUS=3
-DSQLITE_DEFAULT_MEMSTATUS=0
-DSQLITE_OMIT_DECLTYPE
-DSQLITE_OMIT_DEPRECATED
-DSQLITE_OMIT_PROGRESS_CALLBACK
-DSQLITE_OMIT_SHARED_CACHE
-DSQLITE_TEMP_STORE=2
-DSQLITE_OMIT_LOAD_EXTENSION
-DSQLITE_ENABLE_FTS3
-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_FTS4
-DSQLITE_ENABLE_FTS5
-DSQLITE_ENABLE_RTREE
-DSQLITE_ENABLE_JSON1
New stable default page size and cache size (https://sqlite.org/pgszchng2016.html):
-DSQLITE_DEFAULT_PAGE_SIZE=4096
-DSQLITE_DEFAULT_CACHE_SIZE=-2000
- SQLite (https://sqlite.org/) - public domain
- brodybits / sqlite3-regexp-cached - based on http://git.altlinux.org/people/at/packages/?p=sqlite3-pcre.git by Alexey Tourbin, public domain
- brodybits / sqlite3-base64 - Unlicense (public domain) ref: http://unlicense.org/
- brodybits / libb64-core - based on http://libb64.sourceforge.net/ by Chris Venter, public domain
- Support direct query of BLOB type
FUTURE TBD/TODO:
- Automatic AAR build
- Document this project (again, perhaps in a blog post)
- Some more SQLite API functions will be needed to rebuild the native sqlcipher library to replace the native libraries in the @sqlcipher / android-database-sqlcipher (SQLCipher for Android) project.
Initialize with the subproject references:
$ make init
Then to build:
$ make
$ make regen