-
Recent Posts
Archives
Categories
Tags
adminer alter table andromeda apgdiff autodoc bottle cherrypy concurrency control constraints create table database tools dbdeploy diva django emacs flask git jinja liquibase mako pagila pesto pgfoundry php post facto postgresql psycopg pyramid python pyyaml sqlalchemy test driven development testing tox ttm twisted unittest user interfaces version control versioning web.py web2py webob werkzeug windowsBlogroll
Meta
Tag Archives: concurrency control
The Phantom of the Database – Part 4
At the end of November, I finished the third episode with mild suspense: I suggested that the problem of optimistic “locking” could perhaps be solved in PostgreSQL with something other than extra qualifications, row version numbers or timestamps. Let’s start … Continue reading
Posted in PostgreSQL, Python, User interfaces
Tagged concurrency control, postgresql, python, user interfaces
4 Comments
The Phantom of the Database – Part 3
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 concurrency control, postgresql, python, user interfaces
9 Comments
The Phantom of the Database – Part 2
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 concurrency control, postgresql, user interfaces
16 Comments
