Home

Introduction

SqliteMagic is a SQLite database layer for Android that greatly reduces the amount of code needed to do database operations. It uses compile time annotation processing to generate the most efficient code tailored just for your app and unlike other similar libraries it uses no reflection whatsoever. Generated code looks like handwritten which makes debugging very convenient.

Key Features

• Fluent and intuitive API that follows clean code guidelines
• Has its own DSL (or Domain Specific Language) that emulates SQL in Java (inspired by JOOQ).
• Minimal setup needed
• Covers all database operation needs (for unsupported operations library also has raw query support)
• Full complex column support - save complex data structures in one operation and query whole data structure in one query (SqliteMagic is able to parse all related objects from single result which enables huge performance gains)
• Support for SQLite views
• Persist any third party object with fully customizable object transformers
• Support for migrations
• Unlike other similar libraries, it uses no reflection
• Built in RxJava support with reactive stream semantics on queries and operations
• Built in AutoValue immutable objects support
• Implements multiple Android specific performance improvements that makes it probably the fastest library for Android SQLite database operations.

Getting Started

• Setup
• Defining Database Schema
• Database Operations
• Querying Objects
• SQL Building
• RxJava Support
• Migrations

Support

For bugs, questions and discussions please use the Github Issues