Ingres web access

Glenn Reynolds  writes in comp.databases.ingres:

> Hi there
> 
> I think this has been asked before, but is anyone out there using direct
> access into Ingres (with SQL) from web pages (using ICE/ingperl/etc) ???
> 
> Are there any 'live' web sites that use this sort of access ?
> 
> Any feedback about different methods of accessing Ingres would be much
> appreciated !
> 
> TIA
> Glenn Reynolds

Want to see a simplified version of ISQL runing within a web browser?

Then try the SqlRunner demonstration at: 

   http://www.cariboulake.com/demos.html

This demo will work behind every firewall/proxy we have every encountered
as long as you are allowed to download Java applets and you can use sites
with CGI scripts.

There are also examples of using JDBC with servlets, presenting a robust
and scalable way to access Ingres from standard web servers and HTML 
without resorting to resource-heavy CGI.

Now this demo happens to use our products, so I am obviously slanted.

But I think this is a better way to access corporate data via the Web.
Three tier architectures can be nicely accessed from the Internet using
servlet technology.  This permits all business modeling to be down in 
the application server with open interfaces to whatever presentation 
method you wish to use.  Legacy data fits in here too.  

                    |----------------|                   FIRE
                    |Mainframe/Legacy|                   FIRE
                    |    System      |                   FIRE
                    |-------^--------|                   FIRE
                            |                            FIRE
                            ?                            FIRE
                            ?                            FIRE
                            ?                            FIRE
                            |                            FIRE
                     |------V------|                     FIRE
                     |   Business  |   |--------------|  FIRE
 |--------|          |     Logic/  |   | Web Server   |  FIRE
 | Ingres |          | Application |   |  /-------\   |  FIRE
 |  DBMS <----JDBC----> Server(s)  <-skt->| Servlet | <----http----> Internet
 | Server |          |             |   |  \-------/   |  FIRE       HTML/Java
 |--------|          |------^------|   |------^-------|  FIRE       Client
                            |                 |          FIRE
                            s                 h          FIRE
                            k                 t          FIRE
                            t                 t          FIRE
                            |                 p          FIRE
                            |                 |          FIRE
                          Java/            Intranet      FIRE
                         4GL/3GL            HTML/Java    FIRE
                         Clients           Client        FIRE


Pardon the text art.  I'm no Picasso.

Cheers,

Michael Leo            mleo@cariboulake.com        mal@visi.com
Caribou Lake Software  http://www.cariboulake.com  Java/RDBMS/Ingres Solutions
St. Paul, Minnesota    (612) 323-9713
Ingres Q & A
Back to William's Home Page
Email William