Multicorn 是一个 PostgreSQL 9.1+ 的扩展模块，用于简化外部数据封装开发，允许开发者使用 Python 编程语言开发。

特性：

• Multicorn 允许你访问 PostgreSQL 数据库的任何数据源
• 你可以使用强大的SQL来查询数据
• 任何SQL工具都可以在这些数据源上重用

支持的数据源包括：

• oracle_fdw – connects to Oracle databases.
• mysql_fdw – connects to MySQL databases.
• tds_fdw – connects to Sybase and Microsoft SQL Server databases.
• odbc_fdw – connects to any ODBC source.
• couchdb_fdw – connects to CouchDB databases.
• redis_fdw – connects to Redis databases.
• twitter_fdw – fetches messages from Twitter.
• ldap_fdw – queries LDAP servers.
• file_fdw – access data files in the server’s file system and query them as tables.
• file_fixed_length_record_fdw – reads flat files with columns of fixed width.
• PGStrom – uses GPU devices to accelerate sequential scan on massive amount of records with complex qualifiers.
• s3_fdw – reads files located in Amazon S3.
• www_fdw – accesses web services as a data source.

示例代码：

create foreign table gmail (
    "Message-ID" character varying,
    "From" character varying,
    "Subject" character varying,
    "payload" character varying,
    "flags" character varying[],
    "To" character varying) server multicorn_imap options (
        host 'imap.gmail.com',
        port '465',
        payload_column 'payload',
        flags_column 'flags',
        ssl 'True',
        login 'mylogin',
        password 'mypassword'
);

select flags, "Subject", payload  from gmail where "From" like 'pgsql-%'
and "Subject" like '%Daily digest%' limit 2;

您可能感兴趣的文章: