Task library BAPIPAGE
Project scope 10 tickets / 3 phases
Total focused work estimate 26h 30m + setup
Suggested stack TypeScript · OpenAPI · PostgreSQL Fictional engineering practice briefs. Starter repositories, fixtures, automated grading, and verified ownership are not included.
Choose a bounded subset for an assessment or practice session. Prerequisites and remaining project work must be agreed separately.
Field percentages are editorial estimates of the ticket's engineering focus. They total 100%; they are not measured time, proficiency scores, or ownership evidence.
Pattern topics identify design choices to practice. Read the ticket's acceptance criteria and justify the simplest suitable approach. Tags are not capability or ownership evidence; an untagged ticket has no curated pattern topic assigned.
Recommended next step Start with BAPIPAGE-101 Open the first ticket for its prerequisites, acceptance criteria, verification plan, and an editable task draft.
What the engineer takes away Practice cursor design, query contracts, and consistency/performance tradeoffs.
What the team gains Provide predictable list APIs that remain bounded and preserve tenant scope.
Before you start Create a local shipment dataset with synthetic tenants, equal timestamps, and concurrent update fixtures. Delivery agreement Deliver a local versioned listing endpoint and documented client iteration behavior.
AI tools are welcome during implementation. Record assumptions, review the result, and verify its behavior.
Delivery phases PHASE 1 Specify supported filters, sorting, and authorization.
PHASE 2 Bind cursors and handle concurrent data changes.
PHASE 3 Measure query plans and document consistency.
Define query semantics Specify supported filters, sorting, and authorization.
BAPIPAGE-101 Entry ticket; project setup still required BAPIPAGE-102 Depends on BAPIPAGE-101 Estimated field mix
Database engineering 40% Security 40% API design 20% BAPIPAGE-103 Depends on BAPIPAGE-102 Estimated field mix
Security 70% Database engineering 30% Implement stable traversal Bind cursors and handle concurrent data changes.
BAPIPAGE-104 Depends on BAPIPAGE-101, BAPIPAGE-102, BAPIPAGE-103 Estimated field mix
API design 50% Security 30% Database engineering 20% BAPIPAGE-105 Depends on BAPIPAGE-104 Estimated field mix
Database engineering 70% API design 30% BAPIPAGE-106 Depends on BAPIPAGE-105 Estimated field mix
System design 40% API design 40% Database engineering 20% BAPIPAGE-107 Depends on BAPIPAGE-103, BAPIPAGE-105 Estimated field mix
Performance engineering 50% Database engineering 30% API design 20% Review contract limits Measure query plans and document consistency.
BAPIPAGE-108 Depends on BAPIPAGE-105, BAPIPAGE-107 Estimated field mix
Database engineering 60% Performance engineering 40% BAPIPAGE-109 Depends on BAPIPAGE-104, BAPIPAGE-106, BAPIPAGE-108 Estimated field mix
Developer tooling 60% API design 40% BAPIPAGE-110 Depends on BAPIPAGE-109 Use this project CSV keeps grouping and dependency keys as descriptive fields. Import mapping depends on your tracker configuration.