game-dev/RicosWorld
Watch
2
0
Fork
You've already forked RicosWorld
 0
Code Issues 7 Pull requests 27 Projects Releases Packages Wiki Activity Actions

[INFRA] Production & Dev Realm Deployment Pipeline & Automated Database Backups #8

New issue
Closed
opened 2026-10-17 22:58:18 +02:00 by agent-gemini · 1 comment
agent-gemini commented 2026-10-17 22:58:18 +02:00
Collaborator
Copy link

Goal

Harden deployment and backup operations for https://ricosworld.themels.online.

Acceptance Criteria

  • Verify scripts/deploy.mjs zero-downtime staging, healthcheck verification, and /version.json publication.
  • Add automated off-site backup script for /opt/ricosworld/data/frontier.db (SQLite snapshots & command logs).
## Goal Harden deployment and backup operations for `https://ricosworld.themels.online`. ## Acceptance Criteria - [ ] Verify `scripts/deploy.mjs` zero-downtime staging, healthcheck verification, and `/version.json` publication. - [ ] Add automated off-site backup script for `/opt/ricosworld/data/frontier.db` (SQLite snapshots & command logs).
agent-gemini commented 2026-10-18 12:42:45 +02:00
Author
Collaborator
Copy link

Implemented in PR #29: scripts/backup.mjs with SQLite VACUUM INTO, PRAGMA integrity_check, SHA-256 validation, 24h/30d rolling retention, and scripts/restore-backup.mjs.

Implemented in PR #29: scripts/backup.mjs with SQLite VACUUM INTO, PRAGMA integrity_check, SHA-256 validation, 24h/30d rolling retention, and scripts/restore-backup.mjs.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
claude/241-sleepfix
claude/239-freshstart
claude/237-medfix
claude/235-floorfix
claude/233-floors
claude/231-recroom
claude/229-psychite
claude/227-firefoam
claude/225-burning
claude/223-deterioration
claude/221-recreation
claude/219-guns
claude/217-wardenopinion
claude/215-traits3
claude/213-graves
claude/211-drugbinge
claude/209-corpsethoughts
claude/207-hospitalbed
claude/205-hangover
claude/203-bond
claude/201-prisonbreak
claude/199-traderequest
claude/197-tribal
claude/195-smokeleaf
claude/193-autodoor
claude/191-chemfuel
claude/189-geothermal
claude/187-beauty-need
claude/185-doors-materials
claude/183-thrumbos
claude/181-alcohol-addiction
claude/179-inspired-trade
claude/177-surgery
claude/175-malaria-parasites
claude/173-animal-training
claude/171-hygiene
claude/169-brewing-beer
claude/167-seating
claude/165-paste-dispenser
claude/163-wind-water-power
claude/161-barracks
claude/159-mini-turrets
claude/157-home-area
claude/155-comms-pemmican
claude/153-mechanoids
claude/151-more-traits
claude/149-more-breaks
claude/147-merge-pr-cli
claude/145-infestations
claude/143-animal-breeding
claude/141-construction-success
claude/139-game-conditions
claude/137-joy-comfort
claude/135-combat-timing
claude/133-medicine-tiers
claude/131-stockpile-settings
claude/129-butchering
claude/127-disease-rates
claude/124-bench-bills
claude/122-romance-family
claude/120-ranching
claude/118-apparel-layers
claude/116-raid-strategies
claude/114-rimworld-worktypes-research
claude/112-rimworld-weather
claude/110-zone-merge-delete
claude/108-rimworld-quality
claude/106-rimworld-cleanliness
claude/104-rimworld-animals
claude/102-rimworld-combat
claude/100-rimworld-social
claude/98-cassandra-storyteller
claude/96-rimworld-mood
claude/94-rimworld-traits
claude/92-rimworld-skills
claude/90-rimworld-food
claude/88-fire
claude/86-rimworld-base-speed
claude/84-rimworld-parity-audit
claude/82-slower-pacing
claude/80-player-guide
claude/78-animal-taming
claude/76-diseases
claude/74-prisoners
claude/72-leather-armor
claude/70-predators-manhunters
claude/68-room-quality
claude/66-recreation-need
claude/64-wildlife-hunting
claude/62-production-bills
claude/60-player-decisions
claude/58-raider-roster-and-pacing
claude/56-tiles-and-ghost-commands
claude/54-walls-pawns-movement
claude/52-rimworld-mapgen
claude/50-apparel
claude/48-systems-overhaul
gemini/46-filter-colony-log
claude/44-ui-overhaul
gemini/42-comprehensive-ui-overhaul
gemini/40-menu-appearance-overhaul
gemini/38-fix-research-execution
gemini/36-cybernetics-and-caravans
gemini/34-wonders-and-bounties
gemini/32-fix-research-feedback
gemini/fix-research-flicker
gemini/mmo-quad-expansion
gemini/quad-system-expansion
gemini/parity-work-combat-health
gemini/22-stockpile-list-top-left
gemini/20-world-biome-expansion
gemini/18-direct-colonist-control
gemini/16-colonist-click-reliability
gemini/11-world-map-tech-tree
claude/13-client-render-lockup
gemini/9-email-password-recovery
No results found.
Labels
Clear labels   
agent/claude
Assigned to Claude agent

  
agent/gemini
Assigned to Gemini agent

  
agent/kimi
Assigned to Kimi agent

  
area/assets
Blender 3D-to-2D SNES sprites & audio

  
area/client
PixiJS 2D client, UI & sprites

  
area/server
Authoritative server, persistence & auth

  
area/sim-core
Deterministic simulation core

  
priority/high
High priority task

  
priority/low
Low priority task

  
priority/medium
Medium priority task

  
status/blocked
Blocked by dependency or question

  
status/needs-review
Ready for peer/human review

  
type/bug
Something isn't working

  
type/chore
Maintenance, refactoring, tooling

  
type/docs
Improvements or additions to documentation

  
type/feature
New feature or request

No labels
agent/claude
agent/gemini
agent/kimi
area/assets
area/client
area/server
area/sim-core
priority/high
priority/low
priority/medium
status/blocked
status/needs-review
type/bug
type/chore
type/docs
type/feature
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
game-dev/RicosWorld#8
No description provided.