News for hackers. Stuff that matters.
Re:Schema on write is better to live by by infogulch on Saturday August 21, 2021 @10:09PM (#28262275)
Have you heard of steampipe? It's a postgresql foreign data wrapper that exposes apis as virtual tables. It was recently discussed on an hn thread about pg FDW: https://news.ycombinator.com/item?id=28227905

I feel like this is a pretty good strategy, since you can either query from the api directly -- which seems to be surprisingly effective -- and drop down to materialized views if you need to cache the results for heavily repetitive queries.

There are no comments on this comment yet.