This [MongoDB][MONGODB] extension implements the PostgreSQL's Foreign Data Wrapper.
The previous version was only read-only, the latest version provides the write capability. The user can now issue insert/update and delete statements for the foreign tables using the mysql FDW. It uses the PG type casting mechanism to provide opposite type casting between mysql and PG data types.
The latest version comes with a connection pooler that utilises the same mysql database connection for all the queries in the same session. The previous version would open a new mysql database connection for every query. This is a performance enhancement.
The latest version will push-down the foreign table where clause to the foreign server. The where condition on the foreign table will be executed on the foreign server hence there will be fewer rows to to bring across to PostgreSQL. This is a performance feature.
The previous version was fetching all the columns from the target foreign table. The latest version does the column push-down and only brings back the columns that are part of the select target list. This is a performance feature.
For installation guide, read installation guidlines.
For usage guide, read usage guidlines.
If you experince any bug and have a fix for that, or have a new idea, create a ticket on github page Before creating a pull request please read the contributing guidlines.
This project will be modified to maintain compatibility with new PostgreSQL releases.
For release notes, read release_notes.
Copyright (c) 2018 Postgres-Connect.
Copyright (c) 2011 - 2016, EnterpriseDB Corporation
Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.
See the LICENSE file for full details.