SQLiteQueryBuilder

General

Category
Free
Tag
Database
License
MIT License
Registered
Feb 26, 2016
Favorites
7
Link
https://github.com/alexfu/SQLiteQueryBuilder
See also
PufferDB
Thneed
Poetry
DbExporterHelper
Android SQLiteAssetHelper

Additional

Language
Java
Version
0.3.0 (Jun 16, 2016)
Created
Dec 26, 2014
Updated
Oct 14, 2016 (Retired)
Owner
Alex Fu (alexfu)
Contributors
The Gitter Badger (gitter-badger)
Gonçalo Ferreira (monxalo)
Alex Fu (alexfu)
Steven Wu (shadeven)
4
Activity
Badge
Generate
Download
Source code

SQLiteQueryBuilder

This project is aimed at providing a simple API to build SQLite query statements. This library does nothing but build statements; it's not an ORM. The API syntax is inspired from the jOOQ library.

Currently, SQLiteQueryBuilder is under active development so you may find some features missing. If this is the case, please file an issue or open a pull request.

Motivation

Although this project is written in Java and bears no dependencies to external frameworks (so far), it is/was developed specifically to be used on the Android platform. There are a few reasons why I started this project...

  • Building SQLite statements in pure Java can be cumbersome and very unreadable at times
  • Androids own SQLiteQueryBuilder is also cumbersome to use at times.
  • Although the jOOQ library has a great API for building SQL statements, it comes with an entire suite of tools to build statements, connect to databases, write/read models to/from databases, etc. Due to the current nature of Dalvik (Androids application VM), there is a 64k method reference limit. jOOQ can contain over 10,000 referenced methods when in use. This may not seem like much in comparison to the limit, but if you consider other large libraries commonly used (such as Guava and Google Play Services), hitting that 64k limit becomes much easier.

Usage

String sql = SQLiteQueryBuilder
 .select("*")
 .from("accounts")
 .where("id = 1")
 .toString();

You can view more examples in the src/test/java folder.

To use this library, add the follow to your gradle build:

repositories {
    maven {
        url "https://jitpack.io"
    }
}

dependencies {
    compile 'com.github.alexfu:SQLiteQueryBuilder:0.1.1'
}