Database Report

Team:

The database project consists of the following developers Susmita Basu, (Michael Cassidy), Greg Hubbard, Wendy Langer and Project Leader Jan Smith. Con Validas left in May and is now working in London - thanks for helping kick start the group. From July, Michael Cassidy is no longer able to attend CBV on Tuesdays and Fridays due to study and work commitments. He is available to test and meet up occasionally.

Overview

The project commenced in April 2007. Its aim is to design and build a web based database to cover most of Computerbank's work processes. The open source database will cover contact details, sales, user support, free training, computers, inventory and eWaste.

Development tools:  PostgreSQL for the database and the Python framework Django for the web based front end. Subversion is used for the code repository via Google Code for opensource projects.

Phase one of the project covers contacts details, computers and computer sales. Phase two will add inventory and ewaste areas

Completed Tasks (most recent first)

By 8th September:

• Held our first django nano sprint on Fri 1st September.  Wendy and Michael coded together for 5 plus hours in our teams first sprint with myself (Jan) and Paddy (the snoring dog) assisting. A coding sprint is where two or more people pair together on the same piece code in a collaborative problem solving way. Usually sprints run over a couple of days but because of the shorter time frame we called this a nano sprint.The team worked on Wendy's WJContact code. They completed addContacts, added logout, established a search through contacts. Worked until 1.15 am. At this point so we decided to finish a satisfying night.

• As a result of the successful nano sprint, a copy of Wendy's code is now in the Main trunk of our Subversion. Computerbank's SVN  Ideas from the other code in the /misc sandbox area will be incorporated when appropriate.
• Started a Functional Testing spreadsheet.
• Ironed out some Subversion problems team members were having.
• Continued work on CSS
  
• Greg reestablished his working environment
• Susmita spent lots of time experimenting with sitemedia and newforms.
• We decided to work on the project at Computerbank on Fridays only. On Tuesdays we work together using irc. This will cut out travelling time for team members.

By 12th August:

• Wendy, Greg, Susmita, Michael and Jan have completed the four Django tutorials.
• Decided to use CSS instead of tables or frames.CSS Discussion
• We spent a week or two reading and honing our CSS skills
• Compiled a list of views we will need in Django CBV views
• Decided not to use Mandrake the development computer at Computerbank as our Subversion Repository. Not all members of the team had external access. This form of access was wasting valuable time.
• Switched over to Computerbank Project on Google Code for our code repository. This means we are independent of the Computerbank network and we can all access the code from our homes.
• Wendy wrote a How-to for Subversion.
• The team have been encouraged to use IRC freenode.net #computerbank for times when we are not at Computerbank.
• Jan is documenting the evolution of Computerbank's Django database project. as a tutorial - Building Computerbank's database with Django
• Wendy compiled a how to on adding CSS and other media to Django. This is incorporated in the tutorial above.

By 2nd July:

• We researched our existing in-house database Rhadam and noted its strengths and weakness.
• We installed and examined the US Free Geek database and reported on its strengths and weaknesses.
• Following on from this research and discussion we have written a draft schema for phase one.
• We trialled the web based Launchpad for our project. We decided the existing beta version of Launchpad was convoluted and lacked some features, so have abandoned Launchpad. We are now using a free web based Google tool called Google Code. We host our Subversion repository with Google code which also has a bug tracker and wiki. We have set up a mailing list with Google groups.
• While we could access our Subversion on Google from our homes we had a problem accessing the web based Subversion at Computerbank. Last Friday Wendy was able to access Subversion from Computerbank. Well done Wendy another teething hurdle solved.
• The team have nearly completed the four Django tutorials.
• We are now confident that Django and Python will be suitable for Computerbank's database needs. It allows different levels of access and different levels of permissions. It nicely sidesteps the need to write SQL statements.
• There was a minor diversion when one team member (who shall remain nameless) suggested that we all had to learn Intercal to complete the backend. After some mad googling of Intercal and Django by some of us, we concluded Intercal is only used by the deranged and desperate and will not be used on this project.
• The team is now ready to start a round trip of phase one.

Further information on this project:

Database Project on Google Code http://code.google.com/p/djangodb

http://vic.computerbank.org.au/Members/jan/building-computerbanks-database-with-django?

Earlier database planning wiki http://vic.computerbank.org.au/wiki/DatabaseProject