EDB is pleased to announce new releases of MongoDB, MySQL, and Hadoop (HDFS) Foreign Data Wrappers to support the upcoming PostgreSQL 16 release. These Foreign Data Wrappers allow Postgres to connect to Hadoop, MongoDB, and MySQL servers enabling you to view, join, and manage remote data all from Postgres.

Highlights of these releases include:

MongoDB FDW 5.5.1

• Enhancement: Added support for PostgreSQL 16
• Enhancement: GUCs added: enable_join_pushdown and enable_aggregate_pushdown
• Feature: Table/Server level option added: enable_order_by_pushdown

MySQL FDW 2.9.1

• Enhancement: Added support for PostgreSQL 16
• Enhancement: Added operators and functions entries in the default mysql_fdw_pushdown.config file
• Bug: Fixed incorrect quoting in generating EXPLAIN query

Hadoop FDW 2.3.1

• Enhancement: Added support for PostgreSQL 16
• Enhancement: GUCs added: enable_join_pushdown and enable_aggregate_pushdown
• Feature: Table/Server level option added: enable_order_by_pushdown and enable_aggregate_pushdown

To learn more, please visit the GitHub project pages:

MongoDB FDW: https://github.com/EnterpriseDB/mongo_fdw

MySQL FDW: https://github.com/EnterpriseDB/mysql_fdw

Hadoop FDW: https://github.com/EnterpriseDB/hdfs_fdw