Build parameterized metadata filters with an allowlisted operator set
A query endpoint interpolates client-provided JSON paths and operators into SQL.
Estimated field mix
- Security50%
- Database engineering50%
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 39 of 115
A query endpoint interpolates client-provided JSON paths and operators into SQL.
Estimated field mix
The database query for arrays and null values differs subtly from the API contract, making support reports inconsistent.
Estimated field mix
New readers assume every document has a valid owner and UTC creation instant, but quarantined legacy rows still violate that assumption.
Estimated field mix
The team wants to remove legacy JSON fields immediately after switching reads, which could break old clients during a rollback.
Estimated field mix
The scheduler table stores only owner name and expiry, so an old owner can appear identical to a later process with the same name.
Estimated field mix
Two instances disagree about lease expiry because their local clocks differ by several seconds.
Estimated field mix
The design adds a lease but assumes every downstream operation automatically knows whether its caller is still leader.
Estimated field mix
Two instances see an expired lease and both believe they became the active scheduler.
Estimated field mix
A delayed renewal from an earlier process extends the newest owner's lease row while reporting success to the stale process.
Estimated field mix
A scheduler pauses past expiry, then resumes a previously prepared plan after another instance has taken over.
Estimated field mix
A new leader repeats the current maintenance period and creates a second plan for the same logical occurrence.
Estimated field mix
A scheduler renews its lease while stuck on one task, so the status page incorrectly reports healthy processing.
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.