Search code examples
pythonmysqlinteraction

Is there a recommended way for interaction between python and MySQL?


What is the recommonded way to interact between python and MySQL? Currently I am using MySQLdb and I heared from Oursql. But I asked myself, if there is a more appropriate way to manage this.


Solution

  • MySQLdb is what most people use at the lower level, but oursql is interesting too. You can use higher level mechanisms such as

    • sqlalchemy
    • Django - note it comes with a whole web framework :)
    • I'm sure you can find others, look for 'python orm'