Live data from Hacker News

PGSimCity - How PostgreSQL Works

nikolays.github.io

21–30 of 104 posts

Re: PGSimCity - How PostgreSQL Works

#21
post #15

Understanding how scheduling works inside a database used to require numerous architecture diagrams to explain. I was amazed when I saw PGSimCity — it presents such a complex technical implementation process in such an engaging way. Since it's already open‑source, I think the same idea can be reused in other domains, such as cloud computing, Kubernetes, and so on.

I've always wanted to do an explainer of the deployment system and state-tracking at Fly.io using Factorio as a visual metaphor.

I heard you have some free time now, so let's see it!

Re: PGSimCity - How PostgreSQL Works

#22
post #19

It 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.

Re: PGSimCity - How PostgreSQL Works

#24
post #9
post #8

Earlier quoted context omitted.

It's amazing 3D going on, and then 80% of the visual space is popups that completely block it. It'd be have a nice prominent ways of reducing the noise, and that pops were partially transparent.

Yea on mobile especially

I hear you. WIP!

thanks for all the feedback. It's amazing for me too. It all started yesterday with a single prompt and curiosity what Opus 5 can do.

~3.86B tokens used so far (not counting GPT 5.6 Sol that at some point started to do a lot of legwork for coding)

Re: PGSimCity - How PostgreSQL Works

#25
post #3

I love what is trying to be done here. Some feedback to improve would be to cut out a lot of the noise with the "Take tour". There are too many boxes and things changing on the screen to get a sense of what is happening. Also make it interactive rather than automatically switch onto the next subject. Being a passive observer to so much information trying to be conveyed is very confusing. I really do like these kinds…

This is good general advice. If your software needs a "tour," that's a good indicator you should work on your UX instead. If you're just excited to tell the user about a new feature, they'll discover it when they need it.

Re: PGSimCity - How PostgreSQL Works

#26
post #9

Earlier quoted context omitted.

Yea on mobile especially

I hear you. WIP! thanks for all the feedback. It's amazing for me too. It all started yesterday with a single prompt and curiosity what Opus 5 can do. ~3.86B tokens used so far (not counting GPT 5.6 Sol that at some point started to do a lot of legwork for coding)

single prompt Claude Design before putting it in Claude Code

Re: PGSimCity - How PostgreSQL Works

#30
post #3

I love what is trying to be done here. Some feedback to improve would be to cut out a lot of the noise with the "Take tour". There are too many boxes and things changing on the screen to get a sense of what is happening. Also make it interactive rather than automatically switch onto the next subject. Being a passive observer to so much information trying to be conveyed is very confusing. I really do like these kinds…

This is good general advice. If your software needs a "tour," that's a good indicator you should work on your UX instead. If you're just excited to tell the user about a new feature, they'll discover it when they need it.

I think in this case a tour is fine and sort of the point. But I disagree with you generally.
Post reply on HN