tail -f /dev/dim

Two blogs

You're offered two blogs here, tailing the tales of an Emacs user whose job evolves around PostgreSQL. By choice and passion.

PostgreSQL Ideas

Each conference I get to refines some ideas I have about PostgreSQL evolution possibilities, and pop some new ones in my head. This time I decided to write them down.

pg_staging

This tool allow you to leaverage your production backups in order to manage your staging environments (dev, pre-live, snapshots, you name it). Presentation slides included!

prefix indexing

A PostgreSQL extension to speed up prefix routing based lookups. Think telecom routing table, cost computing, etc. Indexing supports for equality lookups, containment and overlapping.

pgloader

The PostgreSQL parallel ETL, writen in python, allows loading plain text files and continue doing so in the presence of errors. Easily extensible to support any input transformation.

Skytools

PostgreSQL master slave asynchronous replication made easy. And I mean it.

Emacs ClusterSSH

Control all your remote hosts interactively from within Emacs. Stop waiting for the windows where to host the terms to be ready...

Emacs Muse blog

Yes, it happens that you find a blog talking about Emacs, made with Emacs, and which tries at looking modern

pgloader, the PostgreSQL parallel ETL, in python

What does mean such a mouthful title? The easiest way to find out about this would be to check out the slides from the first PostgreSQL European Conference, held in Prato. Or to read the following two paragraphs:

The PostgreSQL parallel ETL, writen in python. This little piece of software is a layer atop the PostgreSQL COPY command. The difference between pgloader and plain COPY is the behavior in case of errors in the source data files and the range of input formats supported.

And this little fact that pgloader is able to parallelize its tasks, loading several file at once or even using more than one CPU to load a single source file.

Documentation

The fine manual of pgloader is online at the http://pgfoundry web site.

Tutorial

I should write a pgloader tutorial some day. Maybe.

Examples

Check them out in your distribution of pgloader, or directly browse the pgfoundry CVS web.

Contributions

Any idea or comment is welcome, on the form of a simple mail or documentation or source code patch. Don't be shy!

As a matter of fact, several of the most advanced features of pgloader are in there only because some intrepid user asked for them. Join the fun and be one of them anytime soon.