Hacker Newsnew | past | comments | ask | show | jobs | submit | upmostly's commentslogin

I have a love/hate relationship with Grim Fandango.

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.


Same here, I bought it when it came out in one of those nice carton boxes. It was rather buggy and hard to play without a walkthrough. The characters, the music, the story, the dialog, it's all so memorable and easily makes up for those bugs and hard puzzles. I played the remaster when it came out on PS4 as well, still great, but perhaps that's just the nostalgia.

Agreed. I actually didn't find it buggy when I bought it in 1998. I loved the box art.

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.


Has it happened to you? I had two in one day!


I'm working on DB Pro [1]

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


DuckDB when?


Soon. We're releasing a major update at the end of August and then we'll add support for DuckDB.


Emoji are clear indicators an LLM wrote this post. Ugh.


Unfortunately the Phaser framework has decided to go all-in on this route, and it's really disappointing.

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.


I never had The Weather Channel growing up, but I get to listen to music inspired by it in this fantastic Vaporwave inspired playlist.

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

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


according to the website they played a lot of jazz and instrumental stuff, but I was surprised to see songs by The Smiths, The B-52s, Moby, Smashing Pumpkins, Aphex Twin, R.E.M., Sublime, James Blunt, and Pink Floyd. They must have had a decent budget to license those.


Author here. This started because I read Evan Hahn's STRICT tables post [1] last week and got curious how far "just use SQLite" actually holds up under real load, not toy benchmarks.

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/


Have you read https://www.sqlite.org/howtocorrupt.html? Section 1.2 addresses the exact scenario you wrote about in "Backups are a file copy". You got lucky with your testing, and didn't manage to copy the database in the middle of writing a transaction to the WAL file. Backing up an SQLite database with `cp` can produce corrupt backups if you lose the race condition, an unlikely but possible scenario,

Your later advice about "VACUUM INTO (backupfile)" is good, though: the SQLite manual guarantees that that's safe. But it's not safe to back up with `cp` if there are transactions currently writing to the DB: that has a chance of copying files in an inconsistent state, resulting in a corrupt DB and data loss you don't realize has happened until you restore the backup and find out there are some rows missing, or some rows have an invalid mix of old and new data.


This comment was shadowbanned because an LLM wrote it, and HN uses an LLM detector.


> WAL vs the old rollback journal isn't a minor tuning knob, it's the whole story.

That gave it away for me. I still appreciate the information contained in the reply but it was obvious. FWIW I don’t mind LLM content as long as I’m learning something.


Lots of interesting stuff in your post, thank you for sharing it. But please just write in your own voice - LLMs just make it worse.


I was inspired by this blog post to write "SQLite is all you need" [1]

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

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


Have you thought about integrating Remotion into this?


What do you think the next update will be about..^_~


Just watch out for their license...


Oh!! yeah that can be an obstacle.. no issues, I guess I found Mediabunny at the right time..


This is just awful. Sorry. The page is so busy. Also, why an ai generated picture of a man on a laptop as the background?

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


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: