Speaker Deck

PostgreSQL Hearts MongoDB: Querying Mongo with SQL

by David Crawford

Published April 23, 2013 in Technology

Developers are adopting MongoDB like crazy, but the transition isn't always smooth for other teams at the company. PostgreSQL provides a great solution for bridging the gap by allowing SQL users to query live MongoDB data and process it with the PostgreSQL engine. This is done through a new and rapidly evolving feature of PostgreSQL called foreign data wrappers, which lets anyone write an extension to fetch data from an external source.