From: "Mario T. Lanza" <mlanza@...>
Date: 2007-08-20T07:58:11+09:00
Subject: Library for investigating database schemas?

I'm wondering what libraries are available for accessing the most
comprehensive information for a database schema.  In particular, I want
information on:

* columns per table
* foreign keys
* column constraints (uniqueness, etc.)
* indexes

I am not sure if this information is accessible via ActiveRecord (some
is regarding the columns) or via DBI.

I will be using a MySQL database (and have heard about
http://www.tmtm.org/en/mysql/ruby/), but I would rather work with a
generic library providing a standard API that is database agnostic.
Also, I know I can get to this information by querying the database
INFORMATION_SCHEMA directly, but, again, I would rather the library be
oblivious to the underlying database and simply provide the schema
information.

Does such a library exist?

Thanks.
Mario T. Lanza
-- 
Posted via http://www.ruby-forum.com/.