COSCUP 2024

Playing nice with your friends: database diversity with PostgreSQL FDWs
2024-08-03, 11:30–12:00 (Asia/Taipei), TR409-2

PostgreSQL is the world's most powerful open-source database. Testing it out does not have to be a scary or risky experience. Learn how to use it without making severe changes to your applications.


PostgreSQL is the world's most powerful open-source database. It is easy to set up, but not everyone is comfortable switching to a new database immediately. If your data lives outside of Postgres, and you're not ready to migrate it, you can still use Postgres! Foreign Data Wrappers (FDWs) give you the ability to query external data from within Postgres, just as if it were a regular Postgres table. This talk will discuss all about FDWs and how you can leverage this feature for performance and stability.

Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Software Engineer and Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.

This speaker also appears in: