square/sqlbriteArchived
Sqlbrite
Sqlbrite 是一个响应式 SQLite 数据库管理器，也是 Android 的轻量级封装库。它作为一个响应式 SQL 库，将标准 SQLite 查询转换为可观察流，允许应用程序在底层数据库表发生变化时自动发出新结果。
该项目提供了一种跟踪特定数据库表更改的机制，触发查询刷新而无需手动轮询。它还包含一个原子事务管理器，将多个 SQL 修改分组为单个单元，确保数据完整性并防止冗余通知。
该库通过将模式操作和数据库生命周期管理委托给标准 SQLite 助手来处理 Android 上的本地数据持久化。其核心能力涵盖实时数据观察和数据库事务管理。
Features
- Reactive SQLite Libraries - Integrates SQLite into Android applications with reactive streams that automatically update the UI on data changes.
- Android Device Storage - Provides local data persistence on Android devices using SQLite with a reactive information flow.
- Cursor-Based Change Streaming - Transforms traditional SQLite result cursors into real-time data streams that automatically update the UI.
- SQL Table Observers - Tracks changes to specific database tables to trigger automatic query refreshes without manual polling.
- Auto-Updating Query Results - Emits new query results automatically whenever the underlying tracked tables are inserted, updated, or deleted.
- Reactive SQL Query Execution - Executes SQL queries as reactive streams that emit new data upon table updates.
- SQLite Database Management - Manages database transactions and schema operations on Android via a lightweight SQLite wrapper.
- Android SQLite Management - Provides a lightweight wrapper around SQLiteOpenHelper for managing local persistence and schemas on Android.
- Real-Time Data Synchronization - Synchronizes database state and views in real time by tracking changes in specific tables.
- Table Change Streams - Links SQL queries to the tables they reference to automate the refreshing of active data streams.
- Reactive Stream Bindings - Wraps standard SQLite cursors in observable streams to emit updated result sets to subscribers.
- Table Change Observers - Monitors specific database tables to trigger automatic query re-execution when underlying data changes.
- Atomic Transaction Execution - Groups SQL modifications into atomic transactions to ensure data integrity and prevent redundant event notifications.
- Atomic Transactions - Groups multiple SQL modifications into single atomic units to ensure consistency and minimize notifications.
- Database Transaction Management - Provides programmatic control over transaction boundaries to ensure data consistency and prevent redundant notifications.
- Transaction Batching - Implements a mechanism to group multiple database operations into a single atomic transaction to prevent redundant notification cycles.
- Persistence - Reactive wrapper around SQLiteOpenHelper.
- Reactive Libraries - Provides reactive wrappers for database query results.
