From: "Florian G. Pflug" <fgp@...>
Date: 2001-05-04T22:01:35+09:00
Subject: [ruby-talk:14629] Database Abstraction Framework

Hi

Is anyone developing a database abstraction framework at the moment?

I just started with this, but if other already work an this, I would rather
participate in their effort, instead of developing my own thing.

What I though of was not just abstracting the connection handling, and
querying, but to make it unnecessary for the programmer to write
sql-statements (at least for simple queries), and deal with result arrays.


I image somethig like

user = DbTable.new("user")
user.id = 31415
user.find
print "Username: #{user.name}, Password: #{user.password}"
user.password = "new password"
user.store

in case of related tables, this should look like (imagine , each user was
related to a company, where the company_id field specifies the company).

user2 = DbTable.new("User")
user2.id = 1234
user2.find
print "User: #{user2.name} works form #{user2.company.name}"
user.company = DbTable.new("company")
user.company.name = "User2's new employee"
user.store

Actually, the only interface i know (a very little bit) which works (partly)
like this is the db-interface
in visual basic. But of course, this can be implemented in ruby in a much
more elegant way...

greetings, Florian Pflug