Accidentally truncated yout kaltura.entry table?

Fear not!, for you can rebuild it with this SQL statement:

INSERT INTO kaltura.entry (id, kshow_id, kuser_id, name, type, media_type, data,
thumbnail, views, votes, comments, favorites, total_rank, rank, tags, anonymous,
status, source, source_id, source_link, license_type, credit, length_in_msecs,
partner_id, group_id, int_id, subp_id, display_in_search, puser_id, plays,
permissions, partner_data, access_control_id, conversion_profile_id, categories,
categories_ids, created_at) SELECT de.entry_id, de.kshow_id, de.kuser_id, de.entry_name,
de.entry_type_id, de.entry_media_type_id, de.data, de.thumbnail, de.views, de.votes,
de.comments, de.favorites, de.total_rank, de.rank, de.tags, de.anonymous,
de.entry_status_id, de.entry_media_source_id, de.entry_source_id, de.source_link,
de.entry_license_type_id, de.credit, de.length_in_msecs, de.partner_id, de.group_id,
de.int_id, de.subp_id, de.display_in_search, de.puser_id, de.plays, de.permissions,
de.partner_data, de.access_control_id, de.conversion_profile_id, de.categories,
de.categories_ids, de.created_at FROM kalturadw.dwh_dim_entries AS de;
:)
Of course, we won’t go into how exactly that happened… And you lose some of the metadata, but neh. You get all the important data back without any problems whatsoever. :)
Just remember to bounce and re-index Sphinx afterwards!

Dennis Ritchie (1941—2011)

It’s been a bad year for computing, this one, as we’ve now lost the father of the C Programming Language.

It’s a sad thing to note that whilst Ritchie had as much, if not more, influence on the Computing Industry as Steve Jobs, he’ll only be remembered by a small number of people worldwide: Those of us who program for a living.

Requiescat in Pace, Dennis. You’ll be missed.

In other news…

I love the fact that this article points out that Labour is the most Fascist of the British political parties. xD

I really laughed when I saw that graph.

An amusing quote

Most people I know are aware of my total and utter devotion to Zend Framework and the wish that it will replace all other frameworks and render such abominations as Symfony and CakePHP irrelevant.

So, I giggled when I spotted this in the topic of freenode.net’s #zftalk-community channel earlier today:

<freen> Zend Framework is like a really hot chick who doesn’t speak English: You’re already attracted to what it offers, but then the learning curve comes with understanding how to speak to it.

I lolled.

From one idiot to another…

Almost as soon as I clicked ‘Publish’ on that last post, a friend linked me to this post on boingboing:

http://boingboing.net/2011/10/08/wipo-boss-the-web-would-have-been-better-if-it-was-patented-and-its-users-had-to-pay-license-fees.html

I can’t think of anything that would have been worse for the world than the guys at DARPA filing patents for the Internet.

Lightening the mood somewhat, this, Jen, is the Internet:

Steve Jobs

Well, I do feel kind of bad for leaving this so long, but I’ve revised this several times already before posting it, and it’ll probably get edited a bit after it does finally go live.

Steve Jobs was a visionary without whom the computer industry would not look anything like it does today. I’m willing to bet that most people reading this own an Apple device of one flavour or another, be it an iPadPodPhone or a MacBook of some revision. His company engineered the biggest, and arguably best, change in the music industry by making digital music easily available world-wide.

Yes, he may not have single-handedly bought about these things, but his enthusiasm, charisma, and love for the work that Apple did and will hopefully continue to do long into the future really did make people think different.

So, the opposing tributes of Apple and Richard Stallman to a man who literally changed the way we work with computers show both the best and worst of people in two short messages.

I must admit, I was shocked when I read that post on RMS’s website. This is a man who is the figurehead of an organisation which exists to convince people to switch to using ‘free’ software, but seems to be doing more harm than good to the cause.

I am not glad that Steve Jobs is dead. I am most certainly not glad that he is gone either, as his company produces software without which I would not be able to pursue one of my most-loved hobbies - producing music. That RMS thinks the world is better with out Steve Jobs says more about how RMS is failing where Steve succeeded - in his ability to convince people to turn to his way of thinking.

Steve Jobs and his company changed an industry with a small, inexpensive device that anyone can own.

RMS, on the other hand, is giving his organisation and his cause a bad name.

It’s amazing how charisma and personality can make such a difference between the success and failure of a project.

That said, Jobs’s management style had a much darker side, which Gawker talks about quite well here: http://gawker.com/5847344/what-everyone-is-too-polite-to-say-about-steve-jobs

It’s a well-known fact that Apple has a department known internally as the Gestapo. I can understand the reasons for its existence - if you’re investing billions into a project, you don’t want your competitors buying the specs from one of your employees - but I must question their methods, and I do find myself asking whether this approach is this the result of lawyers and legal wranglings, or if it was a conscious decision made by Jobs himself?

OSX output volume too quiet?

Boom!

It’s on the App Store, and it’s bloody genius.

I’ve gotten better results from the equiliser by putting it onto Loud mode, rather than just boosting the output volume, but it really does make up for all those bollocks videos on YouTube. :)

PHP SFTP readdir bug

Wasted a couple of hours tracking this bug down.

If you’re trying to connect to an SFTP server using PHP’s libssh2 bindings on Debian, you’ll get an empty result when trying to call readdir() on an opened directory.  The fix is easy: uninstall the version from apt and run this instead:

pecl install channel://pecl.php.net/ssh2-0.11.2

That will install the latest version, which the bug is fixed in. Voila. You can suddenly read directories.

Today is D-Day

Well, Diana Day, as it’s known at work.  We’ve just published an article entitled “Diana at 50” on high50.

I’m now desperately hoping that all the server optimisations and modifications we’ve made over the last three weeks since we found out about it save it from the inevitable slashdotting.

The AV Referendum

Well, I must admit, I’m feeling thoroughly trounced right now, and the result of the referendum hasn’t even been announced.

Of the people I asked, there’s been a definite young/old divide.  Everyone I know under 35 has voted for the Alternative Vote electoral system, and everyone I know over 35 has voted against it.

Considering that the majority of people in the UK are over 40, I’m not holding out hope, despite putting down £15 on a yes vote with Ladbrokes - we’re all allowed a moment of optimism…

So, yeah… Not having a great day already, and the results haven’t even been announced yet. :(