# requery/sqlite-android

Android SQLite support library

Repository: https://github.com/requery/sqlite-android
Canonical: https://ross.abutalabs.com/products/sqlite-android
Language: Java
License: Apache-2.0
License Family: permissive
Topics: android, sqlite, android-database-api, sqlite-android
Last push: 2025-10-14T15:15:21+00:00

## Health v2 (maintenance only)
Score: 44/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 47, release rhythm 8, longevity 100
- inputs: {"age_days": 3804, "days_push": 323, "days_rel": 461, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1136, forks 155 (observed 2026-08-28T04:03:43.644685+00:00)

## What it is
An Android-specific distribution of recent SQLite versions packaged as an AAR library, providing up-to-date SQLite builds with Android database APIs derived from AOSP. It lets apps use a consistent, modern SQLite version across all OS versions and devices, including features like FTS5, JSON1, and generated columns.

## Use cases
- use latest sqlite features on android
- get consistent sqlite version across android devices
- enable fts5 full-text search in android app
- use json1 extension in android sqlite
- replace android.database.sqlite with newer sqlite
- use SupportSQLiteOpenHelper with modern sqlite

## When to choose
- your app needs newer SQLite features than the OS provides (FTS5, JSON1, generated columns, DROP COLUMN)
- you want consistent SQLite behavior and bug fixes across Android versions
- you need better SQLite performance than the bundled OS version

## When to avoid
- your app only needs basic SQLite features available in the platform version
- you rely on cross-process cursors without wrapping them
- you want a zero-dependency solution without adding a JitPack repository

## Facets
- artifact type: library
- maturity: active
- function: database, database-driver
- domain: databases, mobile-development, android-tools
- platform: jvm
- tags: sqlite, android-database-api, aar, jitpack, fts5, json1, android, mobile

## Member repositories
- requery/sqlite-android (main) score 44

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:43.644685+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:36:31.862918+00:00, confidence not recorded.
  - readme: https://github.com/requery/sqlite-android (fetched 2026-08-28T04:03:43.644685+00:00, sha c273b8024988)
- Data as of 2026-08-30T08:39:29.467469+00:00.