Most of the sites today use databases to organize and arrange their content which also allows users to register and leave comments. Even though databases are fairly commonly used, they are still not well understood. When you use a database on the internet for your website, you shouldn’t go for any database: you should go for concepts built up over decades of database development and proven effective. Here are some of helpful database ideas.

Relational Databases - These are easily the most common databases used now. Here, data is stored in tables. The columns are called fields and the rows are called records. A table can have two fields: firstname and lastname. Here the 'relational' part is in fact noteworthy, though, is when it comes to the way tables in a database relate to the other tables. Each record of each table has an ID number (theoretically known as the 'primary key') which then lets you refer to the record in a new table.

SQL Databases-SQL stands for 'Structured Query Language' and is the most popular language for making queries to relational database systems. A query is basically a way of asking the database to find a record for you that matches the criteria mentioned.

Learning SQL entirely can be complex but that difficulty is helped by the fact that you can have your way by knowing a very few SQL commands as you are unlikely to use many. Some of the common commands are:

CREATE- This command is used to create new database tables. You just tell the database the fields (columns) you want, and the type of data (text, dates, etc.) each field is going to contain.

SELECT- This command is used to search tables. You make use of operators like =, < and > to find the record you want.

INSERT- This command allows you to add new records to the table.

DELETE- This command removes existing rows from the table. This command uses similar syntax as used in the command ‘SELECT’.

Knowing the databases well would help you to sort out any problems, if any arises.
 

If you've been filling any web forms you'll know just how annoying bad forms can be. This is because the people who make them seldom know what kind of people would be filling the data. This article looks at some advice on creating the web forms in a better and effective way.

1. Your visitors are not just Americans!- You would be surprised to see the number of web forms which have only the US as the country of residence. Well keep in mind that your visitors can be from anywhere and not just US. The non-US visitors might find it a bit insulting to be asked to register for something, only to see that the site does not have an option for any other country other than the US.

2. Large Drop-Down lists- It’s been seen that some forms have huge drop-down menus which can be very inconvenient for users. Selecting your option from a huge array of options can be very annoying. Drop down lists that have number of options and requires scroll bars to see all the options are difficult to use and inconvenient – you’d rather allow the user to just type it.

3. Username-already taken, Offer some alternatives- It often happens that the username you are trying to take has already been taken by somebody else. What to do in such case? Just don't say "sorry, this username has already been taken". Come up with some useful suggestions or alternatives that are available.

4. Display Warnings on the Page- There are few things more annoying than websites which pop-up those little alert boxes, creating the annoying ding sound in the process. If there's something which is not filled in properly add the warning to the page itself, beside the area where the information has to be filled preferably with a red font. Don't let your users read a dialog box, click OK, and scroll back up to look and rectify the mistake.

5. Ask what is actually needed- This is a very important advice before you create a web-form. Unless the information the web form is asking for isn't required, don't ask for it. Remember, the longer the time taken to fill your web form the more the user would be frustrated, and more likely not to finish filling the complete web form. You can avoid asking what language the user wants to use – the browser tells that in the HTTP headers. Don't ask which country the user is from – it can be detected from the IP address.