Multicorn是一个PostgreSQL9.1+的扩展模块，用于简化外部数据封装开发，允许开发者使用Python编程语言开发。
特性：
Multicorn允许你访问PostgreSQL数据库的任何数据源你可以使用强大的SQL来查询数据任何SQL工具都可以在这些数据源上重用支持的数据源包括：
oracle_fdw–connectstoOracledatabases.mysql_fdw–connectstoMySQLdatabases.tds_fdw–connectstoSybaseandMicrosoftSQLServerdatabases.odbc_fdw–connectstoanyODBCsource.couchdb_fdw–connectstoCouchDBdatabases.redis_fdw–connectstoRedisdatabases.twitter_fdw–fetchesmessagesfromTwitter.ldap_fdw–queriesLDAPservers.file_fdw–accessdatafilesintheserver’sfilesystemandquerythemastables.file_fixed_length_record_fdw–readsflatfileswithcolumnsoffixedwidth.PGStrom–usesGPUdevicestoacceleratesequentialscanonmassiveamountofrecordswithcomplexqualifiers.s3_fdw–readsfileslocatedinAmazonS3.www_fdw–accesseswebservicesasadatasource.示例代码：
createforeigntablegmail("Message-ID"charactervarying,"From"charactervarying,"Subject"charactervarying,"payload"charactervarying,"flags"charactervarying[],"To"charactervarying)servermulticorn_imapoptions(host'imap.gmail.com',port'465',payload_column'payload',flags_column'flags',ssl'True',login'mylogin',password'mypassword');selectflags,"Subject",payloadfromgmailwhere"From"like'pgsql-%'and"Subject"like'%Dailydigest%'limit2;
评论