-
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
Category Archives: Python
Testing Python and PostgreSQL on Windows – Basics
In my previous post, I wrote: Although I have not yet personally run the [Pyrseas] unit tests on Windows …, I believe the tox setup should be quite portable …, since the tests only depend on Python and psycopg2 being … Continue reading
Testing Python and PostgreSQL on Multiple Platforms
I’m working on making the Pyrseas functional tests portable enough so that they can be submitted to the repository. Until now, these tests —which exercise dbtoyaml and yamltodb directly— existed as Linux shell scripts. Briefly, each test runs both dbtoyaml … Continue reading
Database User Interfaces – Pagination
Since it’s been a while from my last post on this subject, let me recap what we’ve covered: Defined a minimal command line interface as a means of exercising the basic Python-PostgreSQL interface. Following Toon Koppelaars’ Helsinki (IT) Declaration, split … Continue reading
Posted in PostgreSQL, Python, User interfaces
Tagged jinja, postgresql, psycopg, python, tornado, user interfaces, werkzeug
Leave a 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
4 Comments
Automated Database Augmentation
Suppose you have a PostgreSQL database like the Pagila sample with 14 tables, each with a last_update timestamp column to record the date and time each row was modified, and it is now a requirement to capture which user effected … Continue reading
Posted in Database tools, PostgreSQL, Python
Tagged andromeda, database augmentation, database automation, database tools, pagila, postgresql, python, triangulum
6 Comments
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
Python Web Frameworks – Application Object
In response to my previous post, someone asked “… what’s the point? How one way is better than the other?” My response was that I’m “not trying to judge these frameworks from the perspective of a developer (at least not … Continue reading
Python Web Frameworks – Development Server
One of the most frequent tasks of a web developer is running the app while it’s being written. So we’ll begin our examination of Python web frameworks by looking at the development servers provided and how does one run the … Continue reading
Python Web Frameworks – Candidates
I’ve been researching web frameworks, partly with a view to writing my own, and thought I’d share my findings. This first post will present the candidates briefly and subsequent posts will delve into particular features. The candidates are presented based on … Continue reading
Design Notes on Database Application Development
I recently took a brief look at web2py since its Database Abstraction Layer (DAL) sounded interesting. After following the tutorials in the Overview chapter, I ended up not delving into DAL. Instead, I revisited Ruby on Rails which I had … Continue reading
Posted in PostgreSQL, Python, User interfaces
Tagged django, nosql, postgresql, python, rails, rant, user interfaces, web2py
26 Comments
