3 ms·
Show HN: Steampipe – select * from cloud;
- dboeke 6y agoHello HN! Steampipe is an open-source tool for querying cloud metadata with SQL. We currently have 230+ tables across 13 plugins (e.g. AWS, Azure, GCP, GitHub, Zendesk, Slack & more) see the plugin registry for a full list: https://hub.steampipe.io/plugins https://hub.steampipe.io/plugins. Why we think it's cool: * Open source & extensible with plugins * Fast live queries & caching (no ETL to a DB) * Embedded Postgres with a Golang based FDW * Easy to use (well, you be the judge!) We can't wait to see what queries you come up with, and would really appreciate your feedback! edit: format of bullet list
- zzo38computer 6y agoI like this idea, and it is similar to something that I had wanted before (although in my case, what I wanted was mainly for public data without API keys, needing API keys for private data or for writing). But: Are joins with local data supported? Are writes supported? Can it be used with SQLite at all (perhaps this might be possible with a plugin)?
- nathanwallace 6y agoJoins are supported, both between the cloud tables and with local data. Local data can be created in the public schema, which is available for writing & table creation. Writing & updates to cloud tables are not supported. It works using an embedded Postgres instance with foreign data wrappers implemented by Steampipe ... you could try adding SQLite to it as a Postgres FDW. Hope that answers your questions and helps!
- cloudwarrior20 6y agoLooks an awesome innovation here