Article Network

All | July | May | May

PHP Data Objects: Error Handling

by Dennis Popel | July 2008 | MySQL Open Source PHP

Most web applications have rather simple error handling strategy. When an error occurs, the script terminates and an error page is presented. The error should be logged in the error log, and the developers or maintainers should check the logs periodically. In this article by Dennis Popel, we will look through the most common sources of errors in database-driven web applications.

  • Server software failure or overload such as the famous "too many connections" error
  • Inappropriate configuration of the application, which may happen when we use an incorrect connection string, a rather common mistake when an application is moved from one host to another.
Read PHP Data Objects: Error Handling in full

Backing Up and Restoring TYPO3 Websites

by Michael Peacock | July 2008 | MySQL Content Management Open Source PHP

All web applications and web servers have security vulnerabilities and there is every chance that our website will be compromised. Most web hosts have their own backup procedures in place, but it is not uncommon for a web host to become victim to an attack, and have problems with a small percentage of its customer backups. Because of this it is very important that we keep backups of our website. In this article by Michael Peacock, we will see how to backup our website and restore it back gain from our backup.

Read Backing Up and Restoring TYPO3 Websites in full

Creating an Analysis Services Cube with Visual Studio 2008 - Part 1

by Jayaram Krishnaswamy | July 2008 | .NET Microsoft

A cube in the context of Business Intelligence is a multidimensional representation of business facts that can be accessed quickly to provide specific information. (This can be accomplished by properly written queries in a relational database, but the overhead involved in processing the query, which may involve a large number of 'joins', is simply not efficient). While a relational model is more suited to OLTP, a different model is necessary for OLAP. Whereas highly normalized tables are a norm for OLTP, the model for OLAP does not require normalization. The SQL Server Analysis Services that supersedes the earlier versions is specifically meant for analyzing data in the archives or in OLTP databases to be retrieved and burnished to provide the 'Intelligence' by mining for facts hidden in the data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.

Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 1 in full

Qmail Quickstarter: Virtualization

by Kyle Wheeler | July 2008 | Linux Servers Networking & Telephony

One of the most interesting extensions to the standard mail setup is that of virtualization. In this article by Kyle Wheeler, let's see the many reasons for wanting to virtualize email services, from hosting multiple domains with different users to simply extending the ability to apply policies to different sets of email. There are three basic techniques that are used with a standard qmail system for attaining different forms of virtualization: qmail's control/virtualdomains file, user-definable address extensions, and running multiple qmail instances on the same system.

Read Qmail Quickstarter: Virtualization in full

Blender 3D: Interview with Allan Brito

by Allan Brito | July 2008 | Open Source Web Graphics & Video

Blender is an open source, cross platform suite of tools for 3D creation, capable of modeling, rendering, and animating 3D environments. Since Blender is completely free, everyone can download and use it immediately in commercial projects. It's not a shareware with limited tools, or time constraints; you can use it freely. In the past few years, the Blender user base has grown significantly. One of the positive aspects of Blender is its size—it is only 10 MB and we can even run it directly from a portable drive. Another great aspect of Blender is that we can use various Operating Systems such as Linux, Windows, and Mac OS X, leaving us the choice of which one to use.

Packt spokesperson Meeba Abraham approached Allan Brito at the heart of this movement to understand his take on the future of Blender.

Read Blender 3D: Interview with Allan Brito in full

Themes in e107

by Theodore S Boomer | July 2008 | MySQL Content Management Open Source PHP

The look and feel of any website is a major factor that drives traffic towards the site. A theme is responsible to give a consistent look and feel to a website. In this article by Theodore S Boomer, we will see how to select and delete themes for e107 websites. We will also have a look at the theme layout and build an understanding of it.

Read Themes in e107 in full

Linux Thin Client : Considering the Network

by David Richards | July 2008 | Architecture & Analysis Linux Servers Networking & Telephony Open Source

Much information already exists concerning methods for deploying networks and hardware. In this article by David Richards, we shall try to clarify differences between using a network with personal computers and thin clients with the help of anecdotes. Certain designs have also proven to be very stable and provide the best possible solution.

Read Linux Thin Client : Considering the Network in full

Installing dotProject

by Lee Jordan | July 2008 | MySQL Open Source PHP

If you already have dotProject installed, you probably don't even need to skim this article, unless something has gone horribly wrong. In this article by Lee Jordan, we will cover the key information you need to know to successfully install dotProject, what to do if things are not working right, and how to avoid common pitfalls and hours of frustration.

Read Installing dotProject in full

Data Profiling with IBM Information Analyzer

