MySQL

Dec 14 03:38

Monty says, Help save #MySQL

http://monty-says.blogspot.com/2009/12/help-saving-mysql.html

Matter of notice, especially for PHPers, MySQLers in one of the EU nations.

This is a laughable account of profound hypocrisy. MySQL maintained a smart dual license policy throughout (I'm not complaining!), and sold out to Sun in it's ailing days(?) (This was disappointing) and eventually Oracle got a runaway deal on everything, but it's now that Monty expresses moral outrage over Oracle's ownership.

Nov 20 18:36

Why most frameworks suck

You might call me cynical, but this is a ranty (and nothing new) list of complaints + FUDs against most web development / application frameworks. Seems like this is also a natural point of transition for believers in another (new) faith, that of self-help (albeit more self deception and vanity all the same).

You fit the bill, rather than the bill fitting you
So many times, it seems that the problem is with MVC as a concept itself. The inherently flat flavor most frameworks put MVC in action to makes it that much more difficult for large codebases. It can't be helped feeling that adopting an MVC design is in many cases, squeezing yourself into a car rather than walking into one.

Apr 12 22:16

Useful Drupal Upgrade Snippet

Long time no post. Been really caught up: Tons of work, travel, Acads. Anyway, I happened to be upgrading some old Drupal sites from 5.x -> 6.x. Here's a little SQL snippet to disable all non-core modules first.

UPDATE `system` SET `status` = 0
WHERE `name` != 'system' AND `name` !='block' AND `name` !='node' AND `name` !='user' AND `name` !='watchdog' AND `name` !='filter' AND `name` !='upload' AND `name` !='tracker' AND `name` !='throttle' AND `name` !='taxonomy' AND `name` !='statistics' AND `name` !='search' AND `name` !='profile' AND `name` !='poll' AND `name` !='ping' AND `name` !='path' AND `name` !='menu'

Dec 11 21:19

Prepopulate Views Filters with args

Assuming that the argument is a node ID, being sent (say from a panel, under most circumstances)

// grab nid from referring node
$args[0]=arg(1);
if(is_numeric(arg(1))){
$nid = arg(1); //node id
$term = taxonomy_node_get_terms_by_vocabulary($nid, 3); // 3 is the vid. Use your own Vocabualary ID!
$tids=key($term);
return $tids;
}

$args[1]=$tids;