Startup in 7 Days – Day four (Build it)

Start up in 7 days series:

Even without knowledge of how a website works, you can manage the construction of one.  All you need is three key elements: your mood board, an understanding of the data and a user experience map.


The first thing was to understand the scope or context of the problem.  Using crude stick figures in my notebook I scribbled down the two ways users would interact with AutoCarLog and made note of the blocks which were outside of my control.

User > website > database

User > mobile > SMS gateway > database (subject for Saturday’s Blog)

In order to maximize my efficiency I needed to understand the relationships between each block.  These are; the user interaction with the website (user experience) and the website interaction with the database (database design).

If you’re going to hire someone to do your development, a good understanding of these two elements will mean you can save time (and money) by giving them a head start.

Keep it simple

Before getting stuck into some design, I took a step back and asked if I could build the service I wanted using (and perhaps modifying) an off-the-shelf-product.  For AutoCarLog? No. There were too many unique features which would mean that it would take longer to modify an existing system then it would to develop a new one, however that’s not always the case.

Take a look at your context diagram.  If you only have three elements “user > website > database”, then chances are you can use an off-the-shelf product.

There are many template-able free products you could use such as wordpress and Drupal.  Have a look at these, and the available plugins before you dive into building your own, no point in re-inventing the wheel!

User Experience

User design interface

Drawing my user experience

The user experience is something I value highly in every product and service I produce.  One of my products must be intuitive and simple yet offer all the information my customers could ever want.  A good user experience reaches deeper than pretty graphics (which I haven’t even considered yet) and should be done first.

I used a mind map, with the user in the center and explored all the ways I wanted them to interact with the website.  They needed to signup a new account, add new trips to their logbook, manage their account and view and download their completed logbook at the end of the year.

From the mind map, I wrote down a series of network diagrams explaining how a user would fullfill a particular function.  All up I had about 30 of these, here’s the one to add a new mobile number to their account:

Login > click on senders > enter new mobile number > click save

Data in data out

Almost every dynamic website you come across has a database behind the scenes. Twitter, Facebook, eBay, my blog, even Anthill Online has a database driving the content and Google takes it to the extreme with over 1 million database servers.

If you’re going to use someone else to do your code, having a basic understanding will help you discuss the development with them, particularly if you use an online development source.

At the bottom is a photo of the page I used to design the AutoCarLog database.  The blue shows the initial concept, the red is the actual database I created.  From that initial concept I was able to explore the relationships between the data and ultimately build the database.


I’m using Apache, PHP, MySQL for AutoCarLog as I’ve used it extensively in the past and it’s free.  I can also use my existing code modules used in other websites for the common functions (like logging in).

This triad of open source offerings work very well together and are well supported by a massive community with plenty of examples of code online.  There is very little you can’t do with them.

Choosing this combination is also slightly cheaper than some alternatives as the hosting cost won’t be as high (it uses Linux) and there are more developers available – you don’t need to understand the language to take advantage of that fact!


AutoCarLog mood board

AutoCarLog mood board

I now had everything I needed to build my site myself or to get someone to do it for me.  For AutoCarLog I had the skills to do the development myself, but that’s not always the case.  So where to find that someone?

If you have the budget, consider a local business.  There are a lot of them around, so it pays to do your research to get a good quote.  Give them your three key elements so they can give you an accurate estimate.

A more hands on (and cheaper) approach is to use an online marketplace such as guru or elance.  Here you publish your requirements and budget and others bid for your work.  Be aware, you need to rule your new employee with an iron fist to ensure you get want you want on time, but in most cases it’s cheap and it’s quick.

Lastly, the thing you need to remember when outsourcing a site is that there are two components to the it: the functional guts and the pretty graphics.  (This blog so far has only considered the functional guts.) So if you’re hiring an individual consider their specialty may be biased towards the functional guts (developer) or the pretty graphics (graphic designer).  Make sure you enquire as to their skills in both areas.

Give it a go

Web development isn’t as daunting as you might think.  There are heaps of tutorials and examples to follow and if you’re a naturally structured person who likes writing things down in lists, then you should be able to pick up code.

I taught myself everything I know about web development by following online guides and just giving things ago.  After just two months I had a basic contact management tool (which I still use).  After just two years I had built an enterprise application driving a business with 30 staff that I sold to my largest competitor, as it was superior to what they had been using for years!

But for me, I’ll do the pretty tomorrow, now on to the functional guts!

Database Design

Designing the database

Post to Twitter

7 Comments to “Startup in 7 Days – Day four (Build it)”

  1. Royce Fullerton 22 January 2010 at 7:54 pm #

    Thanks for sharing your experience in such transparency and detail Seb. I look forward to your new posts everyday. I am planning on doing something similar in size of scope when I have enough time to devote to it.

    Good luck and keep hustlin’!

  2. seb 23 January 2010 at 12:36 am #

    Thank you Royce, and good luck with your venture too! Please get in touch if you need any help to get started!

  3. Rajeev 23 January 2010 at 7:05 am #


    Great concept of doing it in limited time and resources. I can’t wait to see this rolling out and be successful. I know you have done your homework well and not counting that time (LOL). Still, if I could be of any quick help in DB, Drupal etc. let me know.

    Wish you all the best.

  4. seb 26 January 2010 at 11:45 pm #

    Thank you Rajeev, I haven’t got much experience win Drupal but have heard great things about it. Might drop you a line about it!

  5. 26 February 2010 at 5:45 am #

    thanks man becouse you sher ase your project

  6. lmagro 6 May 2010 at 12:14 pm #

    I’m glad you suggest Drupal and WordPress for website development.

    I highly recommend open-source web content management systems as the baseline infrastructure for website development.

    Feel free to share this free guide: How to Build a Website, On a Budget, Without Technical Expertise.
    It introduces the concept of Open-Source CMSs and walks users through deploying DotNetNuke, Joomla! and WordPress. It’s a great resource for starters.


  7. [...] نكمل مع اليوم الرابع من تحدي سباستيان الاسترالي الذي تحدثنا من قبل عنه [...]

Leave a Reply