PostgreSQL
Extensions Templates
In a recent article titled Inline Extensions we detailed the problem of how to distribute an extension’s package to a remote server without having access to its …
Posts
PostgreSQL
Inline Extensions
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 …
Software Programming
M-x ack
I’ve been asked about how to integrate the ack tool (you know, the one that is better than grep) into Emacs today. Again. And I just realized that I didn’t …
Software Programming
CL Happy Numbers
A while ago I stumbled upon Happy Numbers as explained in programming praxis, and offered an implementation of them in SQL and in Emacs Lisp. Yeah, I know. Why not, …
Emacs
About Vimgolf
Following some tweet I found myself desultory watching an episode of the awesome VimGolf in Emacs video series by Tim Visher. Those series are about picking some …
Emacs
Editing SQL
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, …
Software Programming
Concurrent Hello
Thanks to Mickael on twitter I ran into that article about implementing a very basic Hello World! program as a way to get into a new concurrent language or facility. The …
Conferences
PostgreSQL for developers
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 …
Conferences
Another awesome conf
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 …
PostgreSQL
Prefixes and Ranges
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 …
PostgreSQL
Reset Counter
I’ve been given a nice puzzle that I think is a good blog article opportunity, as it involves some thinking and window functions.
PostgreSQL
PostgreSQL 9.3
PostgreSQL 9.2 is released! It’s an awesome new release that I urge you to consider trying and adopting, an upgrade from even 9.1 should be very well worth it, as …