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 8 of 12
Build navigable search and result recovery for a public directory.
Repair conditional fields, draft recovery, and deliberate submission.
Keep synthetic visit notes reliable through offline use and process restarts.
Manage resumable public-content downloads and safe local playback state.
Handle deep links, expired sessions, and interrupted navigation using local identity stubs.
Make scheduling interactions operable with keyboard, magnification and assistive technology.
Give charts, sortable tables and exports equivalent understandable information.
Make dialogs, menus, toasts and nested workflows predictable across input methods.
Model ephemeral team presence with expiry, reconnects and scoped fan-out.
Keep a synthetic service-status board ordered and replayable over server-sent events.
Coordinate expiring seat holds and live availability in a local simulation.
Build a local multipart-upload coordinator with scoped identities and integrity checks.
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.