4 ms·
I guess I’m not understanding what the benefit is vs hosted Postgres. Also low latency and setup can be equally trivial - see supabase for example.
by endisneigh 5y ago
I guess I’m not understanding what the benefit is vs hosted Postgres. Also low latency and setup can be equally trivial - see supabase for example.
- simonw 5y agoBiggest 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 https://www.sqlite.org/np1queryprob.html
- endisneigh 5y agoWouldn’t D1 introduce network overhead?
- simonw 5y agoYes 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.
- jve 5y agoHope this can give you some concrete answers: https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html