I am very pleased to announce a project which is very close to my heart. "The biTracker." It uses the PL/SQL Web Toolkit for generating HTML pages which can be used by an organization for its internal needs.

About Pl/SQL (Oracle) Web Toolkit

A programming language now-a-days must be capable of producing web content using HTTP protocol. PL/SQL is no exception, and it does this job in style. Oracle supplies some packages called HTP, HTF etc which can generate HTML content to HTTP stream which can be opened by a browser. The flow of data can be in the following tiers:

PL/SQL Procedure or Package (Database Layer)

Web Server (Middle-Tier)

Browser (Client Side)

As Oracle handles the flow of data from Database Layer to Middle Tier to Client side it gives us time to develop feature rich applications using Database Layer.

Consider the following example:

CREATE PROCEDURE helloworld IS

BEGIN

HTP.htmlOpen;

HTP.print('Hello World');

HTP.htmlClose;

END;

The above procedure as you would have guessed will print the message "Hello World" onto the Browser page. If you know HTML you can takeover from this and build feature-rich HTML pages which are dynamic in nature. (Tip: I used jQuery for making HTML pages dynamic).

About biTracker

The story started some months ago and this application includes the following in its version 0.0.3

Admin Screens for various Master screens

Project, Role, Member, Issue Status

Defect Tracking

Issue Listing, Raise an Issue

Leave Management

Apply for Leave & Leave History

A dashboard which displays a calendar

At this stage this software is not capable of handling every aspect of an organizations need. You may download the source of this from sourceforge

I am looking for peers who can develop/test this and to make it a good internal website.

Disclaimer

This blog contains things about technology that I jot about, keep for my records. Some articles in this blog are not owned by me. They are for my reference only. In older posts the original links may not be there, its not intentional. Thanks for understanding.