Home

Awesome

Android SQLite support library

Build Status Download

This is an Android specific distribution of the latest versions of SQLite. It contains the latest SQLite version and the Android specific database APIs derived from AOSP packaged as an AAR library distributed on jitpack.

Why?

Even the latest version of Android is several versions behind the latest version of SQLite. These versions do not have bug fixes, performance improvements, or new features present in current versions of SQLite. This problem is worse the older the version of the OS the device has. Using this library, you can keep up to date with the latest versions of SQLite and provide a consistent version across OS versions and devices.

Use new SQLite features:

Usage

Follow the guidelines from jitpack.io to add the JitPack repository to your build file if you have not.

Typically, this means an edit to your build.gradle file to add a new repository definition in the allprojects block, like this:

	allprojects {
		repositories {
			...
			maven { url 'https://jitpack.io' }
		}
	}

Then add the sqlite-android artifact from this repository as a dependency:

dependencies {
    implementation 'com.github.requery:sqlite-android:3.45.0'
}

Then change usages of android.database.sqlite.SQLiteDatabase to io.requery.android.database.sqlite.SQLiteDatabase, similarly extend io.requery.android.database.sqlite.SQLiteOpenHelper instead of android.database.sqlite.SQLiteOpenHelper. Note similar changes maybe required for classes that depended on android.database.sqlite.SQLiteDatabase equivalent APIs are provided in the io.requery.android.database.sqlite package.

If you expose Cursor instances across processes you should wrap the returned cursors in a CrossProcessCursorWrapper for performance reasons the cursors are not a cross process by default.

Support library compatibility

The library implements the SupportSQLite interfaces provided by the support library. Use RequerySQLiteOpenHelperFactory to obtain an implementation of (Support)SQLiteOpenHelper based on a SupportSQLiteOpenHelper.Configuration and SupportSQLiteOpenHelper.Callback.

This also allows you to use sqlite-android with libraries like Room by passing an instance of RequerySQLiteOpenHelperFactory to them.

CPU Architectures

The native library is built for the following CPU architectures:

However, you may not want to include all binaries in your apk. You can exclude certain variants by using packagingOptions:

android {
    packagingOptions {
        exclude 'lib/armeabi-v7a/libsqlite3x.so'
        exclude 'lib/arm64-v8a/libsqlite3x.so'
        exclude 'lib/x86/libsqlite3x.so'
        exclude 'lib/x86_64/libsqlite3x.so'
    }
}

The size of the artifacts with only the armeabi-v7a binary is ~1.2 MB. In general, you can use armeabi-v7a on the majority of Android devices including Intel Atom which provides a native translation layer, however, performance under the translation layer is worse than using the x86 binary.

Note that starting August 1, 2019, your apps published on Google Play will need to support 64-bit architectures.

Requirements

The min SDK level is API level 19 (KitKat).

Versioning

The library is versioned after the version of SQLite it contains. For changes specific to just the wrapper API, a revision number is added e.g., 3.45.0-X, where X is the revision number.

Acknowledgements

This project is based on the AOSP code and the Android SQLite bindings No official distributions are made from the Android SQLite bindings it, and it has not been updated in a while, this project starts there and makes significant changes:

Changes

License

Copyright (C) 2017-2024 requery.io
Copyright (C) 2005-2012 The Android Open Source Project

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.