-
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 html forms jinja liquibase mako pagila pep8 pesto pgadmin pgfoundry php phppgadmin post facto postgresql psycopg pyramid python pyyaml sqlalchemy test driven development twisted unittest user interfaces version control versioning web.py web2py webob werkzeugBlogroll
Meta
Category Archives: Version control
PostgreSQL Extensions and Pyrseas
Prompted by Peter Eisentraut’s blog post, I’ve finished adding support for PG 9.1 EXTENSIONs to the Pyrseas dbtoyaml and yamltodb utilities. For now, this is only available on GitHub. In order to deal with procedural languages, which are now created … Continue reading
Pyrseas PostgreSQL features: feedback requested
I’ve been considering the missing features of dbtoyaml/yamltodb. Two of those are PG 9.1 features: COLLATIONs and EXTENSIONs. I plan to cover them eventually, but I think I ought to deal first with the remaining pre-9.1 features. ROLEs (as well … Continue reading
Pyrseas/PostgreSQL Feature Matrix
In my last post, I wrote—referring to the state of Pyrseas after version 0.5 is released: The only gaps left are TABLESPACE, GROUP/ROLE and the EXTENSIONs added in PG 9.1. I’m afraid I should’ve double checked the list of 9.1 … Continue reading
Posted in Database tools, PostgreSQL, Version control
Tagged database tools, postgresql, version control
1 Comment
More Database Tools?
It’s been over year since I started blogging on these pages about Pyrseas and version control. In a month it will also be the first anniversary of the initial commit to GitHub. Much code and many words have flown under … Continue reading
Posted in Database tools, PostgreSQL, Python, User interfaces, Version control
Tagged andromeda, database tools, postgresql, python, user interfaces
2 Comments
The Phantom of the Database – Part 1
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 postgresql, python, user interfaces, version control
4 Comments
Quo vadis, Pyrseas?
When I found Andromeda, over a year ago, I was searching for a tool that would help me maintain PostgreSQL tables supporting web sites, somewhat like a Django admin app, but without Django itself since that was not part of … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged andromeda, jinja, postgresql, python, sqlalchemy, user interfaces, version control, wtforms
8 Comments
Version Control for PostGIS
A year ago, I was only trying to “rescue” Andromeda … When I started the Pyrseas project, I was mainly interested in improving on the basic table/column version control of Andromeda. I never thought I’d be adding support for “exotic” … Continue reading
Posted in PostgreSQL, Version control
Tagged andromeda, postgis, postgresql, version control
3 Comments
Database Redesign and User Interface Refactoring
In this series about database user interfaces, until now I’ve focused on a single table with just three attributes. As I did with version control, I’ll be introducing additional entities and attributes and exploring how they could be presented or … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged pagila, postgresql, python, user interfaces, version control
1 Comment
Audit Trails
Back in February, I defined the film table version 0.1 with just three columns: CREATE TABLE film ( id INTEGER NOT NULL PRIMARY KEY, title VARCHAR(32) NOT NULL, release_year INTEGER NOT NULL CHECK (release_year >= 1888) ); It was unclear … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged pagila, postgresql, python, user interfaces, version control
2 Comments
PostgreSQL Version Control Feature Coverage
In a comment to one of my early posts about version control, Peter Eisentraut stated he was “somewhat discouraged because [seeing how fast PostgreSQL develops and adds new features,] I don’t see how a tool like apgdiff can keep up … Continue reading
