tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rai...@ca.ibm.com
Subject Re: AW: Need database recommendation
Date Fri, 24 Nov 2000 16:29:28 GMT


I reccomend IMS, but if your budget is under 4 Million, I'd go with DB2
UDB. You can get
the Personal Edition for free from
http://service.software.ibm.com/cgi-bin/d2w/sdl/segment/input?segment=DM&x=28&y=8

I have been using DB2 with Tomcat and JServ for about a year and a half and
have been very satisfied.

Another option not mentioned is PostgreSQL. Available here:
http://looking-glass.usask.ca:82/
I have used PostgreSQL with PHP in the past. I'm sure that there is a JDBC
driver available too.



Regards,
------------------------------------------------------------------------
Raimee Stevens
DB2 UDB NLV Team - IBM Toronto Lab

Email: raimee@ca.ibm.com   VM: RAIMEE@TOROLAB2
Phone: (416)448-3706   T/L 778-3706  Fax: (416)448-4414


Ralph Einfeldt <ralph.einfeldt@uptime-isc.de> on 11/24/2000 02:58:10 PM

Please respond to tomcat-user@jakarta.apache.org

To:   "'tomcat-user@jakarta.apache.org'" <tomcat-user@jakarta.apache.org>
cc:
Subject:  AW: Need database recommendation




The answer depends on your requirements:
- do you need
     views
     sub selects
     outer joins (which versions)
     transctions
- whats are the requirements in terms of
     reliability (redundancy)
     scalability (performance, datavolume)
- whats is your budget

Some of our expiriences
  mySQL
    The last time we checked, transactions (or
    to be more precise the interface to berkley
    db) was alpha. I think this will take some
    time to become a stable release. It is not
    clear what this mean to the performance,
    because I don't know any result with this
    engine.
    No views. I like to use views to hide some
    complexities of the underlying db model.
    No subselects. This is a very bad thing
    for delete. You have do implement loops
    where you normaly use sub selects.
  Sybase ASA
    Cheapest full featered commercial RDBMS
    for web applications.
    Blobs are just 32K in the current release
    (Although the documentation says something
    different)
  Oracle
    Quite expensive.
    Never the less the db I made the best
    experiences with.
  Interbase
    Some nasty bugs with outer joins

  Cloudscape, InstantDB, Hypersonis SQL
    All thre do not support views

> -----Urspr√ľngliche Nachricht-----
> Von: c cw288 [mailto:cw288@hotmail.com]
> Gesendet: Mittwoch, 22. November 2000 21:00
> An: tomcat-user@jakarta.apache.org
> Betreff: Need database recommendation
>
>
> Hi all,
> We are going to develop an application on apache + tomcat + mod_jk on
> Solaris 8, and we need a database for our application. There
> are lots of
> databases exit, we need some recommendation of which  is easier to
> implement.
>
> Thanks,
>
> Cathy
> ______________________________________________________________
> _______________________
> Get more from the Web.  FREE MSN Explorer download :
http://explorer.msn.com





Mime
View raw message