Sybase/Web platform issues
Before we make a final decision on this, I wanted to get some additional
feedback (the sooner the better) from anyone who might have gone down this
We are putting together a Web/Sybase interface for a client. The actual
database will be Sybase System 10 running on a Pentium NT. The Web server
will be Netscape's. Queries to the DB are all through stored procedures, so
we have a well-defined set of possible queries and possible results. Writes
to the DB may be (although we'd rather not) asynchronous, and are only
possible for a limited number of items. Our original plan was to use WDB
and Sybperl to access the database. Initially generating all result pages
on the fly, then moving to a page-caching scheme if necessary. Caching
might be done either on a per-query bases, or by pre-generating pages
nightly and on writes.
We have three options for the web-server platform (different machine than
the DB server)
1. Pentium NT
2. Pentium BSDI
3. SPARC Solaris
As I see it, we have the following issues. If there are any more (or less),
I'd love to hear it.
Option 1 (NT)
o Is Netscape's NT server shipping yet?
o ntperl exists, but is sybperl portable?
o And if so, is the same Open Client interface available?
Option 2 (BSDI)
o Is Open Client available for this platform?
o Any other way to access Sybase from perl?
Option 3 (Solaris)
o Open Client is available, sybperl should run, any other issues?
o Any problems with a cross-platform database connection? (Solaris<->NT)
It looks to us like Option 3 is the way to go. But I suspect the client
would prefer PC hardware and/or a non-Unix solution, so we need to fully
explore all the options. Of course they need a decision today.
Kee Hinckley Utopia Inc. - Cyberspace Architects 617/721-6100