database_postgres library
Native PostgreSQL support for Odroe database contracts.
Classes
- BoundSql
- Immutable SQL fragments interleaved with typed bound values.
- Connection
- ConnectionSettings
- DatabaseModule
- Installs one SQL database with explicit resource ownership.
-
Pool<
L> -
A connection pool that may select endpoints based on the requested locality
Lof the data. - PoolSettings
- PostgresDatabase
- A PostgreSQL database backed by one connection or a lazy connection pool.
- SqlAllRows
- Explicit confirmation token for a full-table mutation.
- SqlAssignment
- One heterogeneous, type-checked INSERT or constant UPDATE assignment.
-
SqlCodec<
T> - Converts one Dart type to and from SqlValue.
-
SqlColumn<
T> - A named SQL column with one Dart value codec.
- SqlDatabase
- Minimal typed SQL transport implemented by database drivers.
- SqlExecutor
- Executes typed SQL without owning the underlying database resource.
- SqlJoin
- One relational table join in a typed SELECT.
- SqlOrder
- One typed column ordering clause.
- SqlPredicate
- One composable, bound SQL predicate.
-
SqlProjection<
R> - Ordered selected columns and a selection-addressed decoder.
- SqlProjectionRow
- One result row addressed by the selections declared in its projection.
- SqlQueries
- Dialect-explicit compiler for typed SQL operations.
-
SqlRead<
R> - A compiled row-returning operation.
- SqlRow
- One immutable, ordered SQL result row.
-
SqlSelection<
T> - One typed column selected from a SQL result.
-
SqlTable<
Row> - A manually declared SQL table with one default row projection.
-
SqlTableColumn<
T> - A table-owned SQL column with one statically fixed Dart value type.
- SqlUpdateAssignment
- One type-checked assignment accepted by a SQL UPDATE.
- SqlWrite
- A compiled non-row-returning INSERT, UPDATE, or DELETE.
- SqlWriteResult
- Portable metadata returned by one SQL write.
- TransactionalSqlDatabase
- Optional capability for databases with interactive transactions.
Enums
- SqlDialect
- SQL compilation rules for one database family.
- SqlErrorCode
- Stable categories for database failures.
- SqlStatementKind
- Declares the protocol shape of a transaction-safe SQL statement.
Extension Types
- SqlValue
- A typed value accepted by SQL statements and row codecs.
Extensions
-
SqlNumericColumnUpdates
on SqlTableColumn<
T> - Atomic numeric updates for a non-nullable SQL column.
-
SqlSelectionModifiers
on SqlSelection<
T> - Result-only modifiers for a selected SQL column.
Constants
- allRows → const SqlAllRows
- Confirms an intentional full-table UPDATE or DELETE.
-
sqlBlob
→ const SqlCodec<
Uint8List> - Codec for SQL binary values.
-
sqlBool
→ const SqlCodec<
bool> - Codec for logical SQL booleans.
-
sqlDouble
→ const SqlCodec<
double> - Codec for finite SQL floating-point values.
-
sqlInt
→ const SqlCodec<
int> - Codec for SQL integer values.
-
sqlText
→ const SqlCodec<
String> - Codec for SQL text values.
-
sqlUtcDateTime
→ const SqlCodec<
DateTime> - Codec for SQL timestamps normalized to UTC.
Properties
-
databaseKey
→ ContextKey<
SqlDatabase> -
The application context key used to read the configured SqlDatabase.
final
Exceptions / Errors
- SqlException
- A database failure with a driver-independent code.