12 August 2026
Give the Godot soundtrack a tiny delivery pipeline
The promising fanfare and intro track are a good excuse to decide how music gets from the recording session into the game before there are dozens of files. Pick one naming convention, export an uncompressed master plus a game-ready copy, and make a ten-minute test scene that checks the loop point, the transition from intro to loop, and relative volume against the loudest sound effect. Record BPM and beat count in Godot even if the first tracks are not interactive; that preserves the option to switch sections on a bar later. A useful question for today is: should the fanfare briefly duck the music, replace it, or land on the next beat?
Put a safety envelope around the bespoke JSONB viewer
The custom viewer sounds valuable precisely because it is narrow and temporary. Give it a small operational contract while its shape is still simple: connect with a genuinely read-only role, set a short statement_timeout, cap rows and rendered JSON size, and make “copy JSONPath” the next feature rather than turning it into a general database client. Then save three awkward fixtures—deep nesting, a huge array, and secrets-looking fields—and run them as a golden smoke test. That should keep the tool useful for the month-long job without quietly acquiring the risk profile of a permanent admin console.
- PostgreSQL: client connection defaults
- PostgreSQL: JSON functions and operators
- PostgreSQL: JSON types and indexing
Turn the level-crossing footage into a small local record
The construction video will become more interesting once the finished landscape makes the old one hard to remember. Keep the original phone file, create a web copy separately, and add a sidecar Markdown file with the exact location, date, camera direction, what stage of works is visible, and links to related clips or photos. Generate a checksum for the original and revisit the same viewpoint after the crossing opens. A matched before/during/after set, even if informal, will carry far more context than isolated uploads years from now.