Web based databasing

[Anton Markov]

Hi Garth,

I think the answer to your question depends on the type of data you plan
to store.  What is this database going to be used for?

For small amounts of information (especially numbers or short character
strings), some sort of database engine (I use MySQL) would be a lot more
effecient.  A database can index the information and quickly search it.

On the other hand, if you are storing large amounts of text, a
file-based system (especially if you run it on a ReiserFS filesystem)
may yield better performance, although I have no experience with such
systems.

If you could give us little more detail such as the purpose of the
database, I could offer more help.

Garth Meisel wrote:
> 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.

-- 
Anton Markov <("anton" + "@" + "truxtar" + "." + "com")>

GnuPG Key fingerprint =
5546 A6E2 1FFB 9BB8 15C3  CE34 46B7 8D93 3AD1 44B4

*** LINUX - MAY THE SOURCE BE WITH YOU! ***
--
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