Monthly Archives: November 2011

The Phantom of the Database – Part 3

Posted on 28 November, 2011 by

In the previous episode: Alice and Bob were trying to simultaneously update the title of the following row of the film table:   id   |     title      | release_year ——-+—————-+————–  47478 | Seven  Samurai |         1956 User Transaction Correctness In the … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , , | 9 Comments

The Phantom of the Database – Part 2

Posted on 21 November, 2011 by

In the previous episode: Alice, Bob and Carol were trying to simultaneously update the following row of the film table:   id   |     title      | release_year ——-+—————-+————–  47478 | Seven  Samurai |         1956 Alice wanted to remove the extra space … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , | 16 Comments

PGBR 2011 recap

Posted on 14 November, 2011 by

This is a summary of what I saw and heard at PGBR 2011. The night before the conference I had the opportunity to greet Alvaro Herrera, Bruce Momjian, Dave Page and Greg Smith. The conference opened on Thursday 3rd November … Continue reading →

Posted in PostgreSQL | Tagged , | Leave a comment

The Phantom of the Database – Part 1

Posted on 7 November, 2011 by

Scenario: A row with “Seven  Samurai” (notice two spaces between the words) as the movie title and 1956 as the release year, in the film table. Plot: User Alice updates the row to remove the extra space. In the meantime, … Continue reading →

Posted in PostgreSQL, Python, User interfaces, Version control | Tagged , , , | 4 Comments