PostgreSQL's Foreign Data Wrapper

Have you ever needed to write a query that combined data from two PostgreSQL databases? Our client Healthify has. Since Healthify work with healthcare and store some patient information, they’re very careful not to send any personally identifiable information to third party services. One such service is Segment, which Healthify use to track user activity on the site. Conveniently, Segment can send