Puakma: Under the hood

I'm Brendon Upson, jack-of-all-trades, master of one or two. I'm talking about life running a small ISV tackling business issues and leaping technology hurdles in a single bound.

webWise Network Consultants is based in Sydney, Australia and develops the groundbreaking Puakma server technology.


My exploding brain

Filed under: by Brendon Upson on 22:22

For about nine months now we've been working on an application for a customer to manage their construction projects. IT IS AN ABSOLUTE MONSTER! I kid you not. We are about 80% done and the current table count is 32. 32 tables! As the architect of the solution I found it very hard to get my head around how this would all logically fit together. The application basically tracks a project's progress against the quote. Remember we're talking construction projects here so some of the numbers get pretty big (like hundreds of millions). Also the number of items to manage in a quote are in the thousands. Then each month we do a forecast on each item to determine the project's position. Each month thousands of rows are created for each projects as a snapshot of the project's state.

This is easily the most difficult project I've been involved in. I love a good challenge but there were times when I doubted what the client wanted was even possible.


  1. Hi Brendon,
    I can feel your pain. Huge table collection are a pitb. I'm currently trying to wrap my head around a 500 table design for a web enablement project. Aaarrrggg.
    :-) stw

    Comment posted by Stephan H. Wisse on 2005-10-18 00:36:04.0 | mail

Your comment

Protected from spambots!

HTML is allowed
Formatting: Basic formatting can be included like so:
[b]bold[/b] and [i]italic[/i]