sqlite3.wasm library Null safety

Experimental access to sqlite3 on the web.

Using this library requires additional setup, see the readme of the sqlite3 package for details.

Also, please note that this library is not production-ready at the moment and should be used with caution. In particular, the implementation of the virtual file system used to store persistent databases may change in a way that requires migration work in the future.

As long as this library is marked as experimental, it is not subject to semantic versioning.

Classes

AggregateContext<V>
Application-defined context used to compute results in aggregate functions.
AggregateFunction<V>
Interface for application-defined aggregate functions.
AllowedArgumentCount
Describes how many arguments an application-defined sql function can take.
CommonDatabase
An opened sqlite3 database.
CommonPreparedStatement
A prepared statement.
Cursor
Base class for result sets that are either an in-memory (ResultSet) or a lazy iterator (IteratingCursor).
FileSystem
A virtual file system implementation for web-based sqlite3 databases.
IndexedDbFileSystem
A file system storing files divided into blocks in an IndexedDB database.
IteratingCursor
A Cursor that can only be read once, obtaining rows from the database as necessary.
ResultSet
Stores the full result of a select statement.
Row
A single row in the result of a select statement.
SqlError
Common result codes, https://www.sqlite.org/rescode.html Result Codes
SqlExtendedError
Extended Result Codes, https://www.sqlite.org/rescode.html
SqliteEnvironment
An environment under which sqlite is running on the web.
SqliteUpdate
A data change notification from sqlite.
Version
Version information about the sqlite3 library in use.
WasmSqlite3
A WebAssembly version of the CommmonSqlite3 interface.
WindowFunction<V>
A window function for sqlite3.

Enums

OpenMode
Controls how databases should be opened by sqlite
SqliteUpdateKind
The kind of an SqliteUpdate received through a CommonDatabase.updates stream.

Typedefs

CollatingFunction = int Function(String? textA, String? textB)
A collating function provided to a sql collation.
ScalarFunction = Object? Function(List<Object?> arguments)
A scalar function exposed to sql.

Exceptions / Errors

FileSystemException
An exception thrown by a FileSystem implementation.
SqliteException
Thrown by sqlite methods.