amadan
db-pull-at
carlos db pull and carlos db query take --at <RFC 3339 time> and restore the instance's replica as it was at that time (#262).
- dbdoor.RestoreAsOf sets litestream's Timestamp. The door lists S3 LastModified (upload time, second resolution, rounded down), so --at is rounded down to its second and a copy is never newer than --at. It can be a little older; the output names the transaction it stopped at.
- Refuses a listing with no file times (the claim-mode door), which litestream would otherwise read as "before T" and answer with the newest copy.
- A time before the kept history names the first second that works. Pre-epoch times (including Go's zero time) clamp to the epoch so they can't mean "newest".
- --txid was considered and dropped: it only lands on exact file boundaries.
Copy: CLI strings and the docs/site/cli.md paragraph approved in copy review, unedited. Review: Astra two rounds, accepted. Gate green on 26c65c10; main merged at 40647969.
Reach: carlos db reads only sleeping instances, which keep about a day of history until #263 lands.
Commits
5
Discussions
0
0 open
Tasks
6/6
done
Discussions
- No discussions on this branch yet.
Tasks 6/6 done
- Check how litestream selects files for a timestamp restore Done
- Thread --at through dbdoor (RestoreAsOf, tests first) Done
- Add --at to carlos db pull and query, with plain out-of-range errors Done
- Say the as-of point in dbAsOf output and usage Done
- Gate, review (Astra), handoff Done
Activity
- task updated: Gate, review (Astra), handoff
- claude agent, operated by paul@keymail.dev pushed 406479697 Merge remote-tracking branch 'origin/main' into db-pull-at
- task updated: Document --at in docs/site/cli.md (copy review)
- claude agent, operated by paul@keymail.dev pushed daf459a87 docs/site/cli.md: explain carlos db --at (#262)
- claude agent, operated by paul@keymail.dev pushed 26c65c10f db --at: an explicit year-1 time is before the history, not the newest copy (#262)
- task updated: Thread --at through dbdoor (RestoreAsOf, tests first)
- task updated: Add --at to carlos db pull and query, with plain out-of-range errors
- task updated: Say the as-of point in dbAsOf output and usage
- claude agent, operated by paul@keymail.dev added task Document --at in docs/site/cli.md (copy review)
- claude agent, operated by paul@keymail.dev pushed af256c320 carlos db pull/query --at: read a database as of a past time (#262)
- claude agent, operated by paul@keymail.dev pushed 1f8d9b18e dbdoor: RestoreAsOf restores a replica as of a point in time (#262)
- task updated: Check how litestream selects files for a timestamp restore
- claude agent, operated by paul@keymail.dev added task Add --at to carlos db pull and query, with plain out-of-range errors
- claude agent, operated by paul@keymail.dev added task Say the as-of point in dbAsOf output and usage
- claude agent, operated by paul@keymail.dev added task Gate, review (Astra), handoff
- claude agent, operated by paul@keymail.dev added task Check how litestream selects files for a timestamp restore
- claude agent, operated by paul@keymail.dev added task Thread --at through dbdoor (RestoreAsOf, tests first)