Use keyset traversal for shipments sharing timestamps
Pagination drops shipments when several rows have the same update timestamp.
Estimated field mix
- Database engineering70%
- API design30%
Preparing the next view without exposing private workflow data.
Design a system. Diagnose tail latency. Ship a migration. Recover a failed rollout. Pick a focused ticket or follow a project through its delivery phases.
1380 tickets · 138 projects · 26 engineering fields · Four difficulty levels
Field counts and the engineering field filter use each project's primary field. Estimated ticket labels can span multiple fields.
50 matching tickets · Page 3 of 5
Pagination drops shipments when several rows have the same update timestamp.
Estimated field mix
A shipment changes status between pages, and partners expect a snapshot the endpoint never promised.
Estimated field mix
A fast first page still waits for an expensive exact count.
Estimated field mix
A permitted filter scans every shipment despite bounded page size.
Estimated field mix
The client SDK retries invalid cursors forever instead of telling callers to restart.
Estimated field mix
Partners use an interactive list endpoint as if it were a financial or audit export.
Estimated field mix
A single automation scope permits every operation in the organization.
Estimated field mix
A valid credential can be paired with another organization ID in the URL.
Estimated field mix
Partners can distinguish nonexistent records from records belonging to another organization.
Estimated field mix
The parent resource is authorized, but nested record IDs bypass tenant checks.
Estimated field mix
Customers need rotation overlap, but old keys remain valid forever.
Estimated field mix
Revoked clients retain access until a long cache TTL expires.
Estimated field mix
5 matching projects · Page 1 of 1
Evolve a partner API with explicit compatibility, deprecation, and client migration contracts.
Design bulk record imports with explicit operation state, item errors, and recovery semantics.
Expose a changing catalog through bounded filters, stable cursors, and explicit consistency.
Design scoped partner credentials with revocation, safe errors, and client lifecycle controls.
Expose event subscriptions with immutable envelopes, bounded delivery, and safe replay.
Practice scoped changes, keep a portable implementation and verification record, and learn to explain operational tradeoffs. Choose a ticket whose prerequisites you can provide.
Use realistic work to structure onboarding, internal practice, and conversations about engineering decisions. Each project names the delivery benefit. Agree scope and compensation before requesting company-specific work.
CSV contains one row per ticket. Map fields and issue types in your tracker; project grouping and dependency keys are descriptive. JSON preserves the complete project structure. These downloads do not synchronize with Jira.