M
Mario T. Lanza
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
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