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 Magnuer

···


http://fastmail.fm
Any faster and it wouldn’t be email!

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

···

----- 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,