Live data from Hacker News

PGSimCity - How PostgreSQL Works

nikolays.github.io

91–100 of 104 posts

Re: PGSimCity - How PostgreSQL Works

#91
post #72

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?

Glean anything or learn something in particular? This is a brutalist gew-gah.

Nit, but there's no dash in gewgah.

Re: PGSimCity - How PostgreSQL Works

#93

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.

> I wish there's like a live query thing

There is. "Run a query" at the top nav bar.

Re: PGSimCity - How PostgreSQL Works

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

Re: PGSimCity - How PostgreSQL Works

#95
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)

3.8B tokens, really Billions?

In my case token consumption per week of kinda intense 3 simultaneous projects coding half of the day on Max20 is 55M tokens.

Where do the extra ~2 orders of magnitude come from?

Re: PGSimCity - How PostgreSQL Works

#96

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

Turing Complete taught me how to build a computer and how assembly programming works to the point that I was able to “hackerman” a trivial program on my own ISA in binary.

Re: PGSimCity - How PostgreSQL Works

#97
The limiting factor of your human brain is the same limiting factor the reader has to function with. You can get the LLM to aid in making something, but at a certain level of greebling, [0] it just doesn't feel like it's meant to be experienced by another human being, you know? The sacrifices you'd have to make by NOT building this with an LLM would be made because you COULDN'T fit the mental model of everything going on here in your head. The user has got a similar brain with similar limits.

I'm trying to understand the metaphors here, or how all of the animations and flashing lights are meant to represent something going on, but it all sort of gets lost in the sauce. I'm not sure why a new process is represented by a square that goes through a tube and ends up at a building and then the pinball switch glows red. I click on a thing and a popup says "sessions is the victim" with another paragraph of small text, then disappears a couple seconds later? What?

To be fair, I wont assume this is meant to teach me! Always the possibility of a skill issue on my part and I just lack knowledge here. Taking it at face value as a neat thing, it's neat.

[0] https://en.wikipedia.org/wiki/Greeble

Re: PGSimCity - How PostgreSQL Works

#98

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

how do you know it has been vibe-coded? And why does it matter?

>how do you know it has been vibe-coded?

Another comment mentioned the total number of tokens used, confirmed with the git history. But most importantly : it uses the exact same CSS as every other vibe-coded app, with the same fonts & spacing.

>And why does it matter?

Because I don't want to use nor recommend vibe-coded stuff. Simple enough.

Post reply on HN