Hacker News Reader

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)?

View on HN

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!

Reply on news.ycombinator.com