Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41688 > unrolled thread

MySQL database schema discovery

Back to article view | Back to comp.lang.python

Contents

  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

#41688 — MySQL database schema discovery

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?

[toc] | [next] | [standalone]

#41689

On 22/03/2013 16:01, Roy Smith wrote:
> 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.
> 

MySQL appears to support the standard(ish) INFORMATION_SCHEMA schema:

  http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

TJG

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web