Randall Munroe (of xkcd) gave a talk at Google.
Author: AngusThinks
-
SQLEditor 1.4.3b3
So, it’s coming up to the holidays, but there is time for another SQLEditor release.
1.4.3b3 (snappy numbering, yes?) is pretty much a bug fix release. I think that the index creation problems that were happening have now been fixed, plus better handling of when to create indexes. It should now correctly figure out if fields are indexed and shouldn’t now add duplicates (or worse attempt to add duplicates)
There is also the addition of the simulate mode for database export. This isn’t exactly new, because it’s been available in some development builds, but it has now appeared in a release version. Simulate mode runs the entire export as normal, except that instructions that alter the database aren’t actually sent to the database to be executed. The instructions are recorded though, so you can see what would have happened in the status window log view.
There is also a new feature which prevents fields and indexes being dropped (although it doesn’t prevent modification, use simulate if that’s what you want)
SQLEditor also now adds a line in the status window when an export fails complete with the instructions that were actually executed and the error that occurred. This information was always in the log, but it should be easier to see how SQLEditor has gone wrong (in the event that it does of course)
Finally some fixes for a few (hopefully unlikely) crashing bugs.
3.6MB dmg File
Change Log
Product Notes
Expires
21st January 2009 -
iPhone Shuffle?
The iPhone Shuffle,
(Advert 1)(Advert 3)
🙂
Plus the obligatory Wired.com article (a bit more serious though)
-
Adam Savage, Dodos and the Maltese Falcon
I just happened to watch this amazing presentation by Adam Savage
(of Mythbusters)Adam Savage on Obsession
(Fora.tv) -
MySQL before 4.1?
This graph appears to show that most people polled (97%) are using MySQL 4.1 or later
This second poll shows, again, that most people (89%) are using 4.1 or later.
The thread at the PunBB forum gives 95% of people polled using 4.1 or later.
The Mambo forum poll from 2006 gives 80% using versions after 4.1 (with 8.5% don’t know or other)
Admittedly not scientific surveys (self selection, etc) but somewhat convincing.
This has an obvious implication on how to handle MySQL support, in particular special casing to work around particular issues in early versions. This code adds complexity and in some unfortunate cases also bugs. The less there is, the better.
-
Zend Framework – run in a subdirectory
This article explains how to use Zend Framework MVC in a subdirectory (rather than in the DocumentRoot)
[Link]
-
Zend framework Quickstart and SQLite
I was building the Zend Framework quick start tutorial example but I kept getting the following error:
Message: SQLSTATE[HY000]: General error: 14 unable to open database file
This was despite the fact that I had correct privileges on the database file.
However it turns out you seem to need write and execute privileges for Apache on the directory that contains your sqlite database (not just the database file itself).
I added them to the containing directory and everything seems to work now. 🙂
[Link] (Nabble.com and the original source of this solution)
-
Is there a pilot on board?
In movies like Airplane! the pilots have all been incapacitated and a desperate call goes around “is there a pilot on board?” To which some brave soul then stands up and says something like, “Yes I can fly the plane”.
What’s weird though is that something a little like this actually happened recently.
An Air Canada Boeing 767 (C-FMXC) on a flight between Toronto and London was midway across the Atlantic when the First Officer showed signs of being confused and unwell. The captain decided the first officer should be relieved of duty and he was removed from the flight deck.
At this point the passenger lists were inspected to see if there were any airline pilots on board, unfortunately there were not, however one of the flight attendants held a commercial pilots license and she was asked to assist the captain. (There is suggestion on one forum that this flight attendant was either former or reserve Canadian Airforce)
The aircraft diverted to Shannon airport in Ireland where it landed safely. The captain later commented that the Flight attendant sitting in the second seat was “not out of place”.
The ill first officer was taken to a nearby hospital in Ireland and later flown back to Canada.
So that is an outline, but it raises so many interesting questions, many of which I may never know the answers too. The most important one of course being, how many cabin crew have piloting qualifications?
The accident report (by the Irish AAIB) is suitably detailed but, quite correctly, doesn’t include enough information to identify the people involved, so I may never know the complete story. Hopefully someone will make a documentary out of it. (But changing the names perhaps to keep the privacy of the ill pilot)
Guardian Article
(Mostly the same as the official report) -
SQLEditor updates
I’ve just released a new version of SQLEditor yesterday, mainly as a bug fix release, but it’s definitely recommended to upgrade.
The new beta is 1.4.3b1 which was released 14th November. It fixes a number of bugs, including MySQL comments and some odd bugs relating to selecting tables using the drag selection method.
Download 1.4.3b1 (3.6MB DMG)
The current stable version is 1.4.2 which came out at the end of October. It fixed several significant bugs that people reported and made a few minor improvements.
Download 1.4.2 (3.6MB DMG)
