Distributed
Each device holds a replica (or partial replica) of the database. When changes are made on any device, Delta ensures those changes are propagated to all other devices and merged with their state.Local-first
Our database is stored locally on the device, making it available without an internet connection. When changes are made on any device, those changes are propagated across the network to all other devices. You can also select which portions of the database are relevant to a given device, so they do not need to store the entire database. For example, a microcontroller may only care about sensor readings within the last 10 minutes.SELECT \* FROM readings WHERE date >= current_time - 10 minutes;