Web based databasing

[Garth Meisel]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Now to stumble somewhere I've avoided but don't have the choice to anymore so  
here I go.  Since my question may be opinion oriented when it comes to 
answers, and to avoid any flaming, I welcome any and all opinions privately  
too.  

I run SuSE 8.1 Pro (soon to be 9 Pro),  Apache2 as my web-server.  Which 
database should I use.  It doesn't need to be administered via the web-server 
or tools.  I prefer to make all additions,  changes, deletions and transfers  
at the location or SSH into the location so long as I'm not not wireless.  No 
Windoze needed.  

The database should hold between one and 1 million records.  What is the 
quickest or most stable/secure web-site db for Apache2/Linux.  I guess 
another good word to describe it would be "versatile."
OR, do I need a web based db at all?  Can I write a script that will search a 
file or files as well or quicker?  (site viewer doing the search with tool on 
the site)  
OR, is there a difference between the two anymore?
AND IF both, which is preferred?

The purpose is for viewers of the web-site to be able to search quickly and 
accurately sometimes with more than one search term.  There needs to be 
absolutely NO administration of this db via Apache2 or tools.  All records 
will be adjusted accordingly at the location.  Or is that possible without 
stopping Apache2 during the changing procedures etc?        

One other question, if I only wanted a good db that was accessible by anyone 
on the web (same purpose as above) where they could assign themselves a 
password to delete their record at any time, what would I use?  The search 
feature would still be necessary.

TIA.    
- -- 
Garth Meisel                                      http://www.Webostics.com
GPG fingerprint  95FE F1DE B013 0F98 1135  33F1 390C D9F5 CDAD B92F
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQFABcVyOQzZ9c2tuS8RAsI4AKDs8hBAKLKKeRUEHa6twRK2OSa4bACeLEaS
FDKAPG1OYtY78/jqV/fqFM0=
=ypI6
-----END PGP SIGNATURE-----
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml