At Relational IO we have at least three environments where our applications are run: our development desktops and laptops, a bunch of staging/test virtual machines and our production servers. We use DNS in each environment as a way to reduce the amount of duplicate per-application environment-specific configuration related to service discovery. Each of our applications connect to multiple internal services: databases, our mail forwarder, our SSH gateway, etc. Unless these are all running on the...

Read More…

Relational IO is a data marketplace built upon PostgreSQL Foreign Data Wrappers, allowing users to query and analyse data in different formats from different endpoints using SQL. PostgreSQL is a very cool database, in fact it is probably one of the most feature rich open source offerings in the RDBMS space. One feature that has been getting a bit of attention recently is PostgreSQL’s Foreign Data Wrappers (FDW). Both Craig Kerstiens’ blog post on the...

Read More…