Latest Articles

View : All | June | May | April | Alphabetical:A-Z | Z-A

Comparing Cursor and Set Approaches in Processing Relational Data

by Djoni Darmawikarta | October 2008 | MySQL PHP

MySQL introduced cursor in its release 5. You create a cursor to define a set of rows from one or more table that you want to access row-by-row sequentially. If your need is really to access the rows one at a time then use cursor. But a lot of data processing is actually set processing, and set processing is what relational database is best for.

This article by Djoni Darmawikarta compares cursor approach and set approach using various examples.

Read Comparing Cursor and Set Approaches in Processing Relational Data in full

Oracle SQL Developer Tool 1.5 with SQL Server 2005

by Jayaram Krishnaswamy | October 2008 | .NET

Oracle SQL Developer Tool is a stand alone program that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2.

In the present article by Dr. Jayaram Krishnaswamy the latest version of this tool [Oracle SQL Developer 1.5.0.53, IDE Version: 11.1.1.0.22.49. 33] will be described and some details of how to use this tool with SQL Server 2005 will be discussed. While the default installation is ready to connect to Oracle and Access databases the other third-party products such as SQL Server 2005, MySQL and Sybase require additional JDBC drivers. This article describes how you may connect to SQL Server 2005 and SQLExpress servers using the JDBC drivers. The Scratch Editor interface which accepts an SQL Statement from a 3rd party and translates into PL/SQL code is described. This feature was also available in the earlier version.

Read Oracle SQL Developer Tool 1.5 with SQL Server 2005 in full

Change Control for Personal Projects - Subversion Style

by Gurudutt Talgery | October 2008 | Open Source

Change is a constant companion in our daily routine. Most of what we do is changing (transforming) one work product into another or revising or updating it. We might be transforming requirements into design, design into a prototype, client brief into a story board, idea into a concept document, creating versions of a banner ad, or updating a project plan to reflect progress; the list goes on. In this introductory article by Gurudutt Talgery we will see how we can bring a change management discipline to our work products or personal – not just software – projects with two simple tools on Linux: Subversion and a GUI front-end called eSvn.

Read Change Control for Personal Projects - Subversion Style in full

Third-Party Video Hosting on Drupal Websites

by Aaron Winborn | October 2008 | Drupal Open Source Web Graphics & Video

In this article by Aaron Winborn, we will see how to add third-party video on a site. This article talks about the advantages of third-party video hosting and how it can be achieved on websites by using Drupal. Its also gives a proper insight about the Third-Party Video providers and Embedded Media Field, which helps in hosting video from our own server.

Read Third-Party Video Hosting on Drupal Websites in full

Class-less Objects in JavaScript

by Stoyan Stefanov | October 2008 | AJAX Web Development

Java and JavaScript are very different languages, although the similarity in the names and the similar C-like syntax can confuse people sometimes. In this article by Stoyan Stefanov, let's take a look at one pretty major difference - how objects are created. In Java, you have classes. Then objects, a.k.a. instances, are created based on those classes. In JavaScript, there are no classes and objects are more like hash tables of key-value pairs. Then what about inheritance? OK, one step at a time.

Read Class-less Objects in JavaScript in full
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software