Dual-DB archive reports
Live + archive connections merged with trip_id dedupe for COD, sales, and export windows.
- ReportKit::connection() per DB
- MergedRowSource + PseudoPaginator::dedupeByKey
- DataTables /v1/data JSON in one hop
Patterns teams use in production hosts — SQL stays in the app, ReportKit owns the pipeline.
Live + archive connections merged with trip_id dedupe for COD, sales, and export windows.
Week chunks stream into a prepared buffer so downloads never re-query the full window.
Summary payload rides alongside serverSide pages for operator dashboards.
Same Core engine on Laravel 4.1–5.4 with path-friendly stubs and manual provider registration.
The public demo hits a Cloudflare Worker that queries two D1 databases, merges, dedupes, and returns DataTables JSON — same contract as PHP RowSource.