jeffdcamp/SQLiteCustom-Android

Custom SQLite

Updating this Library

Download latest SQLite

• Download Latest sqlite3.c and sqlite3.h in the Amalgamation file (sqlite-amalgamation-xxxx.zip) http://www.sqlite.org/download.html
• Replace existing sqlite3.c and sqlite3.h files in ./sqlite-android/src/main/jni/sqlite
• Download Latest see.c https://www.sqlite.org/see/tree?ci=trunk (authentication may be needed)
  • Click on the see.c file
  • Click on the "Download" button (at the top of the screen)... file will show full screen in browser
  • Right-click and select "Save As" and change name from see.txt to see.c
• Merge see.c with sqlite3.c file:

  • Copy see.c to ./sqlite-android/src/main/jni/sqlite (where the sqlite3.c file is located)

  • Merge the sqlite3.c with the see.c file

    cat sqlite3.c see.c > see-sqlite3.c

  • delete sqlite3.c

  • rename see-sqlite3.c to sqlite3.c

  • delete see.c

• Update the Android SQLite Java source files
  • Create a temp directory
  • fossil clone http://www.sqlite.org/android android.fossil
  • mkdir sqlite
  • cd sqlite
  • fossil open ../android.fossil
  • Compare and merge all .java files and .mk files (Use Meld tool)
    • NOTE: the following are add-ons (should be left as-is or updated separately)
      • libstreamer (required by fts3_html_tokenizer)
      • tokenizers
      • android_database_SQLiteTokenizer.cpp
      • fts3_html_tokenizer.*
      • libstemmer.h
      • stopwords.*
    • Watch for areas of the code that are added for use with tokenizers and see (don't remove)
      • password
        • SQLiteConnection.open() if (mConfiguration.see != null) { String password = mConfiguration.see.getPassword();
        • ... others
      • tokenizer
        • SQLiteConnection.registerTokenizer(...) .loadExtension(...)
        • SQLiteConnection.nativeRegisterTokenizer(...) nativeLoadExtension(...)
        • SQLiteConnectionPool.registerTokenizer(...) .loadExtension(...)
        • ... others

Update Libstemmer

• Get the latest libstemmer files from https://snowballstem.org/download.html (https://snowballstem.org/dist/libstemmer_c.tgz)
• Extract files to temp directory
• Compare and merge all files currently using meld (DO NOT update [#include "../../libstemmer.h"] to #include "../include/libstemmer.h", leave as is)
• Add new language files to jni/sqlite/Android.mk

Build

• Run "Build" -> "Rebuild Project"

Test

• Run test app and verify that all tests pass

Deploy

• Update gradle.properties VERSION_NAME (example: VERSION_NAME=3.28.0)
• Deploy via regular LDS library release process (commit changes to release branch)

Add Dependency to project

implementation "org.lds.sqlite:lds-sqlite-android:3.28.0"

Deploying Pre-Built Library from sqlite.org

• Download latest "Precompiled Binaries for Android" aar https://www.sqlite.org/download.html
• Upload to LDS Maven Nexus

Example:

mvn deploy:deploy-file -DgroupId=org.lds.sqlite \
  -DartifactId=sqlite-android \
  -Dversion=3.28.0 \
  -Dpackaging=aar \
  -Dfile=sqlite-android-3280000.aar \
  -DrepositoryId=lds.mobile.repo \
  -Durl=https://code.lds.org/nexus/content/repositories/mobile-3rd-party/

Add Dependency to project

implementation "org.lds:sqlite-android:3.28.0"