Awesome GitHub RepositoriesAndroid SQLite Management

Anko is an Android Kotlin library designed to simplify application development through a set of domain-specific languages and extensions. It functions as a programmatic UI DSL, an SQLite wrapper, an SDK utility, and an asynchronous framework. The project provides a declarative layout system that allows developers to build user interfaces through code instead of static XML markup. It distinguishes itself by offering a fluent database layer that eliminates manual cursor management and a concurrency system that uses weak references to prevent memory leaks in activities. The library covers broad

Stetho is a debug bridge that connects Android applications to Chrome Developer Tools. It allows for the real-time inspection of network traffic, internal application state, and the user interface layout directly within a desktop browser. The project provides specialized inspectors for analyzing Android-specific components. This includes a network inspector for capturing HTTP requests and responses, an SQLite database browser for querying local storage, and a view hierarchy inspector for mapping UI elements and styles. Additional capabilities cover runtime execution via an embedded JavaScrip

greenDAO is an object-relational mapping library for Android that maps Java objects to SQLite databases. It provides infrastructure for high-performance data persistence by translating data objects into database records and vice versa. The library implements a type-safe query builder for retrieving records across multiple entities using joins and relationship chaining. It also includes a security layer that provides full-disk encryption for the SQLite database to prevent unauthorized access to stored information. The system utilizes compile-time code generation to create mapping classes, avo

Android-Debug-Database is a specialized utility for extracting, inspecting, and editing mobile data on Android devices. It serves as a database debugger and SQLite inspector that provides a web-based interface for managing database records and shared preference key-value stores. The project distinguishes itself by supporting encrypted database decryption via provided passwords and the ability to map and inspect volatile in-memory databases. It also includes a data export tool that transfers database files from the private application directory to a local machine for external analysis. The to

LitePal is an object-relational mapping library and SQLite database wrapper for Android applications. It replaces raw SQL queries with a fluent interface and object mapping to simplify local data persistence and database management. The project provides a specialized system for automatically synchronizing database schemas based on model definitions to handle version updates. It also includes a storage solution for securing sensitive data through configurable field-level encryption. The library covers broad data storage and synchronization capabilities, including atomic transaction support, m

DBFlow is an object-relational mapping library for Android that maps Java objects to SQLite databases. It serves as a persistence layer designed to reduce manual boilerplate code through automated database access and entity mapping. The project distinguishes itself with a type-safe query builder that uses a fluid interface to construct queries with compile-time checks. It provides transparent file-level encryption for securing sensitive data and a reactive wrapper that streams database changes to subscribers for real-time updates. Additional capabilities include asynchronous query execution

ActiveAndroid ist ein Persistenz-Framework zur Verwaltung lokaler SQLite-Datenbanken unter Android. Es bietet ein Active-Record-Object-Relational-Mapping-System, das Datenbanktabellen an Klassen bindet und so die Datenpersistenz und den Abruf ohne manuelles Schreiben von SQL ermöglicht. Das Projekt zeichnet sich durch ein dediziertes Schema-Migrationstool aus, das Datenbankstrukturen mithilfe versionierter Skripte aktualisiert, die aus den Anwendungs-Assets geladen werden. Es enthält zudem ein Framework für den Austausch von Datenbankinhalten zwischen verschiedenen Android-Anwendungen über eine standardisierte URI-basierte Content-Provider-Schnittstelle. Die Bibliothek deckt breite Funktionsbereiche ab, darunter Object-Relational-Mapping zur Verwaltung von Tabellenbeziehungen und benutzerdefinierten Datentypen, Bulk-Transaktionsverarbeitung für die Datenaufnahme sowie automatisierte Datenbankinitialisierung aus vorbefüllten Asset-Dateien. Sie bietet zudem Dienstprogramme für programmatische Abfragen und Spaltenindizierung zur Verwaltung von Datensuche und -abruf.

ActiveAndroid is an object-relational mapper and data persistence library for Android. It serves as a high-level wrapper for SQLite databases, translating database records into class instances to facilitate data manipulation. The library enables data persistence without the need to write manual SQL queries. It maps database rows to Java objects, allowing records to be saved, retrieved, and deleted using object-oriented methods. The toolkit covers local mobile data storage and database management, providing a layer that links database table structures to specific object properties.

Sqlbrite ist ein reaktiver SQLite-Datenbankmanager und ein leichtgewichtiger Wrapper für Android. Er fungiert als reaktive SQL-Bibliothek, die standardmäßige SQLite-Abfragen in beobachtbare Streams umwandelt, sodass die Anwendung automatisch neue Ergebnisse ausgibt, wenn sich zugrunde liegende Datenbanktabellen ändern. Das Projekt bietet einen Mechanismus zur Verfolgung von Änderungen an spezifischen Datenbanktabellen, wodurch Abfrage-Aktualisierungen ohne manuelles Polling ausgelöst werden. Es enthält zudem einen atomaren Transaktionsmanager, um mehrere SQL-Modifikationen in Einheiten zu gruppieren, was die Datenintegrität sicherstellt und redundante Benachrichtigungen verhindert. Die Bibliothek verwaltet die lokale Datenpersistenz unter Android, indem sie Schema-Operationen und das Datenbank-Lifecycle-Management an den Standard-SQLite-Helper delegiert. Die Kernfunktionen umfassen die Echtzeit-Datenbeobachtung und die Verwaltung von Datenbanktransaktionen.