OctoSQL allows you to join data from different sources using SQL

Databases Big Data Database Tools

Steampipe Landing Page
1

Steampipe

Steampipe: select * from cloud; The extensible SQL interface to your favorite cloud APIs select * from AWS, Azure, GCP, Github, Slack etc.
Pricing:
- Open Source
Yes! There's even a great project built around them to streamline their use, Steampipe[0]. That said, the last time I tried it, it was orders of magnitude slower than OctoSQL. Moreover, reusing the Postgres query engine has its advantages, but it also takes away flexibility you might want to customize the dialect - in the case of OctoSQL, that's i.e. Support for streaming and live updating queries. [0]: https://steampipe.io.

#Big Data #Databases #Big Data Analytics 39 social mentions
OctoSQL Landing Page

2

OctoSQL

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. - cube2222/octosql

#Databases #Big Data #Relational Databases 22 social mentions
Materialize Landing Page
3

Materialize

A Streaming Database for Real-Time Applications
Pricing:
- Open Source
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 experienced and ergonomics, there's still much to improve there. [0]: https://materialize.com.

#Database Tools #Databases #Relational Databases 65 social mentions
DSQ Landing Page

4

DSQ

Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. - GitHub - multiprocessio/dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and ...

#Application And Data #Languages & Frameworks #Shell Utilities 11 social mentions
Apache Calcite Landing Page
5

Apache Calcite

Relational Databases
Pricing:
- Open Source
You should look at Apache Calcite[0]. Like OctoSQL, you can join data from different data sources. It's also relatively easy to add your own data sources ("adapters" in Calcite lingo) and rules to efficiently query those sources. Calcite already has adapters that do things like read from HTML tables over HTTP, files on your file system, running processes, etc. This is in addition to connecting to a bunch of traditional databases including SQL databases, MongoDB, Redis, and several others. Disclaimer: I am a member of the PMC, but not unfortunately not particularly active atm. [0] https://calcite.apache.org/.

#Databases #Data Dashboard #Relational Databases 12 social mentions