Remix.run Logo
wild_egg 5 days ago

You know, it's ok to say that you're out of your element and don't have direct experience with the thing you're commenting on.

SQLite is easily the best scaling DB tech I've used. I've moved all my postgres workloads over to it and the gains have been incredible.

It's not a panacea and not the best in all cases but it's a very sane default that I recommend everyone start with and only complicate their stack with an external DB when they they start hitting real limits (often never happens)

immibis 5 days ago | parent [-]

> You know, it's ok to say that you're out of your element and don't have direct experience with the thing you're commenting on.

I moved several projects from sqlite to postgres because sqlite didn't scale enough for any of them.

andersmurphy 5 days ago | parent [-]

May I suggest you could have been holding it wrong?

The out of the box defaults for sqlite are terrible for web apps.

immibis 4 days ago | parent [-]

Are you aware of the irony behind saying "You're holding it wrong"? Do you know where that phrase came from?