I’m wondering what libraries are available for accessing the most
comprehensive information for a database schema. In particular, I want
- columns per table
- foreign keys
- column constraints (uniqueness, etc.)
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
Does such a library exist?
Mario T. Lanza