josh/Catalyst
1
0
Fork 0
Code Issues 2 Pull Requests Actions Packages Projects Releases 16 Wiki Activity

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
Conversation 0 Commits 2 Files Changed 1
+10 -6
josh commented 2026-03-28 20:20:01 -04:00
Owner
Copy Link
Copy Source

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
CI / build-dev (pull_request) Has been skipped
Details
CI / test (pull_request) Successful in 21s
Details
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
CI / build-dev (pull_request) Has been skipped
Details
CI / test (pull_request) Successful in 13s
Details
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.
Reviewers
No Reviewers
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
josh (Josh Wright)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: josh/Catalyst#58