Re: Rapid development tool for Web based DB application needed

On Sat, 15 Nov 2003 00:11:09 +0100, Rick Denoire wrote:

> I would consider free tools als well as comercial ones (no complex
> server based systems with feature overkill, if possible).
>
> Using Oracle 8.1.7 and Apache.
>

Morning Rick,

as you are using Apache and 8.1.7, what's wrong with PL/SQL and the DBMS_HTM package ?

[Quoted] There is a 'sort of' RAD in this whereby you use your HTML building RAD tool to build the web pages and use special tags to embed bits from the database. When the page is made, you use the loadpsp commanline utility to convert the HTML into DBMS.HTM calls and the special stuff into calls to the database for data.

I built a front end to an asset trcking system in use at my previous employer using this method (and the Oracle 101 web applications book) as my first ever sorte into the mind numbingly tedious web enabling stuff.

Turned out pretty good.

[Quoted] In defence of loadpsp I have to say that the code it builds is (a) PL/SQL and (b) about as badly written as it gets, however, once I looked at it a couple of times, I figured it out and applied some proper code writing standards to it, I did away with loadpsp and just wrote plain PL/SQL procedures, functions, packages etc and got the job done.

[Quoted] [Quoted] I was usinf the Apache system installed by 8.1.7 by the way - I have heard that there might be problems manually installing mod_plsql into a 'normal' Apache setup.

HTH, Norman.

-- 
Delete the obvious bit from my email address to reply by email.