4 ms·

Ever heard of PostgreSQL FDW (Foreign Data Wrapper) and associated community developed extensions ?

• wodenokoto 4y ago
  No, I haven’t.
• cube2222 4y ago
  Yes! There's even a great project built around them to streamline their use, Steampipe[0]. That said, the last time I tried it, it was orders of magnitude slower than OctoSQL. Moreover, reusing the Postgres query engine has its advantages, but it also takes away flexibility you might want to customize the dialect - in the case of OctoSQL, that's i.e. support for streaming and live updating queries. [0]: https://steampipe.io https://steampipe.io
  • truth_seeker 4y ago
    > The last time I tried it, it was orders of magnitude slower than OctoSQL. Any link to blogpost ? what was the use case ?
    • cube2222 4y ago
      I tried the Steampipe CSV plugin on the taxi dataset that is used in the OctoSQL benchmarks. Simple grouping.