[grammr]

(Hi! I'm one of the founders of PipelineDB)

PipelineDB will be a standard PostgreSQL extension[0] by release 1.0.0. Currently we're about to release 0.9.7, and each release after that will incrementally factor out PipelineDB into a completely independent PostgreSQL extension.

That's the plan, anyways :) With https://www.stride.io being rolled out under heavy demand, we've got a lot on our plate!

[0] https://github.com/pipelinedb/pipelinedb/issues/1596

[crudbug]

Thanks. The plan looks promising.

Just checked - stride.io , is it pipelineDB admin / user front end as a service ?

I am assuming there is a lot more going on behind the scenes ? Can you talk about the architecture.

[grammr]

Stride is a realtime analytics API built for scale and performance. It allows you to construct networks of continuous processing nodes that either materialize results (think high-throughput aggregation) or fire webhooks ("when this aggregate exceeds this value, POST to a url"). Each node is represented by a continuous SQL query, and nodes can be chained together by "tailing" other nodes.

These processing nodes can be queried and joined on (with SQL) at any time to easily power realtime dashboards and other analytical applications. Check out the original announcement [0] and the Stride docs [1] for more detail.

And to answer your question, no, Stride is not simply a frontend for PipelineDB. While it does use PipelineDB and PipelineDB Cluster extensively, it also uses other systems to provide unique capabilities, and all of this is ultimately synergized behind a dead-simple HTTP API.

We've found that a hosted database isn't actually all that interesting for users nowadays, and near impossible to build a business around because they've essentially become a cheap commodity. So we aim to deliver maximum value to users by nailing one use case (realtime analytics) with a highly focused API that eliminates most of the complexity and decision points you'd encounter when trying to do the same with a generic database.

[0] https://www.pipelinedb.com/blog/announcing-stride-a-realtime...

[1] https://www.stride.io/docs