AndroidEasySQL-Library
Android SQLite library. Create a table and add, read, update and delete rows in a few chained calls, with no SQL or SQLiteOpenHelper to write
- Platform
- Libraries
- Category
- Developer Tools
- Available from
- GitHub
About this app
AndroidEasySQL-Library is a small SQLite library for Android apps that just need to save data. Writing a SQLiteOpenHelper and SQL queries by hand is slow and easy to get wrong. Here you describe your columns once, and then add, read, update and delete rows with short chained calls. It was revamped in 2026: rewritten in Kotlin, with a Material 3 look that follows light and dark mode, and it still works from Java.
I made it because I was really bad at SQL. Every time I worked with SQL, I ended up building something like this, which is why I made one for Android and one for Flutter. Android apps don't need complex SQL, so as long as I could do my things properly, I was happy with it.
- No SQL to write: describe the columns once and the table is built for you.
- An ID column for free: every table gets an auto-increment primary key.
- Chained calls: add or update a whole row in one line.
- Read rows as a simple list, or as a Cursor if you prefer, ordered by any column.
- Search, count and match values across columns.
- Store text, numbers, Long and Double values, or null.
- Tiny: no extra dependencies, Android 5.0 and newer.
The sample app in the repo is a small notes app built with it. Great for small Android apps that need a local database without the boilerplate.
Install
Add JitPack to your repositories, then the dependency:
// settings.gradle.kts
dependencyResolutionManagement {
repositories {
google()
mavenCentral()
maven("https://jitpack.io")
}
}
dependencies {
implementation("com.github.p32929:AndroidEasySQL-Library:2.0.0")
}
val db = EasyDB.init(context, "Notes")
.setTableName("Notes")
.addColumn("Title", "text", "not null")
.addColumn("Body", "text")
.doneTableColumn()
db.addData("Title", "Groceries").addData("Body", "Milk and eggs").doneDataAdding()
val notes = db.getAllRows()
Upgrading from 1.x? Most code works as is. See "Migrating from 1.x" on the GitHub page.
Want a database set up for your Android app without the SQL headache? Contact me through my portfolio: https://p32929.github.io