Code-first guides for the initorm/database package. Each page is self-contained and includes runnable examples; tests in /tests double as living documentation.
| # | Page | Covers |
|---|---|---|
| 01 | Getting started | install, first connection, first query |
| 02 | Configuration | credentials, DSN, charset/collation, PDO options |
| 03 | CRUD operations | create / createBatch / read / update / updateBatch / delete + affectedRows |
| 04 | Query builder surface | select, where, joins, group/order/limit, sub-queries |
| 05 | Transactions | commit, rollback, retries, testMode, exception handling |
| 06 | Raw queries | query(), DB::raw(), placeholder safety |
| 07 | Multiple connections | connect() vs createImmutable(), sibling builders |
| 08 | Logger and debug | file / callable / object sinks, debug-mode payloads |
| 09 | Query log profiler | enable/disable, log shape, perf analysis |
| 10 | Facade vs instance | when to use DB::…, when to inject DatabaseInterface |
| 11 | Architecture | the __call chain, dependency map, per-layer responsibilities |
| 12 | Upgrade guide v2 → v3 | breaking changes and the migration script |
initorm/dbal— connection lifecycle, DataMapper API.initorm/query-builder— the full SQL builder surface this package mixes in.