News for hackers. Stuff that matters.
Re:Understanding Foreign Data Wrappers in Postgres and Postg... by kfdm on Thursday August 19, 2021 @12:19AM (#28230277)
Very neat! Though I notice a particular pet peeve of mine . . .

Under https://steampipe.io/docs/reference/config-files you put everything into ~/.steampipe I'm not a fan of random apps putting a random directory there. I prefer things to use the correct directory for the platform. Example https://specifications.freedesktop.org/basedir-spec/basedir-...

Re:Understanding Foreign Data Wrappers in Postgres and Postg... by nathanwallace on Thursday August 19, 2021 @12:30AM (#28230333)
A completely fair point ... and one we debated at length.

Ultimately we decided that the convenience for users and documentation of a single location outweighed the benefits of following the basedir spec, particularly when deployed across operating systems. We looked at other tools, including terraform [1], in reaching a final decision. FWIW, we do let you customize the location of the "install dir" [2].

Hopefully the benefits of Steampipe outweigh the "peeve" factor in this case <grin>

1 - https://www.terraform.io/docs/cli/config/config-file.html 2 - https://steampipe.io/docs/reference/env-vars#steampipe_insta...

Re:Understanding Foreign Data Wrappers in Postgres and Postg... by kfdm on Thursday August 19, 2021 @12:35AM (#28230356)
Sadly I read that as "Other tools do their own thing so we decided to do our own thing too" :(

Though admittedly, "convenience for users" is a rather tricky thing to define, as you really need to define "which users". I imagine ~/.projectname is easier getting started out, but the long term management is why we (try) to have standard locations for things.

Re:Understanding Foreign Data Wrappers in Postgres and Postg... by nathanwallace on Thursday August 19, 2021 @12:44AM (#28230403)
Agreed. Unfortunately requirements for long term management / large scale deployment aren't a priority until a tool is widely adopted, which is best achieved by keeping it simple. An interesting trade off...
Re:Understanding Foreign Data Wrappers in Postgres and Postg... by kfdm on Thursday August 19, 2021 @12:47AM (#28230423)
All the more reason to handle it sooner when its less painful to do the right thing.