Emacs
Marking whole word
I’ve discovered recently another Emacs facility that I since then use several times a day, and I wonder how I did without it before: C-M-SPC runs the command …
Getting more out of PostgreSQL
Notes on SQL technique, data modeling, and PostgreSQL internals — from the author of The Art of PostgreSQL. New articles are built on the free Lab so you can run every query yourself.
debian
Live Upgrading PGQ
Some skytools related new today, it’s been a while. For those who where at my FOSDEM’s talk about Implementing High Availability you might have heard that I …
Conferences
Another Great FOSDEM
This year’s FOSDEM has been a great edition, in particular the FOSDEM PGDAY 2013 was a great way to begin a 3 days marathon of talking about PostgreSQL with people …
Conferences
A Sunday at FOSDEM
The previous article FOSDEM 2013 said to be careful with the PostgreSQL devroom schedule because one of my talks there might get swapped with a slot on the FOSDEM PGDay …
Conferences
FOSDEM 2013
This year again I’m going to FOSDEM, and to the extra special PostgreSQL FOSDEM day. It will be the first time that I’m going to be at the event for the full …
Projects
pgloader: what's next?
pgloader is a tool to help loading data into PostgreSQL, adding some error management to the COPY command. COPY is the fast way of loading data into PostgreSQL and is …
Projects
Automated Setup for pgloader
Another day, another migration from MySQL to PostgreSQL… or at least that’s how it feels sometimes. This time again I’ve been using some quite old …
Software Programming
Lost in scope
Thanks to Mickael on twitter I got to read an article about loosing scope with some common programming languages. As the blog article Lost in scope references functional …
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 …
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, …