I'm tempted to create a website curating video game stories like this one.

I recently went through it from start to finish as an adult and found it an incredible slog to get through. The puzzles, to me, made zero sense, which sucks the fun out of the game because the only possible way to solve them is to just try everything with everything or to look up the solution.

The latest Monkey Island. Now THAT's how you make a point-and-click adventure game!

That is the difference between Gilbert's game design versus Schafer's. I much prefer Gilbert.

I love the world, the characters, the music, and the art style. It was so inspiring for me as a child.

I literally hate the puzzles and the gameplay.

Comments URL: https://news.ycombinator.com/item?id=49512021

Points: 3

# Comments: 2

A modern database client with dashboards, saved queries, workflows, and yes, AI built into it.

I've focused on building brilliant UX over the last year, and it has paid off. I've had two emails saying that they have cancelled their Jetbrains subscription for DataGrip which has been so validating.

It's been a labour of love and I'm super happy to have disrupted even a small part of the ginormous market that is database clients.

[1] https://dbpro.app

These one-shot products aren't games. They're barely even demos. I don't even know what to call them. For a mature framework like Phaser to sell-out like this and create a vibecoded platform for vibecoded games is shocking.

https://open.spotify.com/playlist/1rCPATCm4x2l5c5TyzoM54?si=...

Those that did, how true is this music to the original channel's music?

So I built a small social app (Chirp: 50k users, 1M posts, ~2.5M follows) in one SQLite file, put it behind a plain Node server, and load tested it properly: real HTTP, real JSON serialization, autocannon hammering it over sockets. The worst query in the app (home timeline, which joins follows against posts, counts likes, sorts by time) still did 3,654 req/s on an M1 laptop, which works out to 315M requests/day.

The part I didn't expect going in: WAL vs the old rollback journal isn't a minor tuning knob, it's the whole story. Same query, same data, one pragma changed, and p99 read latency goes from 4.4ms to 133ms once you add a writer. That's the "SQLite locks and blocks everyone" reputation, and it's from a database mode most people don't even use anymore.

I also tried to be honest about where it falls over: reads stop scaling once anything writes (page cache invalidation, not lock contention), there's one write lock for the whole DB, and there's no failover if the box dies. Those are real constraints, not disclaimers.

Also benchmarked Node+better-sqlite3 vs Bun+bun:sqlite since I had the harness built anyway. Bun wins on cheap queries, Node wins on the expensive ones. Wasn't expecting a split.

Happy to answer questions on methodology, the STRICT table stuff, or why we ended up building this the way we did.

[1] https://evanhahn.com/prefer-strict-tables-in-sqlite/

Comments URL: https://news.ycombinator.com/item?id=48905491

Points: 46

# Comments: 63

I love HN's (healthy) obsession with SQLite. It's brilliant.

[1] https://www.dbpro.app/blog/sqlite-is-all-you-need

Comments URL: https://news.ycombinator.com/item?id=48794551

Points: 3

# Comments: 0

I have so many thoughts but all I can think is this is the epitome of vibecoded slop.

I've never, EVER, in 18 years of being in this business, seen a software product demo of an emoji doing THAT before...