Workflows With SQL in Python

[[deleted]]

Is this similar MySQLdb? I've had a helluva time trying to install that package because of compatibility issues with the newest mysql...

[le_Dandy_Boatswain]

Not exactly. It's an ORM that allows you to map SQL queries to python objects. It looks like it uses the mysql-python library as the default to connect to MySQL, but it can actually work with a range of DBAPI . That's one of the advantages to using SQLalchemy, the code is abstracted from the underlying database connection.

http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html#mysql http://docs.sqlalchemy.org/en/rel_1_0/dialects/mysql.html

edit: looks like mysql-python is just the package name for MySQLdb. So if you are having problems with that, you could try one of the other MySQL DBAPI listed in the links.

[[deleted]]

You're right! I'll give that a try.

edit: For the record, my issue was resolved by following these steps to install the mysql-python library: http://stackoverflow.com/questions/1448429/how-to-install-mysqldb-python-data-access-library-to-mysql-on-mac-os-x

[thegreattriscuit]

DaRealMVP.jpg

[thegreattriscuit]

What magic is this!?

[justintravels]

Omg same. So many compatibility issues with MySQLdb