203 Articles tagged “PostgreSQL”

We’ve been having the CREATE EXTENSION feature in PostgreSQL for a couple of releases now, so let’s talk about how to go from here. The first goal of the extension facility has been to allow for a clean dump and restore process of contrib modules. As such it’s been tailored to the needs of deploying files on the file system because there’s no escaping from that when you have to ship binary and executable files, those infamous .

It’s hard to read my blog yet not know I’m using Emacs. It really is a great tool and has a lot to compare to PostgreSQL in terms of extensibility, documentation quality and community. And there’s even a native implementation of the PostgreSQL Protocol written in Emacs Lisp. One of the things where Emacs really shines is that interactive development environment you get when working on some Emacs Lisp code. Evaluating an function as easy as a single key chord, and that will both compile in the function and load it in the running process.

As Guillaume says, we’ve been enjoying a great evening conference in Lyon 2 days ago, presenting PostgreSQL to developers. He did the first hour presenting the project and the main things you want to know to start using PostgreSQL in production, then I took the opportunity to be talking to developers to show off some SQL. That slide deck contains mainly SQL language, but some french too, rather than english. Sorry for the inconvenience if that’s not something you can read.

Last week was PostgreSQL Conference Europe 2012 in Prague, and it’s been awesome. Many thanks to the organisers who did manage to host a very smooth conference with 290 attendees, including speakers. That means you kept walking into interesting people to talk to, and in particular the Hallway Track has been a giant success. *Photo by [Oleg Bartunov](http://www.sai.msu.su/~megera/)* I did have the chance to speak several times at that event, and you can get the slides at my Conferences page that I try to keep up to date.

It’s been a long time since I last had some time to spend on the prefix PostgreSQL extension and its prefix_range data type. With PostgreSQL 9.2 out, some users wanted me to update the extension for that release, and hinted me that it was high time that I fix that old bug for which I already had a patch. prefix_range release 1.2.0 I’m sorry it took that long. It’s now done, you can have prefix 1.