- From: Phoebe Couch <Phoebe.Couch@library.ucsf.edu>
- Date: Tue, 17 Sep 1996 17:30:25 -0700
- To: otisg@panther.middlebury.edu (Otis Gospodnetic)
- Cc: www-rdb@w3.org
Do you mean 1 - 10 records, or 1-10 Meg? 1-10 is trivial and perl will do it fast enough to serve out. There are a lot of free databases out there such as msql,postgres,etc. I use illustra here with the C API and it is sufficent here. I support multiple databases with 10+ tables and 1000+ records accessible from the web. I use the http server for the front end security which is in turn controlled by the database. I use transactions to protect data during updates, etc. They have a web product -webblade that I find slow (compare to the C API) and inflexible. It's not free, and the price is going up since Informix bought them. Oracle, Sybase, Informix are not cheap but can do the same things. postgres is huge and I find difficult to set up and use in a production environment. msql is for smaller db, I have not used it myself but my co-worker has. Naviserver(http) comes with a limited illustra license and is free. The other alternative is to use regular text retrieval tools, such as wais, isite, etc, if you don't need to do joins between tables. Phoebe. On Sep 17, 5:45pm, Otis Gospodnetic wrote: > Subject: question :) > Ha ! > > it's alive ! :)) > > great. > now, question - we have a huge database (well, just the data, not the software > yet) of about 1-10 or possibly even more records, with about 10+ > columns/fields for each row/record. > > We would like to put that database on-line and make it accessible from the > Web. We have a public domain database right now, but it appears that that > software isn't fast enough for such a huge database, and doesn't have all the > features that we need. > I was wondering if there are any other relatively cheap or even better, free > software packages that would be able to handle such big databases and lots of > simultaneous users and run on UNIX. > We are looking for something that supports: > > - authentication > - client/server > - _fast_ queries > - ability to update/delete/add entries on-the-fly, so to speak, by talking to > the server. > - popular and supported query language such as SQL > - preferably made for using via WWW... > > I don't know if I'm making much sense and using proper terminology, but hope > you get the point... > > Thanks ! > > Otis > P.S. > is there an archive of this mailing list ? I tried getting more info from the > www-rdb-request@w3.org but the thing never sent me info :( > P.P.S. > thanks for all who responded to my previous dead or alive message ! > >-- End of excerpt from Otis Gospodnetic -- Software Engineer mail: phoebe@ckm.ucsf.edu UCSF Library & Ctr for Knowledge Mgt phone: 415/476-3577 530 Parnassus Avenue, Box 0840 fax: 415/476-4653 San Francisco, California 94143
Received on Tuesday, 17 September 1996 20:18:12 UTC