« Finally upgraded MythTV
Python on Windows XP in 7 Minutes »

MySQL frustrations

So according to Andy’s page, MySQLdb is now obsolete. I tried SQLObject, and while it seems to be pretty cool for creating new databases and managing them, it seems to be a pain to get it to play nicely with existing databases.

All I want to do is query an existing MySQL database and table and get a list of the rows. Is there some easy and non-deprecated way of doing that with Python? What am I missing here?

Update: Doh! MySQLdb is not deprecated, I was just confused. The project is now maintained at SourceForge (which I knew) and was updated as recently as 4/2/2006. The latest version is 1.2.1. See Sebastjan’s comment below.

This entry was posted on Saturday, April 22nd, 2006 at 8:23 pm and is filed under Programming, Python. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “MySQL frustrations”

  1. Sebastjan Says:
    April 23rd, 2006 at 1:51 am

    Why SQLObject? If you check the documentation you will find:

    “Currently SQLObject supports MySQL via MySQLdb”

    And why is MySQLdb obsolete? If you check the project on http://sourceforge.net/projects/mysql-python you can see that it was updated recently so I really don’t get this.
    Latest version of MySQLdb on Andys page is 0.3.5 and on SF 1.2.1. So I think he’s talking about that version, not the one on SF.

  2. John Says:
    April 23rd, 2006 at 9:37 am

    Hey Sebastjan,

    Thanks for setting me straight. I updated the post. :)

  3. Nathan Says:
    April 23rd, 2006 at 9:53 am

    And why is MySQLdb obsolete?

    Uh, wtf. Did you read the post. He was using what that site told him. Which it clearly spells out:

    OBSOLETE Python Interface to MySQL

  4. Sebastjan Says:
    April 23rd, 2006 at 12:17 pm

    No problem ;)

    Uh, wtf. Did you read the post. He was using what that site told him.

    I guess I was not clear enough. I was wondering about the REASON for rendering it obsolete, not why he thought it is obsolete.

Leave a Reply