From: Ciaran Bradley (ciaran.bradley at domain marine.ie)
Date: Fri 18 Feb 2000 - 16:18:08 GMT
Another approach is to use Oracle WebDb. WebDb allows you to build a
database driven website using only your browser to create it and maintain
it. I'm doing a database driven website for a college project using Oracle
8, WebDb and RH6. We were originally using Java servlets to communicate
between Oracle and Apache but it was taking too long to develop because none
of us had much Java experience so we switched to WebDb and it's great.
WebDb can be configure to use its own listener (a light weight webserver) or
linked to Apache via a cgi. For more information have a look at the Oracle
TechNet site
http://technet.oracle.com/products/webdb/
and these two articles
http://www.oracle.com/oramag/oracle/00-Jan/10webdb.html
http://www.oracle.com/oramag/oracle/99-Nov/69idev.html
You can download Or8/8i and WebDb for free from the TechNet site under a
developer license bit if you want to deploy you have to buy a commercial
license.
Ciaran
Ciaran Bradley,
Irish Marine Data Centre,
Marine Institute
80 Harcourt Street
Dublin 2
Ireland.
> http://www.marine.ie/datacentre/
>
email : ciaran.bradley at domain marine.ie
Tel: + 353 1 4757 100
Fax: + 353 1 478 4988
> -----Original Message-----
> From: Cormac McClean [SMTP:cmcclean at domain ait.ie]
> Sent: Friday, February 18, 2000 5:57 AM
> To: ilug at domain linux.ie
> Subject: [ILUG] Apache and database / text files
>
> Hi,
>
> I am looking into a project which involves Apache being able to
> communicate
> with datafiles, i.e. update, query, etc. I am investigating the following
> approaches:
>
> 1. Apache communicates with Oracle (or other) database, responds to
> browser
> requests to query database, returns data to browser, and updates database
> according to browser data.
>
> 2. Data is stored in text files (csv files), Apache queries and updates
> text files via cgi scripts.
>
> 3. Open Source or Commercial package running on Unix/Linux which will do
> the above.
>
> Based on your experience and expertise, which approach would you suggest?
>
> If Apache can communicate with a database, which software would I use?
>
> If cgi-scripts are to be used, could they be shell scripts, or would I
> need
> to use perl? (currently don't know perl)
>
> If third party software is used, how much configuration would be required?
>
> I am following a direct line of enquiry myself (e.g. O'Reilly's Apache
> book, Linux Programming texts) but if anyone could suggest other texts
> that would be useful it would be appreciated (it's about time I gave
> myself a present of another Linux book!).
>
> Currently running Apache on RH Linux 6.1, also have access to SuSe 6.3
> (running happily at home, must use it to replace Red Hat 6.1 at work)
> and also could use a Unix-based solution.
>
> Many thanks,
> Cormac.
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:05:27 GMT