Hacker News new | ask | show | jobs
by nathanwallace 759 days ago
Readers may also enjoy Steampipe [1], an open source tool to live query 140+ services with SQL (e.g. AWS, GitHub, CSV, Kubernetes, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc with other tables. (Disclaimer - I'm a lead on the project.)

1 - https://github.com/turbot/steampipe
1 comments
snthpy 759 days ago
I like steampipe but found the use of postgres a bit heavy for my use cases.

Could you make it run with pg_lite in wasm or DuckDB?

link
nathanwallace 759 days ago
In addition to Postgres FDWs, Steampipe plugins are also available as a SQLite extension [1] or a CLI export tool [2] for lighter weight use cases. (Although a local Postgres has a surprisingly small footprint!) Building plugins as DuckDB extensions would be cool too, but we haven't done that yet.

1 - https://steampipe.io/blog/2023-12-sqlite-extensions 2 - https://steampipe.io/blog/2023-12-steampipe-export

link
snthpy 758 days ago
This is awesome!

I last played with it over a year ago and I see that blog post is from Dec 2023. Looking forward to trying out the sqlite extension.

link
snthpy 758 days ago
DuckDB would be great or accessible through DataFusion!

Looking forward to see what you will build next!

link