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.

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 …

Jan 29, 2013 ·2 min read ·#PostgreSQL #FOSDEM #Conferences

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 …

Jan 28, 2013 ·3 min read ·#PostgreSQL #Common-Lisp #Python #pgloader

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 …

Jan 17, 2013 ·5 min read ·#PostgreSQL #pgloader #catalogs

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 …

Jan 9, 2013 ·4 min read ·#Common-Lisp #Scope #Python #Ruby

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 …

Jan 8, 2013 ·6 min read ·#PostgreSQL #Extensions #9.3 #Templates

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 …

Dec 13, 2012 ·8 min read ·#PostgreSQL #Extensions #9.3

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 …

Nov 22, 2012 ·1 min read ·#Emacs #Ack #Grep

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, …

Nov 20, 2012 ·4 min read ·#Common-Lisp

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 …

Nov 11, 2012 ·8 min read ·#Emacs

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, …

Nov 6, 2012 ·3 min read ·#PostgreSQL #Emacs #pgdevenv-el

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 …

Nov 4, 2012 ·3 min read ·#Common-Lisp

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 …

Nov 2, 2012 ·1 min read ·#PostgreSQL #Conferences #YeSQL