I have been using mysqlcc to manage databases since I came to know MySQL database 6 years ago. I find it so useful because I can use it to
1. manage many databases at the same time.
2. update records manually
3. update data structure manually
4. run sql command
5. monitor SQL server status and view SQL variables
6. List SQL users

However, MySQL AB now decided to stop development on mysqlcc and try to replace it with mysql-administrator and mysql-query-browser. But the new comers suck so much:
1. you need to run 2 applications now to do your usual tasks
2. To update data in mysql-query-browser, you need to click the tiny ‘edit’ switch at the bottom of the window first, then browse to the record, edit the data, click save. while in mysqlcc you just go to the record and modify the data. As soon as the data field is not focused, data is saved automatically
3. they are buggy as well

A coupe of Linux OS release already drop support for mysqlcc:
http://forums.gentoo.org/viewtopic-t-273259-highlight-mysqlcc.html

The final release of mysqlcc by MYSQL AB does not work properly with MySQL 5.0 anymore. I searched google on how to fix the bugs without too much effort and found this within a second:
http://sourceforge.net/projects/mysqlcc/

I downloade a the source file, unzip, compile and fire it up, things are beautiful again!! Need to say yes again to open source. - Ben

Today website is very important marketing tool and sometimes your website is THE core of your business, especially when you are an online retailer. If you decide to design or re-design your website, you need to have a plan 1st and then get a quote.

Read more! »

A study says making the average PC requires 10 times the weight of the product in chemicals and fossil fuels. – BBC
Running it takes a lot of energy as well. Here are some tips for green computing.

Read more! »

1. Register a Domain Name

A domain name is the address of your site. For example, sparkcomputing.co.uk is a domain name. A good domain name is very essential for your business, because you want people to remember the address of your website easily. Furthermore, search engine pay a lot of attention to your domain name. For example, if you are selling mobile phone, you had better to have ‘mobile’ and ‘phone’ in the doman you want to register.

Domain names are paid for yearly and you can register them via Spark computing.

You can get a FREE domain name and a free website from the Internet. However, you might be forced to display some adverts on your website.

2. Purchase Web Hosting Space

A website is actually a collection of files (images, htmls, scripts and database). These physical files must be stored on a ‘Server’ hosted on a commercial data center. A server needs to be on 24/7 to make sure your website is available to the public all time.

3. Web Design Software (Optional)

Some web hosts provide website building tools so you do not need any additional software. It’s important you find out about this before you sign up with any host.

CoffeeCup, Dreamweaver, and HomeSite are three popular web editing software programs that people use to create and maintain their sites.

Avanced users can use a plain text editor to write html codes.
Normally the first file you need to save is the index file. It has be to saved as index.html. If you are using PHP technology, you need to save the file as index.php

If you’re not interested in learning HTML, you can download some free HTML templates from the Internet and modify the text.

4. Selling Products

If you need to sell products online, you need to integrate some ‘payment gateway’ system to your website. The most popular online payment systems are: Paypal, Nochex, and Googlecheckout. They are all free to sign up but you would be charged a percentage of each transaction.

Different payment processing system require different codes to integrate your website. You need to read the manual of Paypal/Nochex/Googlecheckout.

The good news is: PayPal/Nochex/Googlecheckout will give you the HTML code to paste into your site and it automatically creates the payment button and checkout interface for you.

For bigger business, it is more cost efficient by applying a merchant account from your Bank. With this merchant account, you can apply a online payment account from EPDDQ (part of Barclays), Worldpay, or Protx. Epdq/Worldpay/Protx do not force your customer to become a member and therefore it is much more friendly to use.

5. Make your site interesting

If you want to make your site more friendly to Internet users, you can create an online guestbook where people can leave you messages. Or you can create a forum so that you can have your own online coumminty.

All hosting packages from sparkcomputing have already had forum/guest-book/shopping-cart pre-installed.

6. Let everybody knows your site!

Just having a site hosted on a server is only half-job done. A website is a tool for communication. A website is just another product. If you don’t market and promote your website, you would not be able to enjoy all the hard work all alredy done. You’ll need to submit your website to search engines (Google, for example) and directories sites. You will need to embed some keyword in your html pages so that your website is ’search engine friendly’. On a ’search engine friendly’ website, all web pages are written in a way that the search engines can index your web pages easily.

7. Outsourcing programming and graphic design

If your business is going well, your customer will require better service. You probably need to add more features to your site and make your site looks professional.
To implement some feature programming skills are required. You can visit http://www.php.net to have a crash course on how to programming. But most of the time, you would find it much easier just to let the professional programmer to handle it. You need to tell the programmer what exactly you want and the programmer will give you a quote. You need to contact as many programming company as possible to get a good price. However, price is only one factor. You need to make sure they provide friendly service. When someting goes wrong, you want it to be fixed quickly. When new feature is required in the future, you would like to find the same people easily and upgrade your website.

To make your website looks professional, you would need good looking flash animation to decorate your site. Of course, animation is not a must. Some simple images which are consistent to the theme of your website sometimes can enhance your website greatly.

That’s website creation in a nutshell. To find out more details of each section above, I suggest you search the internet for each subject mention aboved.