4 ms·
Readers who like SQL may also enjoy Steampipe [1], an open source tool to live query 99+ services with SQL (e.g. AWS, GitHub, CSV, Kubernetes, etc). It uses Pos
by nathanwallace 4y ago
Readers who like SQL may also enjoy Steampipe [1], an open source tool to live query 99+ services with SQL (e.g. AWS, GitHub, CSV, Kubernetes, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc across the services. (Disclaimer - I'm a lead on the project.)
1 - https://github.com/turbot/steampipe https://github.com/turbot/steampipe
- mafro 4y ago+1 Steampipe's aggregators to combine multiple datasets into one are great
- sztanko 4y agoVery cool! Is it possible to connect to steampipe via jdbc connector?
- code_biologist 4y agoI presume so: "You can also use psql, pgcli, Metabase, Tableau, or any client that can connect to Postgres."
- nathanwallace 4y agoCorrect - it's just Postgres, so all your favorite clients / tools work as usual. We have docs for a number of example integrations [1] that work with Steampipe CLI (or cloud). 1 - https://steampipe.io/docs/cloud/integrations/overview https://steampipe.io/docs/cloud/integrations/overview
- xrendan 4y agoIs it possible to join those data sources against an existing database like MySQL or SQLServer?
- nathanwallace 4y agoSteampipe runs an embedded Postgres database [1]. One approach would be to connect that Postgres database with other databases using the usual (advanced) techniques like Foreign Data Wrappers [2]? With that connection in place, joins would work as normal. 1 - https://steampipe.io/docs/develop/overview https://steampipe.io/docs/develop/overview 2 - https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://wiki.postgresql.org/wiki/Foreign_data_wrappers