But doing this in a classic database would be insanely expensive. It would basically mean re-running multi-MB complex joins over and over, anytime ~any row changes. Worse, since every user has their own permissions, when a single row changes ALL users' queries must be recalculated. - ThreadSky

aaronboodman.com • 9 days ago

But doing this in a classic database would be insanely expensive. It would basically mean re-running multi-MB complex joins over and over, anytime ~any row changes.

Worse, since every user has their own permissions, when a single row changes ALL users' queries must be recalculated.

Comments

aaronboodman.com•9 days ago

IVM has been an area of active development in backend databases, most recently by projects like https://www.feldera.com/ and https://github.com/mit-pdos/noria.

We took these same ideas and applied them to sync.

aaronboodman.com•9 days ago

The end result is a really fun way to build web apps.

You do a query direct from the client. Zero answers the query and keeps it up to date efficiently.

But better, if you do another query that overlaps with the first, Zero reuses the already synced data to answer the new query ✨instantly✨.

aaronboodman.com•9 days ago

And, because the data is local, you can *mutate* it. Zero provides a synchronous local write API. Write directly to the client-side data and the UI updates *instantly*. Changes are synced to the server in the background. Conflicts are resolved with https://www.gabrielgambetta.com/client-side-prediction-server-reconciliation.html.

aaronboodman.com•9 days ago

Try it out yourself:

https://bugs.rocicorp.dev/

We made our own Linear-style bug tracker with Zero as a dogfood, and have used it as our actual bug tracker for months.

aaronboodman.com•9 days ago

Zero is currently in alpha but it's maturing fast. We already have a few customers in production :).

There's some really cool stuff coming up feature-wise and from there we plan to go to beta over the summer.

Curious? Adventurous? Learn more at https://zerosync.dev.

kraenhansen.dk•9 days ago

This feels awesome and fast 🔥 Congrats! IVM sounds really interesting and I'd love to learn more about what goes into that on a technical level.

juliusv.com•1 hour ago

Question: when using zero, is there anything tying me to also use zero for the write path (https://zero.rocicorp.dev/docs/writing-data)? The right replication log stuff should also arrive at the zero backend if I go around it for writes, right?

Comments

Posting Rules

Reply