Aufwind Aufwind - 1 month ago 12
MySQL Question

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.

Answer

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'