Overview

Tasks

Aqueduct's ORM stores data in database tables and maps table rows to Dart objects.

You declare subclasses of ManagedObject<T> in your application code to define the database tables your application uses. The properties of these types have annotations like Column and Validate to customize the behavior of tables in your database.

Your application creates a ManagedContext service object during initialization that manages database access for your application. This service is injected into controllers that make database queries.

Instances of Query<T> are created to insert, update, read and delete data from a database. A Query<T> has many configurable options for filtering, joining, paging, sorting and performing aggregate functions on database rows.

The aqueduct db command-line tool manages databases that your application connects. This tool creates and executes migration scripts that update the schema of a database to match the requirements of your application.

The minimum version of PostgreSQL needed to work with Aqueduct is 9.6.

Guides

• Connecting to a Database
• Modeling Data
• Storage, Serialization and Deserialization
• Executing Queries
• Joins, Filtering and Paging
• Executing Queries in a Transaction
• Adding Validations and Callbacks to ManagedObject
• Aqueduct Database Tool
• JSON Document Columns and Operations