Re:Show HN: Steampipe – select * from cloud;
by zzo38computer on Thursday February 25, 2021 @11:18PM
(#26271320)
I 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)?
[ Parent
| on HN ]
Re:Show HN: Steampipe – select * from cloud;
by nathanwallace on Thursday February 25, 2021 @11:47PM
(#26271453)
Joins 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!