search

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.75k stars 202 forks source link

Can this replace Presto if it has an HTTP server? #284

Open didip opened 2 years ago

didip commented 2 years ago

I am just thinking that OctoSQL can go beyond single machine if it can have a server component.

cube2222 commented 2 years ago

Adding a Postgres-compatible component is a possible direction for the future.

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 does for those use cases - creating a live-updating materialized view that you can query from.

That said, it would still not be high-scale nor distributed, like Presto is.