ramblings on PHP, SQL, the web, politics, ultimate frisbee and what else is on in my life
The MDB2 promise
Last week I made the promise to make another round of MDB2 and MDB2_Schema releases by the end of next week. Appearently more and more projects are picking up MDB2_Schema like Jaws and Chiara_PEAR_Server. So I have a few more days to fix things up. I am a bit sick after 3 days of outdoor mixed championships. My frisbee team ended up second. We lost the finals 14:12 after leading 10:12 (game was played til 13, cap 2, with a maximum of 15). However it was still quite exciting to play at such a high competitive level for me. We have multiple teams in Berlin and so I am a member of two teams, but I have mostly played with the one that plays 2nd league level. So usually I am one of the guys who handles the disc alot and makes alot of catches. But in this top level team I was solely focused on defense and I even managed to force a number of turnovers onto our opponents in the finals.
ext/mysqli and LOBs anyone?
A while ago I implemented native prepared statements into the MDB2 mysqli driver. However I was never able to get LOB support to work in the execute method. I almost forget about this and only stumbled over this issue again while testing a new portability fetch mode that fixes the issue of sqlite returning table qualifiers in associative fetches unlike most other DBMS extensions in PHP. Maybe someone has experience here and/or is motivated to fix the problem.
Where is the love?
I am always suprised at the bitterness of flamewars on open source mailinglists, IRC chats and blog posts. Often these flamewars spring from cultural differences, language barriers, little mistakes or oversights. Sometimes they also spring from the assumption that someone does not know the given system well enough or did not bother to read the documentation. Rarely do they spring from proper technical arguments and even then it seems odd to start using the rather aggressive tone which result in the flamewar label.
c# 3.0's LINQ
I have been looking a bit at c# 3.0's LINQ feature. Essentially it provides with c# with an SQL syntax to do what SQL does on DBMS, XML, Array and many other forms of data. What is interesting that the syntax also allows you to define not only what data you want but also the structure you want it in. Furthermore using reflection on the data source and generally the fact that you are no longer passing just a string to your datasource (SQL or XQuery) it is now possible to do compile time checking.
I am sitting in the closing keynote by Marco this very moment. The conference so far as been alot of fun. My 2 new talks went really well (though I really needed an additional 30mins for my SQL talk to cover everything I wanted), but my old LiveUser talk felt not so smooth. I hope that people still learned a bit, especially as the QA part went better. Next time I will review the slides a bit more beforehand to get myself a bit more into the topic again.