Federation with Foreign Data Wrappers PGDay IT 20131025

Federation with Foreign Data Wrappers PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. [email protected] 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. [email protected] com All rights reserved.