Separate attachment display names from blob identities
Renaming an attachment currently moves its physical file and breaks another reference. Store display names on references.
Estimated field mix
- Storage systems60%
- Database engineering40%
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.
1380 matching tickets · Page 81 of 115
Renaming an attachment currently moves its physical file and breaks another reference. Store display names on references.
Estimated field mix
Equal bytes across organizations share observable lookup results. Restrict deduplication to the tenant boundary.
Estimated field mix
Documents can attach blobs before upload verification ends. Require available status before creating a reference.
Estimated field mix
Cleanup deletes bytes immediately when count reaches zero, leaving no recoverable decision record. Add a pending-deletion state.
Estimated field mix
A document attaches a blob while cleanup deletes its file. Coordinate reference admission and deletion eligibility.
Estimated field mix
Permission errors are swallowed and metadata says Deleted while bytes remain. Persist retryable failure state.
Estimated field mix
A process dies after file removal but before metadata commit. Recovery must distinguish absent bytes from an untouched blob.
Estimated field mix
The sweeper repeatedly scans the full blob table. Add indexed bounded batches without skipping concurrent tombstones.
Estimated field mix
Cleanup counts only current document references and breaks retained versions. Include every retained reference authority.
Estimated field mix
Operators report savings from tombstoned bytes that still exist. Separate eligible, attempted and acknowledged removal totals.
Estimated field mix
Delimiter-based records fail when values contain newlines. Add a length-prefixed binary record format.
Estimated field mix
Empty buffers are interpreted as Not found. Return explicit presence separate from byte length.
Estimated field mix
138 matching projects · Page 2 of 12
Repair public-service booking across keyboard use, zoom, timeouts, and changing availability.
Improve navigation, text adaptation, annotations, and revision recovery in an internal document reader.
Build a bounded live coordination room with ordered events, reconnect recovery, and clear authority.
Reconcile synthetic vehicle locations, assignment changes, and stream interruptions in an operations dashboard.
Build a local release assistant that prepares reviewable plans and survives interrupted release steps.
Shorten a local monorepo check loop while retaining correctness when inputs, dependencies, or tools change.
Build a deterministic checkout regression suite around pricing, accessibility, payment failures, and isolated test data.
Create a local webhook laboratory that reproduces duplicates, disorder, signature failures, and interrupted delivery.
Build a retrieval workflow that respects document access, cites exact revisions, and declines unsupported answers.
Build a routing assistant that suggests queues, validates model output, and preserves accountable human corrections.
Build a vendor inventory connector with stable identity mapping, resumable ingestion, reconciliation, and tenant-safe operations.
Build a calendar booking workflow with time-zone rules, conflict handling, idempotent provider calls, and safe reconnect behavior.
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.