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 4 of 12
Turn a document-processing brief into reviewable boundaries, contracts and failure probes.
Specify consistency, routing and recovery for a regional customer read experience.
Separate notification intent, delivery attempts and user-visible receipt semantics.
Choose storage, indexing and deletion semantics for a bounded audit archive.
Define fair scheduling, bounded work and recovery for a report service.
Replace a legacy customer key through additive schema changes and verified backfill.
Claim, renew and finish work without duplicate authority or stranded assignments.
Build a bounded backup inventory and rehearse restoration with consistency checks.
Make cross-organization relationships impossible through database and repository constraints.
Separate stable document fields from versioned bounded metadata and migrate safely.
Elect one active scheduler while preventing expired owners from mutating shared state.
Recover a multi-step return workflow across inspection, shipping and refund providers.
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.