Yes, MySQL has transactions if you use InnoDB or NDB Cluster for example. Using these transactional storage engines, you’ll have to commit (or roll back) your inserts, deletes or updates. I’ve seen it a few times now with people being surprised that no data is going into the tables. It’s not so a silly problem in the end. If you are used to the defaults in MySQL you don’t have to commit anything since it is automatically done for you.

This post explains how to compile oursql and install it on MacOS 10.6. oursql is a Python database interface for MySQL, an alternative to MySQL for Python (i.e. MySQLdb) and MySQL Connector/Python. First, find out which MySQL you installed. This can be either the 32-bit or the 64-bit version. To make sure, find the mysqld (e.g. in /usr/local/mysql/bin) and do the following in a Terminal window: shell> file /usr/local/mysql/bin/mysqld .../mysqld: Mach-O 64-bit executable **x86_64** If you see x86_64, you got 64-bit, otherwise 32-bit.

Apparently, my talk at FOSDEM 2010 about Connecting MySQL and Python was the only one about Python? There should be more, or? I have a hand-out ready in PDF. The slides are not usable without my chatter. It contains a few examples and links. Any comments, corrections, criticism.. are welcome! The longer version of this talk will be given at the O’Reilly MySQL Conference&Expo 2010 in Santa Clara, California (USA).

Today we made a change in the schedule of talks held in the MySQL Developer Room at FOSDEM 2010, swapping two talks. Change is: 12:15 CET - Giuseppe’s ‘Sharding for the Masses 14:25 CET - Geert’s Connecting MySQL and Python (title also changed) The printed booklets found at the conference will not reflect the change, but the printable schedule has already been updated.

MySQL Connector/Python v0.1.3-devel is now available for download from Launchpad.org. Please note that this is a development (i.e. alpha, unstable, ..) release and we welcome everyone to test and report problems. Highlights for this v0.1.3-devel: Important memory leak fixed when closing cursors. Warnings can now be raised as exceptions. Fixing unicode usage and broken error message when MySQL chops them Client flags can now be set correctly when connecting Conversion fixes for BIT/YEARSET and Python to DATE/DATETIME Adding MySQL Client Errors and raising better exceptions based on errno.