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).
Matt Asay joins Canonical. Paula Hunter joins the CodePlex Foundation. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
# Matt Asay joined Canonical as chief operating officer.
# Paula Hunter was named executive director of the CodePlex Foundation.
# Actuate recorded $6.5m in BIRT-related business for Q4; annual BIRT-related business of $18.2m up 18%.
# Glyn Moody outlined The Great Oracle Experiment.
# The Symbian Foundation …
[Read more]The time has come for major performance improvements to the reporter, stats-gather, alerter, and client scripts. This means that I will be rewriting the scripts in Python. A couple of reasons for this; to cut down on the number of modules that are required for the installation process (which also makes distributing the client script [...]
Today we made a change in the schedule of talks held in the MySQL Developer Room at FOSDEM 2010, swapping two talks. Change is:
The printed booklets found at the conference will not reflect the change, but the printable schedule has already been updated.
Today we made a change in the schedule of talks held in the MySQL Developer Room at FOSDEM 2010, swapping two talks. Change is:
The printed booklets found at the conference will not reflect the change, but the printable schedule has already been updated.
Using SQLAlchemy unit test cases to further develop MySQL Connector/Python. It's probably debatable whether that's a good method or just lame. But it sure helps lots!
We've been pushing some code past days that makes Connector/Python almost pass all tests. Well, 4% is still failing, but I'm confident that in a few most problems will be dealt with. I had to make some changes to the SQLAlchemy v0.6 dialect as well, and some test cases had to be corrected. Hopefully those corrections will also go in the SQLAlchemy trunk later on.
[Read more]
shell> nosetests --dburi=mysql+mysqlconnector://root:@localhost/sqlalchemy
..
----------------------------------------------------------------------
Ran 2092 tests in 314.656s
FAILED …
EC approves Oracle-Sun. Google patents MapReduce. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
EC approves Oracle-Sun
The European Commission cleared Oracle’s proposed acquisition of Sun
Microsystems. While Larry Ellison is set to unveil Oracle’s
Sun strategy on January 27th, Monty Widenius said he will go to the
Court of First Instance to appeal the decision.
# Pro-open source political party formed in Hungary.
# Google …
[Read more]Never have I planned a program so much in detail before starting coding. And stranger still, I’m planning the program to be coded in a language in which I haven’t written a single line of code. Nonetheless, I’m eager and it feels good.
I woke up early this Sunday, my mind concentrating on the many steps I will have to take before the first project will see the light of day. I had planned eight prerequisite lessons before even starting the coding. And despite receiving many good pieces of advice, nobody had relieved me of my main worry — the input grid for the data entry in matrix format.
To speed up things, I thought of writing some auto-generated INSERT statements from the current Google Spreadsheet that I’ve been using. I would then at least have the basic data from the first two weeks of the year to play around with in my MySQL database.
And then it struck me: I don’t need a grid at …
[Read more]Use PyObjC to code Python under the Mac Cocoa framework, and MySQLdb to interface with MySQL! That’s the advice I got in reply to my recent blog. The discussions were so inspiring that I spent all time when out running yesterday daydreaming about how wonderful it will be to rediscover the aesthetics of programming and regain the control over my personal IT.
So, to recap a bit of my thinking: Once a programmer, always a programmer. If you’ve learned how to code and to master your own IT life to a certain degree, you get used to it. At least I did. But then fate wrote a declaration of incapacity for me. Not only did I become a manager and got to do less and less coding. More aggravatingly, I changed operating systems. Gone …
[Read more]
Being a MySQL DBA , one faces a common issue in replication
environment -> Disk space issue on master, since the number of
binary logs have increased. Now, one of the solution to this
would be using expire_logs_days parameter in your mysql
config file. But what if, the slave is lagging by few
hours or if the slave is broken since few days and the binary
logs are removed due to the parameter set. Whenever the salve
comes up, it will go bonkers, knowing that the binary log where
it last stopped no more exists.
I faced this
issue a couple of times until I decided to automate it using a
script. Herewith I am attaching the URL to my python script which
can run regularly in cron. Features :