So You Want To Make An Extension?
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.