Re: [Tutor] Help or Advice on MySQL, Python and test data storage

2009-10-14 Thread greg whittier
On Thu, Oct 8, 2009 at 4:29 AM, David Jamieson david.jamie...@gmail.comwrote:

 Hi All,
 looking for some advice on using Python with MySQL for test data
 storage.


While not a relational database, you might also look at
http://www.pytables.org.  It provides a python interface for writing to and
reading from hdf5 files (http://www.hdfgroup.org/HDF5/).
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help or Advice on MySQL, Python and test data storage

2009-10-08 Thread David

David Jamieson wrote:

Hi All,
looking for some advice on using Python with MySQL for test data
storage. What builds of Python work well with MySQL and what modules
allow the connection to the database and data transfer activities.


SQLAlchemy is one option;

http://www.rmunn.com/sqlalchemy-tutorial/tutorial-0.1.html


--
Powered by Gentoo GNU/Linux
http://linuxcrazy.com
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help or Advice on MySQL, Python and test data storage

2009-10-08 Thread Serdar Tumgoren
 looking for some advice on using Python with MySQL for test data
 storage. What builds of Python work well with MySQL and what modules
 allow the connection to the database and data transfer activities.

You'll need the MySQLdb module to connect to MySQL from Python.
http://sourceforge.net/projects/mysql-python/

According to its sourceforge page, the module supports:
MySQL versions 3.23-5.1; and Python versions 2.3-2.5 are supported.

One of the reviews on the page says it also works with Python 2.6.

 I'm thinking about using PhPMyAdmin to set-up and administer my
 database in the first instance until I get going with the project,
 though I could create tables using the commandline option. Is there a
 Python equivalent to PhPMyAdmin?

If you already know how to use phpMyAdmin and it serves your needs,
why not just stick
with it?

Another option is MySQL's database management tools:

http://dev.mysql.com/downloads/gui-tools/5.0.html

I don't believe these can administer remote databases, but you'll
want to check the docs on that to be sure. I've only used them on a local
machine, and they worked fine for that purpose.

HTH,
Serdar
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor