PGCon2017 - 0626

PGCon 2017
The PostgreSQL Conference

Speakers
Keith Fiske
Schedule
Day Talks - Day 2 - 2017-05-26
Room DMS 1110
Start time 11:00
Duration 00:45
Info
ID 1037
Event type Lecture
Track DBA
Language used for presentation English
Feedback

So You Want To Make An Extension?

This talk will discuss the extensions development process from the ground up and expand upon that using my experience developing several widely used projects (pgpartman, mimeo, pgjobmon, etc). The talk will mainly focus on best practices, lessons learned and tips for creating your own software projects in PostgreSQL.

Back in the old days, aka before 9.1, if you wanted to add some custom code to PostgreSQL, it was certainly possible and not very hard. But keeping track of the status of that code, mainly which version the database was running, was a bit of a chore. With the extension system introduced in 9.1, that chore became much less of a hassle. Versioned software packages within the database itself are now possible and installation & upgrades are tremendously easier. In turn, communities like PGXN have grown to house many extensions to make DBA lives easier.

This talk will discuss the extensions development process from the ground up and expand upon that using my experience developing several widely used projects (pgpartman, mimeo, pgjobmon, etc). The talk will mainly focus on best practices, lessons learned and tips for creating your own software projects in PostgreSQL.