Federation with Foreign Data Wrappers PGDay IT 20131025 Slides: 63 Download presentation Federation with Foreign Data Wrappers PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus. com All rights reserved. Table Virtual Interface Index Virtual Interface SQL/MED <DIGRESSION> EXTENSION S! </DIGRESSION> <PAST> SQL/MED in Postgre. SQL contrib/dblink SQL/MED in Postgre. SQL DBI-Link Time Passes. . . Postgre. SQL 8. 4 Infrastructure Only Postgre. SQL 9. 0 More Infrastructure Postgre. SQL 9. 2 Reads ANALYZE </PAST > <PRESENT > Postgre. SQL 9. 3 WRITES! Wrappers. Lots of Wrappers. <SQL > Oracle My. SQL ODBC </SQL > <No. SQL> Couch. DB Redis </No. SQL> <File> file file_text_array </File> <Creativity> Twitter LDAP S 3 </Creativity> More! PGXN Multicor n <New_Commands> {CREATE | ALTER | DROP} FOREIGN DATA WRAPPER {CREATE | ALTER | DROP} SERVER {CREATE | ALTER | DROP} USER MAPPING </New_Commands> <INTROSPECTION > Remote Partitioning • Expose information_schema. columns. • Create view over them. • Create foreign table generator. </INTROSPECTION > </PRESENT > <FUTURE> <INTROSPECTION > CREATE FOREIGN TABLE (…LIKE. . . ) More and better. </INTROSPECTION > Full SQL/MED Compliance The ever-interesting: Stuff I Never Thought Of </FUTURE> Molte Grazie! PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus. com All rights reserved.