How yiisoft/db works
Yii Database is a framework-agnostic PHP database abstraction layer. Applications create a connection through a database driver, compose reads with the query API or writes/schema operations with commands, and execute them against a DBMS; transactions and batched results extend that workflow. Internally, query builders translate query structures and expressions into driver-specific SQL, while schema metadata and quoting support database-aware operations. The README documents driver packages and schema caching; several internal links below rely on indexed references rather than inspected implementation excerpts.
Main entry points: AbstractQueryBuilder.php Query Builders · ConnectionInterface.php Connection · Query.php Query API · CommandInterface.php Command API
Components 21
Database API
- Connection
src/Connection/ConnectionInterface.php - Query API
src/Query/Query.php - Command API
src/Command/CommandInterface.php - Transactions
src/Transaction/TransactionInterface.php - Batch Results
src/Query/BatchQueryResult.php
SQL Construction
- Query Builders
src/QueryBuilder/AbstractQueryBuilder.php - DQL Builder
src/QueryBuilder/AbstractDQLQueryBuilder.php - DML Builder
src/QueryBuilder/AbstractDMLQueryBuilder.php - Expressions
src/Expression/Expression.php - Expression Builders
src/Expression/ExpressionBuilder.php - Query Conditions
src/QueryBuilder/Condition
Schema Metadata
- Schema API
src/Schema/AbstractSchema.php - Column Metadata
src/Schema/Column/ColumnInterface.php - SQL Quoter
src/Schema/Quoter.php - Schema Cache
src/Cache/SchemaCache.php
Execution Runtime
- PDO Adapter
src/Driver/Pdo/AbstractPdoCommand.php - Data Reader
src/Query/DataReaderInterface.php
Other components
- Application
- Database Server
- DB Driver Packages
- PSR-16 Cache
Connections 26
- Application → Connection: opens connection
README.md - DB Driver Packages → Connection: provides driver
README.md - Application → Query API: composes reads
README.md - Application → Command API: requests writes
README.md - Application → Transactions: runs transaction
README.md - Connection → Query API: creates query
src/Connection/ConnectionInterface.php - Connection → Command API: creates command
src/Command/CommandInterface.php - Connection → Transactions: manages transaction
src/Connection/ConnectionInterface.php - Query API → Connection: executes through
src/Query/Query.php - Query API → Batch Results: creates batches
src/Query/Query.php - Query API → Query Builders: builds SQL
src/Query/Query.php - Query Builders → DQL Builder: delegates reads
src/QueryBuilder/AbstractDQLQueryBuilder.php - Query Builders → DML Builder: delegates writes
src/QueryBuilder/AbstractDMLQueryBuilder.php - Query Builders → Expressions: builds expressions
src/QueryBuilder/AbstractQueryBuilder.php - Query Builders → Query Conditions: builds conditions
src/QueryBuilder/AbstractQueryBuilder.php - Expressions → Expression Builders: built by
src/Expression/ExpressionBuilder.php - Command API → Query Builders: generates SQL
src/Command/CommandInterface.php - Command API → PDO Adapter: executes command
src/Driver/Pdo/AbstractPdoCommand.php - PDO Adapter → Database Server: sends SQL
- Connection → Schema API: obtains metadata
src/Connection/ConnectionInterface.php - Schema API → Column Metadata: describes columns
- Query Builders → SQL Quoter: quotes identifiers
src/Schema/Quoter.php - Schema API → Schema Cache: caches metadata
README.md - Batch Results → Data Reader: yields rows
src/Query/BatchQueryResult.php - Data Reader → Database Server: reads results
- PSR-16 Cache → Schema Cache: backs cache
README.md