I mainly was just thinking that for the cases where someone wants to use MySQL as the sqlalchemy backend, perhaps using the pure-python driver might be a better choice than the one that's based on libmysqlclient. Sqlalchemy already supports it, and it's actually well tested - it just has a full-time dev on it now. (I certainly wasn't suggesting that we ditch sqlalchemy. :) The only real change here would be changing the dburi configured to:
mysql+mysqlconnector://<user>:<password>@<host>[:<port>]/<dbname> from mysql://<user>:<password>@<host>[:<port>]/<dbname> If it winds up being a good choice, then great. If not, then great. :) On 11/01/2011 02:54 AM, Christopher MacGown wrote: > In light of the context of the DB api cleanup, and Jesse's desire that > we implement a zookeeper (or zookeeper like) db backend, does it really > make sense to bother with a native Python mysql client? The reason we're > using SQLalchemy at all is that we're not tied to a particular DB server > on the backend, switching to this seems a step backward, especially if > it's untested. > > > Christopher MacGown > Piston Cloud Computing, Inc. > w: (650) 24-CLOUD > m: (415) 300-0944 > [email protected] <mailto:[email protected]> > > On Oct 31, 2011, at 7:12 PM, Monty Taylor wrote: > >> Hey all! >> >> I mentioned this at a little around ODS time, but there is a pure python >> MySQL driver (connector/python) that Geert Vanderlaken (formerly of >> MySQL now of Oracle) wrote. Up until just recently, it's been something >> he's been working on in his spare time. However, Oracle have just >> changed his job so that he can work on it full time. >> >> SO - it seems like given the eventlet fun we have, perhaps giving it a >> try, seeing how it goes and if there are any issues with it reporting >> them back to geert might not be the world's worst thing to try. >> >> FWIW, >> >> Monty >> >> -- >> Mailing list: https://launchpad.net/~nova-database >> Post to : [email protected] >> <mailto:[email protected]> >> Unsubscribe : https://launchpad.net/~nova-database >> More help : https://help.launchpad.net/ListHelp > -- Mailing list: https://launchpad.net/~nova-database Post to : [email protected] Unsubscribe : https://launchpad.net/~nova-database More help : https://help.launchpad.net/ListHelp
