3 ms·
If you like SQL interfaces then please also checkout Steampipe (https://steampipe.io https://steampipe.io). Use SQL to instantly query cloud resources like AWS
by nathanwallace 5y ago
If you like SQL interfaces then please also checkout Steampipe (https://steampipe.io https://steampipe.io).
Use SQL to instantly query cloud resources like AWS, GitHub, Yahoo Finance, etc (no CSV yet). It's written in Go and uses Postgres Foreign Data Wrappers (similar to SQLite virtual tables).
Disclaimer: It's open source. I'm a lead on the project.
- res0nat0r 5y agoThis looks awesome. Thanks for sharing.
- placidpanda 5y agoThis is really cool. I don't understand something about the architecture though -- you mention it relies on Postgres FDW. When you install Steampipe are you installing Postgres locally and using that, or are you using a remote postgres server?
- nathanwallace 5y agoSteampipe automatically installs and manages an embedded Postgres instance for you. It's shocking how lightweight that is - another way in which Postgres is awesome. Running "steampipe query" will start and run embedded Postgres for the duration of the session. Using "steampipe service start" will run it in the background for access from your favorite 3rd party SQL tool.