News for hackers. Stuff that matters.
Re:Creating an advanced search engine with PostgreSQL by samwillis on Wednesday July 12, 2023 @03:10PM (#36700136)
With the move to the "edge" for compute, having your database at the edge reduces latency and basically makes it viable. So the theory is that SQLite read replicas will be the answer to a lot of these plans. See what Fly and Cloudflare are investing in with the edge network and SQLite plans.

On top of that SQLite is now viable in the browser with WASM and the "origin privet file system" api. And so people are increasing looking at moving more state and persistence to the browser with an eventually consistent sync. This is what the "Local First" movement, myself included, are excited about.

Re:Creating an advanced search engine with PostgreSQL by vmfunction on Thursday July 13, 2023 @04:59AM (#36706561)
It is what Deno is doing, by putting what traditionally known as the middleware on the edge with a db (localStore). Essentially emulating the browser stack in some ways. Be very interesting to see different kind of code sharing amongst Deno edge nodes and browser.