From: "Hal E. Fulton" <hal9000@...>
Date: 2002-09-11T14:41:12+09:00
Subject: Re: Tips for lightweight db app?

----- Original Message ----- 
From: <coma_killen@fastmail.fm>
To: "ruby-talk ML" <ruby-talk@ruby-lang.org>
Sent: Wednesday, September 11, 2002 12:02 AM
Subject: Tips for lightweight db app?


> I need to build a small "db" app where registered users can submit and
> search among tuples of info on the format (given in Ruby "form"):
> 
> [Date, String, String, [String], [String]]
> 
> The amount of data and number of updates and searches will be low so
> speed is not crucial. Simplicity and security is more important, ie.
> simple for me to implement, small requirements on what needs to be
> installed on the "server", and somewhat secure so that only "members"
> can access and search the info in the db.
> 
> What Ruby-based solutions that can help me with this should I check
> out?
> 
> I know Ruby pretty well but don't now MySQL or some other db's. I'd
> prefer an all-Ruby solution.
> 
> Thanks for any input,

Karsten,

As for security: Hmm. If this is web-based, I'd just 
defer the security to the CGI itself. Ask for a 
password or something. Maybe there's a way you can
even defer it to the webserver. I don't know much
about Apache and nothing about IIS.

I've used DBM and its variants in the past. It's very 
simple, perhaps too much so. But it works fine.

Lately I haven't had access to that on Windows, so I've
wrapped PStore to achieve the same purpose. This is
trivial.

HTH,
Hal