My presentation at the 2012 PDXPUG PGDay. It covers the basics of how to create useful extensions to PostgreSQL and distribute them on PGXN—without needing to learn C.

by Dickson S. Guedes

Hello everyone!

I’m proud to tell you that a new version of pgxn_utils was released!

Now you can release a distribution to PGXN in five steps!

First, install it:

gem install pgxn_utils

Second, create your extension, optionally overwrite some defaults:

mkdir $HOME/extensions
cd $HOME/extensions
pgxn_utils skeleton my_extension --maintainer "Dickson S. Guedes"

Third, code!

Fourth, bundle it:

pgxn_utils bundle my_extension
Extension generated at: /home/guedes/extensions/my_extension-0.0.1.zip

Fifth, release it:

pgxn_utils release my_extension-0.0.1.zip
Enter your PGXN username: guedes
Enter your PGXN password: ******
Trying to release my_cool_extension-0.0.1.zip ... released successfully!
Visit: http://manager.pgxn.org/distributions/my_cool_extension/0.0.1

Ah, you can export PGXN_USER and PGXN_PASSWORD if you are tired to type your username and password everytime.

Check this out!.

Aaaand manager.pgxn.org is back and better than ever!

manager.pgxn.org will be going down for an upgrade shortly. Will holler when it’s back.

Validate your META.json: cpan PGXN::Meta::Validator; validate_pgxn_meta META.json META.json is OK

PGCon slides: http://www.pgcon.org/2011/schedule/events/291.en.html

by Dickson S. Guedes

Hello everyone!

This was a productive weekend that allowed me to work on some new features in pgxn_utils and I’m proud to tell you that a new version was released!

Trying to simplify your extension-development life I’ve added two tasks to pgxn_utils: change and bundle. The first one is just a convenient way to change META information about extension, incrementally, the second one is an easy way to archive your extension in a zip file well named.

To install it just type:

gem install pgxn_utils

Or, if you don’t want to install it yet, see it in action on this screencast [3:05].

Work in progress…

I’m working now to simplify the release, creating a task to send bundled file to PGXN.

There are a lot of work to do yet so, please, tell me if you found a bug or have suggestions.

Have a nice code! “:)

The PGCon PGXN talk starts in 17 minutes. http://www.pgcon.org/2011/schedule/events/291.en.html

Sorting @pgxn shirts. #StillSomeExtras

Release an extension on PGXN this week and get an invite to the launch party Friday night at #pgcon.