3 ms·
That's interesting. I'm looking to do something similar, but need wire compatibility with postgresql. This allows any postgres client to talk to our service. Di
by neeleshs 3y ago
That's interesting. I'm looking to do something similar, but need wire compatibility with postgresql. This allows any postgres client to talk to our service. Didn't have a lot of luck finding a good "middleware"
- hantusk 3y agoyou could consider hosting an empty postgresql database, compile your code as a postgresql foreign data wrapper and expose it as a view. Nothing is more compatible with the postgres wire protocol than postgresql itself ;) turbot compiles their steampipe plugins in this way. Example: https://github.com/turbot/steampipe-plugin-net https://github.com/turbot/steampipe-plugin-net
- neeleshs 3y agoThat's a good idea and we considered FDW (for this and more stuff), but having a middleware makes it more flexible - FDW has limitations around pushdown with subselects, we are still constrained to a single postgresql instance for execution, when in theory we could parallelize (certain) queries across nodes.
- cipherself 3y agoI think this is probably the missing piece for you? https://github.com/jwills/buenavista https://github.com/jwills/buenavista
- neeleshs 3y agoThanks. This looks promising!