MySQL database schema discovery

From	roy@panix.com (Roy Smith)
Newsgroups	comp.lang.python
Subject	MySQL database schema discovery
Date	2013-03-22 12:01 -0400
Organization	PANIX -- Public Access Networks Corp.
Message-ID	<kihv84$i03$1@panix2.panix.com> (permalink)

Show all headers | View raw

What are my options for MySQL schema discovery?  I want to be able to
find all the tables in a database, and discover the names and types of
each column (i.e. the standard schema discovery stuff).

PEP 249 doesn't seem to have any discovery methods.  Nor does MySQLdb
appear to have any non-standard extentions for this.  I could probably
do this with SQLAlchemy, but I'm trying to avoid that because it's so
heavyweight.

Is there anything else I should be considering?

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

MySQL database schema discovery roy@panix.com (Roy Smith) - 2013-03-22 12:01 -0400
  Re: MySQL database schema discovery Tim Golden <mail@timgolden.me.uk> - 2013-03-22 16:09 +0000

csiph-web