News for hackers. Stuff that matters.

A comment on D1: Our SQL database. Parent comment

Re:D1: Our SQL database by simonw on Wednesday May 11, 2022 @11:55AM (#31341772)
Biggest benefit over hosted PostgreSQL is that you get SELECT queries that are measured in microseconds, because SQLite avoids needing network overhead per query.

https://www.sqlite.org/np1queryprob.html

[ Parent | on HN ]
Re:D1: Our SQL database by endisneigh on Wednesday May 11, 2022 @11:57AM (#31341798)
Wouldn’t D1 introduce network overhead?
[ Parent | on HN ]
Re:D1: Our SQL database by simonw on Wednesday May 11, 2022 @12:15PM (#31342019)
Yes for writes, but it shouldn't for reads: it looks like it works by replicating the full database down to each edge location where the code is running.
[ Parent | on HN ]