Re: Idea for the future

[John Sechrest <sechrest@peak.org>]

Gerry Hickman <gerry1@dircon.co.uk> writes:


 % > > Yes, a good point and I imagine it would be tricky to support all
 % > > the database variants across a range of platforms.

 % > DBI is a pretty good absrtaction layer for this sort of thing.  Not
 % > great as far as XML is concerned, but fairly transparent for the
 % > rest.

 % Do you know if this would work with Microsoft SQL server?

 % Your PHP idea is certainly interesting and is half way to what I was
 % aiming for in the original post. I guess I could set up a similar system
 % on NT using parsers and ASP, but it's a lot of messing with flat files,
 % hence my preference for the DB approach.


 There are many variations of the database -> glue language -> Web page


 You could use any of the following:

 Database:
     mysql 
     postgres
     M$sql
     sybase
     oracle

 Glue language:
      Perl + cgi
      Perl + asp
      Visual Basic + Asp
      embperl
      jsp
      coldfusion
      miva
      PHP
      C++ + cgi


 DBI is a perl package that is able to hide something of which
 database you are using, so that you can switch between them.

 PHP,coldfusion and such languages are designed to make it "easy"
 to get at data in a database.

 Visual Basic + ASP on NT systems is designed to be able to do the
 same thing. 

 But I have always found NT mail processing to be substandard
 and so I have stayed away from it for this type of thing.

 
 


-----
John Sechrest          .         Helping people use
CEO PEAK -              .           computers and the Internet
Public Electronic         .            more effectively
Access to Knowledge,Inc       .                      
1600 SW Western, Suite 180       .            Internet: sechrest@peak.org
Corvallis Oregon 97333               .                  (541) 754-7325
                                            . http://www.peak.org/~sechrest