July 29, 2026
SimCity, but make it server drama
PGSimCity – an explorable 3D model that shows how Postgres works
A nerdy database got turned into a tiny city, and commenters are equal parts obsessed and annoyed
TLDR: PGSimCity turns a hard-to-understand database into a 3D city you can explore, making a notoriously confusing topic much easier to grasp. Commenters loved the idea, immediately compared it to a rival version, and of course started arguing about whether the post itself was old news.
Imagine turning a giant, confusing database system into a walkable little city you can explore in your browser. That’s the pitch behind PGSimCity, a playful 3D model that shows what’s happening inside PostgreSQL, the software many apps use to store their data. Instead of reading dry manuals, you can literally wander around and watch the system’s “workers,” storage areas, backups, and traffic jams in action. It’s part teaching tool, part toy, and very much aimed at the poor souls who suddenly have to run a database without ever planning to.
The community reaction? Instant delight, with a side of snark. One commenter basically summed up the wholesome mood with: this is awesome, what a cool idea. That’s the dominant vibe here — people seem charmed by the sheer audacity of making something so boring-on-paper look like a city-building game. But because this is the internet, the applause lasted about five seconds before someone arrived with the inevitable sequel energy: there’s already a ClickHouse version too, though they couldn’t resist adding that it looks "much simpler" with "fewer moving parts" — a tiny drive-by roast wrapped inside a helpful link.
And then came the classic comment-section plot twist: repost police. One user slammed the brakes on the fun to complain it had already been posted two days earlier, delivering the timeless online buzzkill of “c’mon.” So yes, the project is a hit, but the real show is the comment thread doing what comment threads do best: hyping, comparing, and policing the timeline like it’s a full-time job.
Key Points
- •PGSimCity is an interactive 3D educational model that visualizes how PostgreSQL internals work in a browser with no installation required.
- •The project is independent and non-commercial, and explicitly states it is not affiliated with or endorsed by Electronic Arts Inc. despite the SimCity reference.
- •PGSimCity is described as a model rather than an emulator: it does not run PostgreSQL source code and scales system behavior for human observation.
- •The project says it underwent three specialist review rounds, a separate visualization audit, and includes 234 tests with CI enforcing passing builds.
- •The visualization covers PostgreSQL components and behaviors including backends, shared buffers, storage, WAL, checkpoints, autovacuum, replication, backups, recovery, and guided scenarios such as cache thrash and long-running transactions.