Archive for Software Development

SQL syntax error in phpMyAdmin while create table ?

If you are getting errors when you try to create a table like:

CREATE TABLE `foo` (
`bar` VARCHAR NOT NULL
)

And get a MySQL error:

MySQL said:
You have an error in your SQL syntax near ‘NOT NULL)’ at line 1

Then this probably means that you have forgotten to specify a length for the Varchar type
in the “Length/Values” column,which is a required field.

So, this is wrong:

CREATE TABLE bla (bla VARCHAR NOT NULL);

And this is correct:

CREATE TABLE bla (bla VARCHAR (25) NOT NULL);

Related Posts:

  • No Related Posts

Lynx Browser

Lynx is a text-only web browser used by people to navigate the World Wide Web. Lynx was used by many before the web gained its graphical face, although it is still used extensively today by the visually impaired poeple, people with limited physical abilities and those people with slow Internet connections who don’t want to take the time to load graphics.

Lynx is probably the most popular and widely used TEXT MODE browser on the Internet. It runs on a wide variety of platforms, including Unix, Macintosh and Windows and VMS(Virtual Memory Systems). Lynx is a full-featured browser, which means there is almost no content on the web that Lynx cannot retreive and display, either by itself or by calling on other software designed for the purpose.

Lynx is distributed under the GNU Public License which means it is free for all to use, modify and redistribute as long as it is kept in the public domain. Many people have tweaked Lynx and adapted it for use in their particular environment.

If you use the UNIX shell interface and your access provider offers it, Lynx may be interesting for you since it has a succinct key driven user interface.

Related Posts:

  • No Related Posts

Key Process Area- How To Enhance Process Capability

Key process areas identify the issues that must be addressed to achieve a maturity level. “Each key process area identifies a cluster of related activities that when performed collectively- achieve a set of goals and enhance the process capability”( (The Capability Maturity Model: Guidelines for Improving the Software Process. Addison-Wesley. p. 32.). The KPA areas have been defined to reside at a single maturity level.

The key process areas are the requirements for achieving a maturity level. To achieve a maturity level, the key process areas for that level and the lower levels must be satisfied (or not applicable, such as software subcontract Management when there are no subcontractors).

The specific practices to execute in each key process will evolve as the organization achieves higher levels of process maturity. For instance, many of the projects estimating capabilities described in the software project planning key process area at Level 2 must evolve to handle the additional project data available at Level 3.

Related Posts:

  • No Related Posts

Are you thinking of Windows Vista ?

It took five long years for Microsoft (MS) to launch their new product named Vista.
A lay man may think that MS doesn’t have that expertise with them to provide people with newer versions within a shorter span of time. Also controversy after the release of IE7 instead of its multi-year development, IE 7 offered a very negligible advantage over IE 6 in a key Web technology. The support called off for WIN 98 and other older OS are few things that will have a huge impact on MS.

IDC software research shows that there were 21 million Windows 95 users out there and about 58 million Windows 98 users in the year 2003.Windows Xp may have more than 150 million users world wide.
Now in order to upgrade from your current operating system to Vista MS says that there are some specific requirements.

Windows Vista Capable PC includes at least:
* A modern processor (at least 800MHz1).
* 512 MB of system memory.
* A graphics processor that is DirectX 9 capable.

How are common people going to upgrade their PC for Windows Vista? There are millions of people who are using 128MB of system memory and are happy using it. Non-tech savvy community only uses the computer to check their mails and do some netsurfing and download some stuff. Is Microsoft going to lend a helping hand to the Millions of users who can’t afford to upgrade to Vista. In terms of launch of Vista it may be the biggest in this decade but what does a common man has to do with it if there is no money to upgrade his computer and OS as well.
No anti-virus, spyware, firewalls and their updates. You hardly take any time to set up your computer using Linux also no need to install any special drivers. Setting up an office network printer on Windows can take entire day but with Linux all you require is an IP address and three clicks that’s all.
Don’t you think that Open source software like Linux is a better option instead of the expensive and complicated operating system provided by Microsoft.Windows Xp was released in 2001 and Vista in 2007 but Ubuntu version (Linux) is released every six months. The next operating system after Vista may take another 10 years.

People who have switched completely to Linux say:
They find Linux to be simple and easy to use. Compared to windows troubleshooting with Linux is not at all complex at all and the performance of Linux on their hardware is superior. Linux is also good when it comes to network operating system as with a simple CLI you can use your PC from anywhere.
Even IBM has cancelled their contract with Microsoft as of October this year and has opted for Linux.
Wake up people and think over this seriously. Whether you still want to be with the old fashioned and outdated windows desktop with a hole in your pocket or switch to an Open source which is absolutely free and ready to use operating system like Linux.

Related Posts:

  • No Related Posts

Software Development Related Classic Mistake-Part I

Some projects need to meet a performance result, more often than needed, this can dramatically increase the length of the project’s schedule. Users are more interested in the marketing and development side of a project, and not the more complex features; if you shift your focus more towards complex features, you will end up with a long project schedule.

Even if you do manage to avoid these requirements, the average project spends 25% of it’s lifetime changing it’s requirements; these changes can increase the schedule by up to 25%, this delay can also increase the cost of the project, and can also affect the overall customer satisfaction once the project has been completed.

Many software developers are fascinated by the many new technologies which are always coming out, and they like to test these new technology out in their apps, but most of the time they don’t see the necessity of the new techologies, or why they need to even use them; this type of time wasting can also add time to a project’s schedule.

These mistakes can be easily fixed if a software developer listens to user’s feedbacks, and makes the needed adjustments as per the feedback recieved.

Article by Paul Johnson, CMO, http://www.eTechSupport.net

Related Posts:

  • No Related Posts
« Previous Page« Previous entries « Previous Page · Next Page » Next entries »Next Page »