Live data from Hacker News

PGSimCity - How PostgreSQL Works

nikolays.github.io

1–10 of 104 posts

Re: PGSimCity - How PostgreSQL Works

#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 of approaches to showing the inner workings of different kinds of tech, so think this is on the good path to being a very useful tool, but needs some focus rather than more data/graphs/info boxes.

Re: PGSimCity - How PostgreSQL Works

#4
This is really cool, I like having visualization to hold on my head!

Also (assuming this is LLM-generated, apologies if it’s not) seems like the future of learning/self-teaching… gonna try and generate similar things for stuff I’m learning

Re: PGSimCity - How PostgreSQL Works

#6
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.

Re: PGSimCity - How PostgreSQL Works

#7
I 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 where to start or where to end.

Re: PGSimCity - How PostgreSQL Works

#8
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…

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.

Re: PGSimCity - How PostgreSQL Works

#9
post #8
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…

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

Re: PGSimCity - How PostgreSQL Works

#10
This is very cool, just some UX tips to make it more legible:

1. remove ~50% of the UI since it covers too much of a laptop screen

2. improve the camera controls so its easier to pan and zoom.

Post reply on HN