pysqlw 1.0.0

Python 2.7.3 (this is what I test with, should work with 2.6.x, 3.x not guaranteed)

sqlite3 module (comes with Python installs)

Install MySQLdb if you want MySQL support

• If you’re using a Debian-like distro (Ubuntu, Debian, Crunchbang, etc), install the package python-mysqldb

  • $ sudo apt-get install python-mysqldb

• There is no pypi package (someone get on this)

• If that didn’t work, or you’re not using a Debian-like distro:

  • Build and install the MySQLdb module from source.

  • This link explains better than I could.

• Verify it’s installed: $ python -c 'import MySQLdb'

  • If nothing shows up, you’re good!

  • If you get an ImportError, think, do you really need MySQL?

  • If yes, this is a problem. :(

Install pysqlw: $ pip install pysqlw

Import pysqlw:

• import pysqlw

Create a new instance:

• db_type defaults to sqlite, so you won’t have to change it unless you want MySQL.

• pysql = pysqlw.pysqlw(db_type='sqlite', db_path='/home/user/example.db')

• If you want to use MySQL you need to supply more details:

• pysql = pysqlw.pysqlw(db_type='mysql', db_host='localhost', db_user='username', db_pass='password', db_name='database_name')

Documentation is found in the usage wiki page.