4 ms·
Thanks! Definitely considering adding a server-mode with Postgres wire protocol compatibility. It's tricky for the more dynamic/dataflow'y parts, as OctoSQL i
by cube2222 4y ago
Thanks!
Definitely considering adding a server-mode with Postgres wire protocol compatibility.
It's tricky for the more dynamic/dataflow'y parts, as OctoSQL is able to give you a live updating output table (which Postgres wire protocol doesn't support), but I can go with a similar approach as Materialize[0] does for those use cases - creating a live-updating materialized view that you can query from.
That said, for now I'm still concentrating on the overall local usage experience and ergonomics, there's still much to improve there.
[0]: https://materialize.com https://materialize.com
- sitkack 4y agoMaterialize is really neat, also checkout https://github.com/mit-pdos/noria https://github.com/mit-pdos/noria. It inverts the query problem and processes the data on insert. Exactly like what most applications end up doing using a no-sql solution.