Drupal

Bubbletimer module unfortunately did not work out, possibly due more to our server configuration at the time, but i didn't have time to investigate, so i sent $20 for the year to Bubbletimer.com. Note to self: offer a decade-worth of payments to developers of the Drupal module.

SELECT type, name, module, locked FROM node_type;

Visualize plugin will be great for graphs (like what percentage of nodes on a site are each node type)

Notes from the presentation by Julia KM:
http://www.juliakm.com/drupal-love-story

Great security
modular
core very lightweight
(
used by lots of smart, helpful people

The Rough Period
not all modules are created equal - must evaluate quality
CRM + E-commerce = Pain

Hacking core until
i decided to write my own menu system - not a good idea
always a good idea to work within the constraints of Drupal

In searching for the perfect name for my dreamed-for annotation module, i found Marginalia. And through the name, i found a JavaScript tool already built to do it!

http://webmarginalia.net/

The search is over:
http://en.wikipedia.org/wiki/Marginalia

An error like this one:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM block block WHERE (theme = 'bartik')' at line 1: SELECT FROM {block} block WHERE (theme = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => bartik ) in xray_block_statistics() (line 80 of /home/ben/workspace/dgd7all/sites/default/modules/xray/xray.module).

Order matters. condition() before countQuery()

This fails (note it trying to do a subquery):

<?php
return db_select('block')->countQuery()->condition('theme', $theme)->execute()->fetchField();
?>