Number Crunching : Database vs OOP

For the last few months I've been working on a project that is part website and part data processing.

In theory the website is the bulk of the project, but in practice processing the data has taken a disproportionate amount of resources.

Data exchange with another organisation is always tricky - and in this case we have incoming data that doesn't conform to specification, business rules that change, and a daily data import to run.

The code I've been working on has been through a couple of versions, and now I have in mind a third

Read more

Software Estimation

cover of Software Estimation Software Estimation: Demystifying the Black Art: The Black Art Demystified (Best Practices (Microsoft))
Steve McConnell
* * * * *
£27.97

buy from amazon

 

This is another great book by Steve McConnell.

His empahsis is on large projects with thourough development processes; he gives many examples of rigorous studes that back up his advice.

If you follow all the advice in this book - you'll be able to make very accurate estimates with a clear idea of the risks involved.

Even if you don't need so much detail - the book provides many tips to greatly improve the accuracy of even rough calculations. 

Read more

Working Effectively with Legacy Code

cover of Working Effectively with Legacy Code Working Effectively with Legacy Code (Robert C Martin)
Michael Feathers
* * * *
£48.22

buy from amazon

 
While waiting for a long database import to run I've been browsing my Safari bookshelf and this book looks really good.

I haven't by any means read the whole thing - but it really seems to have answers to questions I have been asking.

The topic of legacy code is one I have worked with a lot - and it's always challenging.

This book deals well with the technical, business, emotional and social impacts of this work.
With chapter titles like

      Chapter 6. I Don't Have Much Time and I Have to Change It

Read more

Code Complete

cover of Code Complete Code Complete: A Practical Handbook of Software Construction
Steven C. McConnell
* * * * *
£29.95

buy from amazon

 

Don't buy this book!

Read more

Testing websites in IE - verions 6 to 8

When developing a website it's important to test it in as many different web browsers as possible.

If a client has a problem viewing the page there's little point saying "but it works on my machine"

I have found that the differences between different versions of firefox to be small enough that testing in one version is sufficient.

Internet Explorer is so different between versions that each target version must be tested seperately.

There is a package for multiple IEs.

Read more

Debugging Multiple Concurrent Sessions (AJAX/SOAP)

I've recently been working with AJAX and SOAP which both result in multiple sessions running concurrently.

For example if you have an AJAX progress bar for a large file upload one session is uploading the file while a series of shorter sessions check on progress and update the bar.

How to track both parts of this cleanly has had me scratching my head a bit - but the solution is fiendishly simple.

It turns out that there is a buried configuration setting in Eclipse (my IDE of choice) which allows you to debug multiple sessions.

Read more

Drupal and Change Management

Any complex website that needs updating has to be tested without affecting the users of the live site.

The challenge then is how to replicate the changes made on your test site on the live site.

If all the changes are in code then version control systems such as svn and cvs solve this problem very neatly.

But with a CMS such as Drupal some changes are inevitably required in the database.

Managing these changes without affecting the site content can be tricky.

Read more