Re: [Tutor] mySQL and Python
On Wed, Feb 18, 2015 at 7:24 AM, James Chapman ja...@uplinkzero.com wrote: One of my pet hates about this list... This is a tutor list, your question is out of scope. Sure there might be better places to seek answers, and sure maybe the first responder doesn't know the answer, but that's not a reason to respond with that phrase. This list is a called python tutor, not python beginner, even if the large majority of the questions are beginner questions. The fact that people can ask any python related question is one of the things I like about it and wish that other languages had similar lists. I'd like to apologize for the brusqueness in my last reply. In no way did I intend to be unfriendly. I do want to make sure that we stay on mailing list topic. Sometimes I get zealous about this, but that's because if the traffic on the list starts becoming very advanced, it can scare away the very folks we're trying to help. That's something that tends to happen when experts talk to each other. I recommend using the official MySQL connector because it's supported by MySQL and it's continuously developed, which means it won't stop working when you change Python versions, or MySQL versions, and it's documented. I've tried some other MySQL libs in the past that worked OK but were a nightmare when it came to supporting them due to changes in the environment. Ah, I missed this one. Thanks. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
I recommend using the official MySQL connector because it's supported by MySQL and it's continuously developed, which means it won't stop working when you change Python versions, or MySQL versions, and it's documented. I've tried some other MySQL libs in the past that worked OK but were a nightmare when it came to supporting them due to changes in the environment. Ah, I missed this one. Thanks. Hi Beatrice, Following up on James's recommendation, it does look like MySQL Connector should support the latest versions of Python, according to: http://dev.mysql.com/doc/connector-python/en/connector-python-versions.html where it says Python 3.3 and later are supported. So try using the 2.0 version of the Connector. Also, there appears to be a forum specific to MySQL Connector questions hosted by the MySQL folks at: http://forums.mysql.com/list.php?50 and they should be able to give specific help on that software too. That being said, you're welcome to ask questions here! My apologies again for sounding exclusive in my last email. I was trying to express the idea that Tutor might not be the best place to ask MySQL driver installation questions. I was trying to direct you to folks that should be better equipped to answer your questions based on their direct experience. But thankfully, it does sound like we do have a few MySQL-familiar folks on the list after all, so my concerns aren't as valid as I had thought. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
On 18/02/15 15:24, James Chapman wrote: One of my pet hates about this list... This is a tutor list, your question is out of scope. Sure there might be better places to seek answers, and sure maybe the first responder doesn't know the answer, but that's not a reason to respond with that phrase. The point of these responses is two fold: 1) It guides the poster to a more appropriate place to get the answers they need. This list is populated by a large number of beginners who probably can't answer specialised topics and a smaller number of more expert volunteers who are here to answer beginner type questions. It is pot luck whether within that community there exists anyone with the specialised skills needed for any given question. So asking on a specialised forum (or a general forum with more experts) makes sense. 2) Asking too many specialised or deeply technical questions scares off the beginners and newbies that this list is designed to cater for. If they can't understand the content of much of the mails then they assume they must be too stupid to participate or learn. We don't want that to happen. After all the official description of the group says in the very first line: This list is for folks who want to ask questions regarding how to learn computer programming with the Python language and its standard library. It goes on: Folks interested in learning about programming with Python are encouraged to join, as are folks interested in helping others learn. While the list is called tutor, anyone, whether novice or expert, can answer questions. We already have a general interest Python list, the reason for spinning off a separate tutor list some 18(?) years ago was specifically to remove some of the techno-fear that the main list generated for beginners. But we very rarely flat out refuse to answer, we usually just say you'll likely get a better response elsewhere. Which is a simple statement of the facts. -- Alan G List moderator ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
On Wed, Feb 18, 2015 at 9:24 AM, James Chapman ja...@uplinkzero.com wrote: One of my pet hates about this list... This is a tutor list, your question is out of scope. Sure there might be better places to seek answers, and sure maybe the first responder doesn't know the answer, but that's not a reason to respond with that phrase. This list is a called python tutor, not python beginner, even if the large majority of the questions are beginner questions. The fact that people can ask any python related question is one of the things I like about it and wish that other languages had similar lists. I understand the need to warn a questioner that this list *might* not be the best forum for their question; however, I fully enjoy these types of posts as often even if I don't fully understand what is being discussed, I still can cull valuable information. Also, sometimes something *clicks* and I am able to solve an issue that has been baffling me for a while. Plus it gives me thought to what to study in the future... -- boB ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
One of my pet hates about this list... This is a tutor list, your question is out of scope. Sure there might be better places to seek answers, and sure maybe the first responder doesn't know the answer, but that's not a reason to respond with that phrase. This list is a called python tutor, not python beginner, even if the large majority of the questions are beginner questions. The fact that people can ask any python related question is one of the things I like about it and wish that other languages had similar lists. Back to answer the original question... I recommend using the official MySQL connector because it's supported by MySQL and it's continuously developed, which means it won't stop working when you change Python versions, or MySQL versions, and it's documented. I've tried some other MySQL libs in the past that worked OK but were a nightmare when it came to supporting them due to changes in the environment. Download the connector from https://dev.mysql.com/downloads/connector/python/ The latest version should work just fine on Python 3.4 Documentation on how to use it is also available on the MySQL website: https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html Hope this helps. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
On 18/02/2015 23:43, Beatrice Perez wrote: Don't worry, thanks everyone for the reply. I realize that the question was very general but I was looking for pointers which is exactly what you guys have given me. Now I know what to read, where to start. --Beatrice On Wed, Feb 18, 2015 at 9:14 PM, Danny Yoo d...@hashcollision.org wrote: I recommend using the official MySQL connector because it's supported by MySQL and it's continuously developed, which means it won't stop working when you change Python versions, or MySQL versions, and it's documented. I've tried some other MySQL libs in the past that worked OK but were a nightmare when it came to supporting them due to changes in the environment. Ah, I missed this one. Thanks. Hi Beatrice, Following up on James's recommendation, it does look like MySQL Connector should support the latest versions of Python, according to: http://dev.mysql.com/doc/connector-python/en/connector-python-versions.html where it says Python 3.3 and later are supported. So try using the 2.0 version of the Connector. Also, there appears to be a forum specific to MySQL Connector questions hosted by the MySQL folks at: http://forums.mysql.com/list.php?50 and they should be able to give specific help on that software too. That being said, you're welcome to ask questions here! My apologies again for sounding exclusive in my last email. I was trying to express the idea that Tutor might not be the best place to ask MySQL driver installation questions. I was trying to direct you to folks that should be better equipped to answer your questions based on their direct experience. But thankfully, it does sound like we do have a few MySQL-familiar folks on the list after all, so my concerns aren't as valid as I had thought. My pet hate on this list is top posting as it makes following a thread so difficult. -- My fellow Pythonistas, ask not what our language can do for you, ask what you can do for our language. Mark Lawrence ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
Don't worry, thanks everyone for the reply. I realize that the question was very general but I was looking for pointers which is exactly what you guys have given me. Now I know what to read, where to start. --Beatrice On Wed, Feb 18, 2015 at 9:14 PM, Danny Yoo d...@hashcollision.org wrote: I recommend using the official MySQL connector because it's supported by MySQL and it's continuously developed, which means it won't stop working when you change Python versions, or MySQL versions, and it's documented. I've tried some other MySQL libs in the past that worked OK but were a nightmare when it came to supporting them due to changes in the environment. Ah, I missed this one. Thanks. Hi Beatrice, Following up on James's recommendation, it does look like MySQL Connector should support the latest versions of Python, according to: http://dev.mysql.com/doc/connector-python/en/connector-python-versions.html where it says Python 3.3 and later are supported. So try using the 2.0 version of the Connector. Also, there appears to be a forum specific to MySQL Connector questions hosted by the MySQL folks at: http://forums.mysql.com/list.php?50 and they should be able to give specific help on that software too. That being said, you're welcome to ask questions here! My apologies again for sounding exclusive in my last email. I was trying to express the idea that Tutor might not be the best place to ask MySQL driver installation questions. I was trying to direct you to folks that should be better equipped to answer your questions based on their direct experience. But thankfully, it does sound like we do have a few MySQL-familiar folks on the list after all, so my concerns aren't as valid as I had thought. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] mySQL and Python
On Tue, Feb 17, 2015 at 5:49 AM, Beatrice Perez b.perezm...@gmail.com wrote: I have only ever used php with mySQL so I need some help. What would be the best library/extension to get? If I use mySQLdb or PyMySQL would I need the connector as well? Unfortunately, I don't know. Since this is the Tutor mailing list, we help with general learning questions: database module installation questions are a little out of scope. You might get better MySQL and Python-specific help on the general mailing list: https://mail.python.org/mailman/listinfo/python-list I'd recommend checking with the. Let's see... From looking at the wiki: https://wiki.python.org/moin/MySQL I see that there's a PyMySQL library that is labeled as supporting Python 3, but I have no personal experience with it. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor