> No clue what Postgres would manage, but I suspect it would be about an order o... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		runeks on June 6, 2023 \| parent \| context \| favorite \| on: Why SQLite is so great for the edge > No clue what Postgres would manage, but I suspect it would be about an order of magnitude higher latency in the happy case. Unless you’re talking 1 versus 10 microseconds (or less), I don’t think Postgres will have an order of magnitude higher latency. And if we are talking this range, why would it matter for a web app where the client’s latency is almost certainly >1 millisecond?

ripley12 on June 13, 2023 [–]

Because it changes the kinds of things you can build: https://www.sqlite.org/np1queryprob.html

With SQLite, it's often practical to issue several queries in situations where that would be too slow for a traditional client-server database.

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