File:Center of your dataverse.pdf
Center_of_your_dataverse.pdf (file size: 2.07 MB, MIME type: application/pdf)
PostgreSQL at the centre of your dataverse
A look at the new SQL/MED features in PostgreSQL 9.1 and how they can be used to connect PostgreSQL to any data source.
In this talk I will discuss the new SQL/MED features in PostgreSQL 9.1. We will examine how PostgreSQL can interface with external data sources, including files, web services, and both relational and non-relational databases, and how we may use that ability to our advantage.
Finally, we will review the code behind a simple Foreign Data Wrapper to another database to see how easy it can be to add support for new data sources with just a little C programming experience.
Presented at PG Open 2011, Chicago.
File history
Click on a date/time to view the file as it appeared at that time.
| Date/Time | Dimensions | User | Comment | |
|---|---|---|---|---|
| current | 09:59, 8 November 2011 | (2.07 MB) | Dpage (talk | contribs) | Reverted to version as of 14:43, 17 September 2011 |
| 09:58, 8 November 2011 | (2.07 MB) | Dpage (talk | contribs) | PostgreSQL at the Centre of your Dataverse, presented at PGBR 2011 | |
| 14:43, 17 September 2011 | (2.07 MB) | Dpage (talk | contribs) | PostgreSQL at the centre of your dataverse A look at the new SQL/MED features in PostgreSQL 9.1 and how they can be used to connect PostgreSQL to any data source. In this talk I will discuss the new SQL/MED features in PostgreSQL 9.1. We will examine how PostgreSQL can interface with external data sources, including files, web services, and both relational and non-relational databases, and how we may use that ability to our advantage. Finally, we will review the code behind a simple Foreign Data Wrapper to another database to see how easy it can be to add support for new data sources with just a little C programming experience. Presented at PG Open 2011, Chicago. |
You cannot overwrite this file.
File usage
There are no pages that use this file.
