fix: millisecond precision timestamps and correct history ordering #58

Merged
josh merged 2 commits from feat/jobs-system into dev 2026-03-28 20:20:42 -04:00
Owner

datetime('now') only stores to the second, making same-second events
indistinguishable. Switched all instance_history and job_runs writes
to strftime('%Y-%m-%dT%H:%M:%f', 'now') for millisecond precision.

Reverted getInstanceHistory to ORDER BY changed_at DESC, id DESC so
newest events appear at the top and instance creation (lowest id,
earliest timestamp) is always at the bottom.

Co-Authored-By: Claude Sonnet 4.6 noreply@anthropic.com

datetime('now') only stores to the second, making same-second events indistinguishable. Switched all instance_history and job_runs writes to strftime('%Y-%m-%dT%H:%M:%f', 'now') for millisecond precision. Reverted getInstanceHistory to ORDER BY changed_at DESC, id DESC so newest events appear at the top and instance creation (lowest id, earliest timestamp) is always at the bottom. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
josh added 1 commit 2026-03-28 20:20:01 -04:00
fix: millisecond precision timestamps and correct history ordering
All checks were successful
CI / test (pull_request) Successful in 21s
CI / build-dev (pull_request) Has been skipped
7999f46ca2
datetime('now') only stores to the second, making same-second events
indistinguishable. Switched all instance_history and job_runs writes
to strftime('%Y-%m-%dT%H:%M:%f', 'now') for millisecond precision.

Reverted getInstanceHistory to ORDER BY changed_at DESC, id DESC so
newest events appear at the top and instance creation (lowest id,
earliest timestamp) is always at the bottom.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
josh added 1 commit 2026-03-28 20:20:06 -04:00
Merge branch 'dev' into feat/jobs-system
All checks were successful
CI / test (pull_request) Successful in 13s
CI / build-dev (pull_request) Has been skipped
d84674b0c6
josh scheduled this pull request to auto merge when all checks succeed 2026-03-28 20:20:09 -04:00
josh merged commit 03cf2aa9c6 into dev 2026-03-28 20:20:42 -04:00
josh deleted branch feat/jobs-system 2026-03-28 20:20:42 -04:00
Sign in to join this conversation.
No Reviewers
No Label
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: josh/Catalyst#58