PGSimCity - How PostgreSQL Works

872 points84 comments21 hours ago
layoric

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.

show comments
narmiouh

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.

show comments
Curtis_Guan

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.

show comments
willquack

This is very similar to what I imagine whenever I get into a deep focus state debugging a program in gdb... I would love to experience debugging a program in VR with graphics like this,,, there would be no better way to learn a codebase. I wonder how good an experience you could achieve by generating a 3d map based on arbitrary code

seeken

This is really cool to look at. A couple weeks ago I started vibe-coding a Doom for Beam which will allow you to 'run around' a beam VM as a factory floor and see the modules and functions, how they are connected, how 'hot' they are running, and whether they're throwing sparks. I haven't gotten far yet, but I've been wanting to build it to justify getting myself a VR headset.

notachatbot123

Considering that it has been vibe-coded with not even 48 hours passed: Is this truthful and accurate at all? Or will it lead to false conclusions and anti-knowledge?

show comments
arjie

I can't believe "Rendering The First Frame..." is not "Reticulating Splines..." :)

Cool UI.

jedberg

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

show comments
WiSaGaN

I assume this is done with the help of AI? I have done similar vibe project that explaining catastrophic forgetting with the help of AI. It's just so satisfying now that if you really want to learn something, you can always do it with the help of AI. Before, it's hard to find good resources, now it's not a problem, the issue now becomes one's own focus and agency.

dostick

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.

show comments
loveparade

I don't know what I am looking at but it is fabulous.

dbgrman

At first sight, it looks super cool. Kudos for pulling this off. At closer look, feels very overwhelming. The claude tone doesn't help ease the nerves either. The text version is too verbose.

thelastgallon

I wonder if games can be developed to teach CS (OS, db, compilers) which are visual. Instead of reading a book on databases, perhaps tinkering with something like this would make learning easier. (I'm not a gamer, but I read about factorio kind of games on hn).

getfluxly

It's a cool and very educative way to learn. But I wish there's like a live query thing going on so that it'd be easy to understand. I am viewing on the 27" 4K screen and it's perfect for it, like others said, I don't feel there's too much boxes and info at the same time. Although the site is going blank sometimes if I zoom in a bit too much. Really cool nonetheless.

show comments
samayashar

Virtually it's so amazing to see. The layers are clearly separated and it does give a sense of the connections being accepted and processed in the central part.

The operation intricacies are a bit difficult to understand because the core looks a bit clogged up. Nonetheless, great work!

npunt

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.

futurecat

Bravo! I have worked in observability for years and I have a deep desire for new visualizations technics inspired by video games. It would be great in XR as well.

show comments
skreem

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

show comments
harvie

We've got GPU accelerated PostgreSQL sooner than GTA VI...

robertlagrant

I would love this as an active visualisation of a live postgres. Imagine monitors with this stuff on, including replication from other postgresses, and whatever pgbouncer is doing on the front.

manytimesaway

Besides the sadly obvious vibe-coding, just note that SimCity is still an active trademark from EA, so might be good to rename it.

show comments
johnhamlin

UI looks great on a 32" monitor, idk what everyone's complaining about ;)

antoinetouss

I love this, let's do all of Data Intensive Application SimCity!

num42

Really great work! I've always wanted to build a CPU simulator(Full PC simulator) in this style. I still haven't fully figured out my own approach, but this will definitely be an inspiration for me. Thanks for making and sharing it.

gregsadetsky

Great 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)

show comments
antonyragleap

Visualizing MVCC and transaction visibility would make this even more valuable as a learning tool.

BowBun

Amazing, great work. Keep polishing this up!

bazzingadev

Wow, cool projects are so back again

kandros

The logo shape of the platform is a very niche touch, kudos

terra_nera

Anyone else getting Reboot vibes?

LowLevelKernel

Wow. Can’t wait to explore the architecture

deadbabe

Someone should make a movie called “Postgres” which is about people living within a Postgres city, in the style of Se7en.

“Every city has secrets. Ours have indexes.”

svog23

So much stuff to see but looks very cool!

Jonathanfishner

thats cool. n1. spent 15min looking on it rn

someothherguyy

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

npl

Love this

abstrct

This is amazing!

bibimsz

i understood all that.

soulcache

maybe try adding tts to the tour? Lol

luciana1u

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