Software Tutorials for Visual Learners

After an extensive research we sorted out the top 7 Open Source Server based database management systems, have a look.

PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount of performance optimization to offer the best.

Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates. There is a simple way to use MySQL timestamp data in php.

The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google.

MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.

Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development, a Microsoft official said this week.

MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.

MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL 5.0 New Features series, and this book is the third in that series.

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously:

Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.

To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.

The Test Driver is the "main program" that controls the test. Here is a simple example of a driver that will test the sine function from the standard C library:

A Test Engineer is an information technology (IT) professional who is in charge of one or more technical test activities, including designing test inputs, producing test case values, running test scripts, analyzing results, and reporting results to developers and managers.

Tests can be derived from requirements and specifications, design artifacts, or the source code. A different level of testing accompanies each distinct software development activity

To plan and execute tests, software testers must consider the software and the function it computes, the inputs and how they can be combined, and the environment in which the software will eventually operate.

A small program displays a window with the current system time and date, which can be changed by typing new values into the edit fields as shown in Figure A. The program is terminated by the Alt-F4 keystroke sequence, and the Tab key moves between fields.

'Content Management' has gained a predominant importance after the Web applications took a major part of our lives. What is Content Management? As the name denotes, it is managing the content. How do they work? Let us take a common example.