sqlite3 library

Dart bindings to sqlite3.

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.
CommonSqlite3
Provides access to sqlite3 functions, such as opening new databases.
Cursor
Base class for result sets.
Database
An opened sqlite3 database with dart:ffi.
IteratingCursor
A Cursor that can only be read once, obtaining rows from the database "on the fly" as moveNext is called.
PreparedStatement
A prepared statement.
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
SqlFlag
Flags for file open operations, https://www.sqlite.org/c3ref/c_open_autoproxy.html Flags For File Open Operations
SqlFunctionFlag
Function flags, https://www.sqlite.org/c3ref/c_deterministic.html
Sqlite3
Provides access to sqlite3 functions, such as opening new databases.
SqliteExtension
Information used to load an extension through sqlite3_auto_extension, exposed by Sqlite3.ensureExtensionLoaded.
SqliteUpdate
A data change notification from sqlite.
SqlPrepareFlag
SqlSpecialDestructor
Special destructors, https://www.sqlite.org/c3ref/c_static.html
SqlTextEncoding
Text Encodings, https://www.sqlite.org/c3ref/c_any.html These constant define integer codes that represent the various text encodings supported by SQLite.
SqlType
Datatypes, https://sqlite.org/c3ref/c_blob.html
Version
Version information about the sqlite3 library in use.
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.

Constants

SQLITE_DELETE → const int
SQLITE_INSERT → const int
SQLITE_UPDATE → const int

Properties

bigIntMaxValue64 BigInt
final
bigIntMinValue64 BigInt
final
sqlite3 Sqlite3
Provides access to sqlite3 functions, such as opening new databases.
no setter

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

SqliteException
Thrown by sqlite methods.