Database

Operations

This section covers practical operations you can perform with the AQL interface. These guides walk through schema management, table access, document CRUD, index usage, filtering, and foreign key lookups.

Schema and Instance Management

AQL organizes data through schemas and instances:

2. Schema Management - Define schemas, create and destroy instances

Table Access

Tables live inside schema instances:

3. Table Operations - Access tables and work with their contents

Document Operations

Documents are the fundamental unit of data in AQL:

4. CRUD Operations - Insert, read, update, replace, and delete documents

Index Operations

Indexes accelerate queries by enabling efficient lookups:

5. Index Management - Define secondary indexes in schema definitions

Query Operations

Transform and filter data with the query builder:

6. Filtering and Querying - Filter, compare, and transform documents
7. Lookup - Foreign key joins and data population

ValueProxy

The ValueProxy<T> class acts as a proxy to a database value. Operations on a ValueProxy are not executed immediately but are recorded as query stages. ValueProxy objects appear inside callback functions for map, filter, do, update, join, and other query methods.

Schema Management

AQL organizes data through schemas and instances. A Schema defines the structure of your database (tables, fields, and indexes). Each schema can have multiple instances, and the underlying module implementation determines how instances map to physical storage.