by Djoni Darmawikarta | July 2008 | Architecture & Analysis

Data profiling is essentially data mining, but for a different purpose. You mine data to understand, to gain better knowledge about the data. While the more common use of data mining is for gaining the data insights for business purpose (e.g. customer buying characteristics), data profiling is for technical purpose. To be more precise, you do data profiling to gather and analyze the technical metadata characteristics of the data. Information Analyzer, data profiling software from IBM, helps you gain insight into such technical metadata characteristics as, for example, column data type and size (length).

This article is based on a case where a database table grew its size unexpectedly and its initial disk space allocation got strained. Looking at the growth pattern of the table, such as the number of new records (which was not that huge), didn’t give us any clue about the cause of the problem. In this article, Djoni Darmawikarta will step through the Information Analyzer process, run one of its functions called Column Analysis on a simple table (a scaled-down version of the real table), and show how the profiling output help solve the problem.

Read Data Profiling with IBM Information Analyzer in full

Using Lists and Tables with MediaWiki

by Mizanur Rahman | July 2008 | MySQL Open Source PHP

MediaWiki is a special software which is used to design Wikis. For any website, formatting is the key to creative and sophisticated designs. In this article by Mizanur Rahman, we will use advanced formatting components like lists and tables in MediaWiki to add content to a sample website.

Read Using Lists and Tables with MediaWiki in full

Module Development in Joomla

by Joseph L. LeBlanc | July 2008 | Joomla! MySQL Content Management Open Source PHP

Modules in Joomla can always help us to add special functionality or special features to our website. In this article by Joseph LeBlanc, we will see how to create and configure a basic module and centralize data access and output using helper classes. We will also have a look at how to select different display options using layouts.

Read Module Development in Joomla in full

Custom Types in Documentum

by Pawan Kumar | July 2008 | Architecture & Analysis Content Management

In this article by Pawan Kumar, we look at the Custom Types in Documentum. We will see how to manage the custom types by looking at how to create a custom type and modify the custom type. We have also introduced the concept of data dictionary, which stores additional information about custom types.

Read Custom Types in Documentum in full

CherryPy : A Photoblog Application

by Sylvain Hellegouarch | June 2008 | Content Management Open Source

In this article by Sylvain Hellegouarch, we are going to explain how to develop a photoblog application. In the first half of this article, we will review the goals and features of this application from a high-level perspective without going into too much detail. In the second half, we will define the entities that our application will manipulate and introduce the concept of object-relational mappers, which aim at reducing the impedance mismatch between relational database and object-oriented software design. We will briefly present the most common Python ORMs and then develop our application data access layer based on the Dejavu ORM.

Read CherryPy : A Photoblog Application in full

Managing Content in Alfresco

by Munwar Shariff | June 2008 | Content Management Java

Content could be of any type. Using the Alfresco web client application, you can add and modify content and its properties. You can categorize content, lock content for safe editing, and you can maintain several versions of the content. You can delete content and you can recover the deleted content as well.

In this article by Munwar Shariff, we introduce you to the basic features of creating and managing content in Alfresco. Using Alfresco, you can manage any type of documents such as HTML, text, XML, Microsoft Office documents, Adobe PDF, Flash, scanned images, media, and video files.

Read Managing Content in Alfresco in full

Developing a Simple Workflow within SugarCRM

by Dr Mark Alexander Bain | June 2008 | CRM MySQL Open Source PHP

Workflow is about getting the right work to the right people at the right time, repeatedly—and knowing you have done so. Workflow is human-centric. First and foremost, workflow is a human activity that is made by and for those who use it: workflow is something that can easily be handled and understood by human beings.
UK Enterprise Workflow National e-Government Project—Workflow from a Business Perspective

Well, that sounds good, but the problems start to occur when you ask people to consider workflow in their organization, and there are usually a few main issues to deal with:

  • You'll find that people are normally experts in their own fields—there are often very few people who have an overview of the whole process that you're trying to map.
  • Sections of a large organization will often have different ways of carrying out the same overall process.
  • People don't really like to be told how to do their jobs—they especially don't like to have any extra processes imposed on them for now obvious reason—well, would you?
  • Talk of 'improved utilization of resources', 'improved performance monitoring', and such like can soon alienate the staff who are going to be using the system. They'll soon start using terms such as 'Big Brother'.

How you are able to deal with these will depend on your organization and the people that are available to you. At least once you've read this article by Dr. Mark Alexander Bain, you'll know that, once you've overcome those problems, the workflow itself will be easy.

Read Developing a Simple Workflow within SugarCRM 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