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 fullOracle 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 fullChange 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 fullThird-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 fullClass-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