Ideas, releases, practical guides, and perspectives from the people building with MySQL.
We have moved bugs for MySQL Connector/Python from Launchpad to the MySQL Bugs website http://bugs.mysql.com. Reports which are (probably) fixed in newer code were not taken with. If there is a bug which you really want to get tracked: please report it again.
Please use the MySQL Bugs website to report problems using MySQL Connector/Python. To see a list of active reports, click here.
…
[Read more]Splitmytab.net is finally for the public to check out. Splitmytab is a bill splitting and IOU system for friends. It uses facebook’s login, so you won’t need to put in anyone’s emails, names, or get people to sign up for an account.
It’ll automatically keep balances of who owes who, so you can keep a running tab with friends and always know who’s buying the next case of beer.
Please note: I’m not a designer, so there’s a few rough corners, but what’s there is simple and it works.
Tech Notes:
Enjoy, and please leave feedback!
In a previous post, I demonstrated a simple Python
database API with a syntax similar to jQuery. The goal was to
provide a simple API that would allow Python programmers to use a
database without having to resort to SQL, nor having to use any
of the good, but quite heavy, ORM implementations that exist. The
code was just an experimental implementation, and I was
considering putting it up on Launchpad.
I did some basic cleaning of the code, turned it into a Python
package, and pushed it to Launchpad. I also added some
minor changes, such as introducing a define function
to define new tables instead of automatically creating one when
an insert was executed. Automatically constructing a table from
values seems neat, but in reality it is quite difficult to ensure …
We’ve seen the rise of open source software in the enterprise and also beyond the IT industry, but the real keys to openness and its advantages in today’s technology world — where efficient use of cloud computing and supporting services are paramount — exist in open application programming interfaces, or APIs.
Open source software continues to be a critical part of software development, systems administration, IT operations and more, but much of the action in leveraging modern cloud computing and services-based infrastructures centers on APIs. Open APIs are the new open source.
Read the full story at LinuxInsider.
I recently found Todd's posts on interceptors which allow callbacks (called interceptors) to be registered with the connector so that you can intercept a statement execution, commit, or any of the many extension points supported by Connector/Java. This is a language feature that allow you to implement a number of new features without having to change the application code such as load-balancing policies, profiling queries or transactions, or debugging an application.
Since Python is a dynamic language, it is easy to add interceptors to any …
[Read more]There have been some request to have some reconnect possibilities in Connector/Python. I’m wondering now whether there should be some automatic reconnect on certain errors within the database driver.
My personal feeling is to have no automatic reconnect within Connector/Python and the programmer has to come up with retrying transactions herself.
For example:
cnx.disconnect() # For testing..
tries = 2
while tries > 0:
tries -= 1
try:
cursor.execute("INSERT INTO t1 (c1) VALUES ('ham')")
cnx.commit()
except mysql.connector.InterfaceError:
if tries == 0:
print "Failed inserting data after retrying"
break
else:
print …[Read more]
I ran into an issue installing the MySQLdb module.
>>> import MySQLdb
/Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.py:3:
UserWarning: Module _mysql was already imported from
/Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.pyc,
but /Users/jhaddad/Downloads/MySQL-python-1.2.3 is being added to
sys.path
Traceback (most recent call last):
File ““, line 1, in
File “MySQLdb/__init__.py”, line 19, in
import _mysql
File “build/bdist.macosx-10.7-intel/egg/_mysql.py”, line 7,
in
File “build/bdist.macosx-10.7-intel/egg/_mysql.py”, line 6, in
__bootstrap__
ImportError:
dlopen(/var/root/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg-tmp/_mysql.so,
2): Library not loaded: …
Today we registered MySQL Connector/Python with the Python Package Index (PyPI). It makes installing your favorite connector even easier (provided you first install setuptools or pip):
shell> easy_install mysql-connector shell> pip install mysql-connector
Please report problems either using Launchpad or MySQL Bugs website.
…
[Read more]In addition to reporting MySQL Connector/Python bugs on Launchpad, it is now also possible to enter them using http://bugs.mysql.com.
After more than 6 years doing MySQL Support for MySQL AB, Sun Microsystems, and Oracle, it’s time for a change. Time to get back to development!
As of November 2011 I’ll be working full-time on MySQL Connector/Python and other goodies within the MySQL development team at Oracle. Before, this was more or less a pet project done after working hours. However, with the birth of our son Tomas more than a year ago, I’ve been slacking and family got priority.
The idea is to make MySQL Connector/Python the best choice for connecting to MySQL from within your Python code. We still got …
[Read more]