I feel like we are getting close to something approximating this with an experimental branch of our B2B product. We designed a schema and range of application-

I feel like we are getting close to something approximating this with an experimental branch of our B2B product. We designed a schema and range of application-defined functions that allow for us to use SQLite as a domain-specific language. In addition to domain data, the schema also stores the authoritative view state as well as any intermediate function arguments. The really nice thing about this is all of the support around the edges. You can use SQLite’s EXPLAIN keyword to get an output of how the virtual machine would execute your statements, including any custom functions. You can also trace the result of every command in separate tables for troubleshooting - Each command starts with SELECT so we might as well do something useful with this. It’s a “reflective” approach since the scripts for handing the various events reside in the same database upon when they execute and can be inspected or altered by script execution. There’s also the magic of the WAL. If you are doing everything in the database (presumably because it’s your operating system) then things like incremental replication of state to another computer become trivial.