sqlite_async library
High-performance asynchronous interface for SQLite on Dart & Flutter.
See SqliteDatabase as a starting point.
Classes
-
AbstractDefaultSqliteOpenFactory<
Database extends CommonDatabase> - The default database factory.
- ChildPortClient
- DefaultSqliteOpenFactory
-
IsolateConnectionFactory<
Database extends CommonDatabase> - A connection factory that can be passed to different isolates.
-
IsolateConnectionFactoryImpl<
Database extends CommonDatabase> - A connection factory that can be passed to different isolates.
- Mutex
- ParentPortClient
- PlaceholderQueryFragment
- A query fragment that can be embedded in another query.
- PortClient
- PortServer
- RequestPortServer
- SerializedPortClient
- SqliteConnection
- Abstract class representing a connection to the SQLite database.
- SqliteDatabase
- A SQLite database instance.
- SqliteDatabaseImpl
- SqliteDownMigration
- Set of down migration statements, persisted in the database.
- SqliteMigration
- A migration for a single database version.
- SqliteMigrations
- Migrations to initialize and update a database.
-
SqliteOpenFactory<
Database extends CommonDatabase> - Factory to create new SQLite database connections.
- SqliteOpenOptions
- SqliteOptions
- SqliteReadContext
- Abstract class representing calls available in a read-only or read-write context.
- SqliteWriteContext
- Abstract class representing calls available in a read-write context.
- SyncReadContext
- SyncSqliteConnection
- A simple "synchronous" connection which provides the async SqliteConnection implementation using a synchronous SQLite connection
- SyncWriteContext
- UpdateNotification
- Notification of an update to one or more tables, for the purpose of realtime change notifications.
- WebSqliteOptions
Enums
- SqliteJournalMode
- SQLite journal mode. Set on the primary connection. This library is written with WAL mode in mind - other modes may cause unexpected locking behavior.
- SqliteSynchronous
- SQLite file commit mode.
Mixins
-
IsolateOpenFactoryMixin<
Database extends CommonDatabase> - SqliteDatabaseMixin
- SqliteQueries
- Mixin to provide default query functionality.
Functions
-
quoteIdentifier(
String s) → String -
quoteJsonIndex(
int index) → String -
quoteJsonPath(
String path) → String -
quoteString(
String s) → String -
selectJsonColumnMap(
Map< Object, String> ? columnMap) → PlaceholderQueryFragment - Similar to selectJsonColumns, but allows specifying different output columns. This is useful for using on a List of Lists, instead of a List of Objects.
-
selectJsonColumns(
List< String> columns) → PlaceholderQueryFragment - Given a list of columns, return an expression extracting the columns from a list of JSON-encoded objects.
Typedefs
-
SqliteMigrationFunction
= FutureOr<
void> Function(SqliteWriteContext tx)