Besides the sadly obvious vibe-coding, just note that SimCity is still an active trademark from EA, so might be good to rename it.
PGSimCity - How PostgreSQL Works
31–40 of 104 posts
Re: PGSimCity - How PostgreSQL Works
#32Great work! When zooming out a bit, I'm somewhat sure that the 'blinking'/glitching is due to z-fighting. Just something you may want to look into (ie move 3d surfaces so that they're not at the exact same z)
Correct -- z-fighting on coplanar ground surfaces. Fixing with explicit offsets.
thanks
Re: PGSimCity - How PostgreSQL Works
#33I imagined as soon I saw the initial visual that I would somehow be able to enter a query and it would walk me through the flow through the entire system starting from input parsing to all the way to delivering output and perhaps along the way understand some of the autonomous processes that happen in parallel that aren't query specific but run constantly. What others are saying - fantastic attempt, but don't know wh…
try pressing T
Re: PGSimCity - How PostgreSQL Works
#34It surely is impressive,but it’s just that - components of db service as buildings/machine. What it needs is narrative, purpose, with main actors clearly defined - client and data. demonstrating what is involved in the chain when data’s written and requested.
Try the tour. It’s exactly that.
yep (via pressing T)
but I agree, could be better – thinking
Re: PGSimCity - How PostgreSQL Works
#353.86B tokens to build a visual simulator of a database that runs on a fraction of that compute. we're using the expensive brain to draw pictures of the cheap brain.
[dead]
Re: PGSimCity - How PostgreSQL Works
#36Wow. Can’t wait to explore the architecture
Re: PGSimCity - How PostgreSQL Works
#37I have a pretty good working knowledge of the internals of Postgres, but this just confused me. I think it's too busy to understand. At the very least, it would be cool if there were a "slow down" button.
Re: PGSimCity - How PostgreSQL Works
#38I have a pretty good working knowledge of the internals of Postgres, but this just confused me. I think it's too busy to understand. At the very least, it would be cool if there were a "slow down" button.
There are buttons on the bottom left: pause and two to adjust the speed (down to 0.1x).
Some parts of the city can be adjusted when you click on it (I just found the transactions/s)
Re: PGSimCity - How PostgreSQL Works
#39I have a pretty good working knowledge of the internals of Postgres, but this just confused me. I think it's too busy to understand. At the very least, it would be cool if there were a "slow down" button.
There are buttons on the bottom left: pause and two to adjust the speed (down to 0.1x). Some parts of the city can be adjusted when you click on it (I just found the transactions/s)
Ah indeed there is. Totally didn't notice that, thanks.
But even at .1x it's too quick. :) I should be able to fire individual transactions and watch them flow.
Re: PGSimCity - How PostgreSQL Works
#40I like the education tools being developed using coding agents, but there should be some review in the process.
Good luck continuing it, hope you generated something that can be iterated on.