Recursive Relationships in Databases

One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself. For example, think of an organisational chart for the roles of employees in a company; each employee is managed by a manager, each manager manages 0 or more employees. The records of all the … Read moreRecursive Relationships in Databases

To upgrade or not to upgrade XAMPP 1.7.3

XAMPP is just another package of: Apache HTTP Server, MySQL, PHP + PEAR + Zend Framework, phpMyAdmin, Perl, FileZilla FTP Server, Mercury Mail Server, OpenSSL, Webalizer, etc. like WAMP, EasyPHP (the first of its kind I’ve known), and others: http://en.wikipedia.org/wiki/Comparison_of_WAMPs XAMPP 1.7.3 includes: — Apache 2.2.14 (released in October 2009) and PHP 5.3.1 (released in … Read moreTo upgrade or not to upgrade XAMPP 1.7.3

Class Library as DLL for Business Model to be used in PHP

Just an idea, possibly not a new one, and I promise, it is not another “framework”: Is it worth to create a class library as a DLL for a business model and use that DLL in PHP? What are the advantages and disadvantages? As soon as we say DLL, it is a solution that can … Read moreClass Library as DLL for Business Model to be used in PHP

Creating a CV indexing facility using Oracle Text

Recently, I have struggled to get Oracle Text working on Linux. It was supposed to be a simple addon based on a very simple idea: + already installed Apache 2.2, PHP 5.3, Firebird 2.0; which are working fine + install Oracle 10g Express Edition + create a simple table to store candidate ID and document … Read moreCreating a CV indexing facility using Oracle Text

Emergency check on command-line for Oracle XE

Go to your Oracle binaries folder and export environment variables, if they are not set already. Then, run SQL*Plus command line utility with option /nolog .

I hope this helps some beginners.

Setting up a web application on CentOS (continued)

Before continuing the rest of the installation process we started (/wp/index.php/2009/07/setting-up-a-web-application-on-centos-5-3/), I must mention my appreciation for the “yummy” tool Linux developers provided: yum (.. an automatic updater and package installer/remover for rpm systems). I love using webmin (.. a web-based interface for system administration for Unix) as well. The other day I only clicked … Read moreSetting up a web application on CentOS (continued)

Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices: + master (main report) section includes invoice date, invoice number and details of the customer account such as name and address lines. + … Read moreShow MS Access Subreports With No Data