4 ms·

> Streaming data isn't static like tables in databases—it's unbounded, constantly updating, and poses significant challenges in managing state. I don't really

> Streaming data isn't static like tables in databases—it's unbounded, constantly updating, and poses significant challenges in managing state. I don't really see the difference between tables & streams. Data in tables changes over time too. You can model a stream as a table with any degree of fidelity you desire. In fact, I believe this could be considered a common approach for implementing streaming abstractions.

pgwhalen 2y ago
When one queries a table though, it's only query at one point in time. Querying a stream implies that your result set is a stream as well, which introduces a whole separate set of complexities to worry about both as an implementor of the query engine and a client.