feat/carlos-db-read
Human
carlos db, read side: the console serves a hibernating instance's replica LTX files by coordinate from the in-region data bucket, and the CLI restores them read-only for pull and query (spec 2026-09-02 §6, plan unit 1). It replaces the box-staging pull on feat/db-push-pull (review #194). Push is deferred to its own design pass.
Commits
24
Discussions
0
0 open
Tasks
7/7
done
Discussions
- No discussions on this branch yet.
Tasks 7/7 done
- Task 1: export lease.ReadReplicaClient for the db door Done
- Task 2: dbdoor coordinate wire shape Done
- Task 3: console resolveReplica and residency refusals before S3 Done
- Task 4: console db door handlers (list/get by coordinate, members only, audit) Done
- Task 5: dbdoor read-only litestream ReplicaClient Done
Activity
- claude agent, operated by paul@keymail.dev pushed b05ceeef4 carlos db: Astra round 4, first-open 429s, Retry-After cap, pragma as a name
- claude agent, operated by paul@keymail.dev pushed f7490ce17 lease, dbdoor: let a stop reach the integrity check
- claude agent, operated by paul@keymail.dev pushed 5c5351145 dbdoor: wait out a busy reopen without losing the bytes downloaded
- claude agent, operated by paul@keymail.dev pushed cd153826f carlos db query: make the pragma guard an invariant over every token
- claude agent, operated by paul@keymail.dev pushed d7a0c9127 carlos db: honour a stop after the downloads finish
- claude agent, operated by paul@keymail.dev pushed 838ea5c30 dbdoor: resume a download that drops part way
- claude agent, operated by paul@keymail.dev pushed f300cd272 db door: keep the write deadline through net/http's final flush
- claude agent, operated by paul@keymail.dev pushed a93f8f639 carlos db query: see pragmas through EXPLAIN and a byte-order mark
- claude agent, operated by paul@keymail.dev pushed c4c85da65 spec: carlos db, record the service-principal 403 in §6
- claude agent, operated by paul@keymail.dev pushed 51badfd74 db door: bound active streams, cut idle ones, restore one file at a time
- claude agent, operated by paul@keymail.dev pushed ab02ff45f carlos db query: one statement, no pragma changes, temp storage in memory
- claude agent, operated by paul@keymail.dev pushed e3f26602e console: audit every db door GET, ranged ones included
- claude agent, operated by paul@keymail.dev pushed 6786a5883 carlos db: close ATTACH, clean up on a closed pipe, never print an empty error
- task updated: Task 7: carlos db pull and query, cli.md, copy-review strings
- claude agent, operated by paul@keymail.dev pushed 9fe9ec285 carlos db: pull and query a restored replica, read-only
- claude agent, operated by paul@keymail.dev pushed 4eb798c30 dbdoor: restore into a 0700 directory, retrying the whole plan once
- task updated: Task 6: dbdoor RestoreTo (0700 dir, whole-Restore retry, CheckDB)
- claude agent, operated by paul@keymail.dev pushed bd9b6d200 dbdoor: a replica client with no write methods
- task updated: Task 5: dbdoor read-only litestream ReplicaClient
- task updated: Task 4: console db door handlers (list/get by coordinate, members only, audit)
- claude agent, operated by paul@keymail.dev pushed e6d358ea9 console: serve replica LTX files by coordinate, members only
- claude agent, operated by paul@keymail.dev pushed c85bbd2da console: resolve an instance to one replica prefix, refusing before S3
- task updated: Task 3: console resolveReplica and residency refusals before S3
- claude agent, operated by paul@keymail.dev pushed 98db0e097 dbdoor: the coordinate wire shape the door and client share
- task updated: Task 2: dbdoor coordinate wire shape
- task updated: Task 1: export lease.ReadReplicaClient for the db door
- claude agent, operated by paul@keymail.dev pushed 27883b08d lease: export ReadReplicaClient for the db door
- claude agent, operated by paul@keymail.dev added task Task 6: dbdoor RestoreTo (0700 dir, whole-Restore retry, CheckDB)
- claude agent, operated by paul@keymail.dev added task Task 7: carlos db pull and query, cli.md, copy-review strings
- claude agent, operated by paul@keymail.dev added task Task 2: dbdoor coordinate wire shape