Powered by Twitter Tools.
Twitter Updates for 2009-07-17
- @twitter please do something about these spam followers. They are incredibly easy to identify #
- #followfriday @BeateVeronica @GemmaBoyle @twit_AR @bschiett @the_magazine @henrymullen @stefanhinz @troymott @taffer #
- @BeateVeronica Nightmare!!! #
- Wow, we are in the middle of a ginormouse thunderstorm #fb #
- Wow, big flash of lightning and rumble of thunder just then! #
- OK, work had fundamentally become hard through a combination of local internet issues from the storm and a power cable cut at work #
- Tiny lizard falls like a feather: http://tinyurl.com/nmkwy7 #
- Watching Monk Season 3 #
- @BeateVeronica Join the club! #
Powered by Twitter Tools.
Twitter Updates for 2009-07-16
- I wish I had never started reworking some of this code now… #
- Food for thought; statistics and terrorists http://tinyurl.com/m4enwa #
- Have I mentioned how much I want these new #moleskine 2010 diaries? http://tinyurl.com/kkvv6t #
- Can someone at #Twitter please do something about this annoying fake, spamming, followers? #
- /me is hoping that Kat will come round soon! #
- Really really pumped after my exercises today, although my legs are killing me… #
Powered by Twitter Tools.
Dojo examples from UC2009
I know, I know, loads of people have been waiting for these…
So here we go, I’ve finally sorted a downloaded version of the Dojo examples from the presentation I provided at the MySQL Users Conference 2009.
There are three examples:
- The auto-paging table example, which uses the functionality of the Dojo Toolkit and the QueryReadStore to automatically load content from a table.

- The basic graphing example, which loads data dynamically and plots a graph.

- And the zooming version of the same basic graph interface
There’s a README in the download that contains instructions on getting everything up to speed, although it should be fairly obvious. It’s attached to the bottom of this post too.
Any questions for getting this to work, please go ahead and ask!
Download the package here
UC2009 Working with MySQL and Dojo
==================================
MC Brown, 2009, http://mcslp.com and http://coalface.mcslp.com
Components:
There are three examples here:
- Dojo table with auto-paging
(table_autopage.html and table_autopage.cgi)
- Dojo Basic Graph
(graph_basic.html and graph_ajax.cgi)
- Dojo Zooming Graph
(graph.html and graph_ajaz_zoom.cgi)
You will also need the Dojo/Dijit and DojoX toolkit package from here:
http://www.dojotoolkit.org/downloads
Download the combined package, and then extract the contents and place in the same directory as the CGI scripts
Intructions for use:
For the Table example, you can create a table (or use an existing DB) from WordPress using the wp_posts tabls.
In practice you need only create and populate a table with the following columns:
id (int)
user_nicename (char)
post_date (datetime)
post_title (char)
To be compatible with the example without any more modifications.
For the Graphing examples, you need a table as follows:
CREATE TABLE `currencies` (
`currencyid` bigint(20) unsigned NOT NULL auto_increment,
`currency` char(20) default NULL,
`value` float default NULL,
`datetime` int(11) default NULL,
`new` int(11) default NULL,
PRIMARY KEY (`currencyid`),
UNIQUE KEY `currencyid` (`currencyid`),
KEY `currencies_currency` (`currency`,`datetime`),
KEY `currencies_datetime` (`datetime`)
) ENGINE=MyISAM AUTO_INCREMENT=170048 DEFAULT CHARSET=latin1
And then populate with date/value data according to the information you want to store.
Once done, make sure you change the database information in the CGI scripts to populate the information correctly during operation.
Twitter Updates for 2009-07-15
- Debugging and optimizing are such fun #
- Cool, just wiped 5 items off the todo list. Just 102 more this week #
- Wow – having another one of those really really heavy rainstorms right now #fb #
- Raise your hand if you think that was a Russian water tentacle?! #filmquote #
- Dojo examples from #mysqlconf now available: http://tinyurl.com/nvoxrw #
Powered by Twitter Tools.
Twitter Updates for 2009-07-14
- @twitt_AR That is cool 🙂 #
- RT @twitt_AR : ) Augmented Reality on the iPhone: Markerless Tracking http://bit.ly/9vGSB #
- Why do doctors in the UK have such useless, unidentifiable, non-descript signatures? I’m surprised prescription fraud isn’t more prevalent #
- Watching Cannonball Run in remembrance of Farrah Fawcett and Dom Deluise #
- @JenLant Get well soon! #
- The Green 500 http://tinyurl.com/ltacej #
- Watching the first season of Medium. We really love this show #
Powered by Twitter Tools.
Twitter Updates for 2009-07-13
- @BeateVeronica Good luck! #
- OK, another 83 items popped up automatically into the todo list today. It’s gonna be a busy week #
- Sign the Grand Designs Great British Refurb petition! http://tinyurl.com/djxorx #
- Queen: A Night at the Opera – how more classic could you get! #
- I hope we get enough people to want the online tutorials for the psychology course here in the East Midlands; crossing fingers! #
- @taffer The problem with automated todo tools is you schedule it all nicely months before and then *bang* there they are! Only 592 to go… #
- @BeateVeronica Rats, my good luck didn’t work 🙁 Sorry! #
- @BeateVeronica I would keep my fingers crossed, but it didn’t work last time! Are you all packed for the move back? #
- OK #Porsche, so the #Panamera website looks fantastic, but despite looking like it’s got content, there’s really very little there #
Powered by Twitter Tools.
Twitter Updates for 2009-07-12
- Wow – I so want one of the new Colour a Month #moleskine diaries http://tinyurl.com/lekn3w #
- @taffer Good luck with that. And let me know if you find the secret 🙂 #
- Just watching Golden Compass on the big screen – last time I saw this was on the seat back in an airplane! #
- @BeateVeronica I wish that with all good movie series. If it’s good enough, I always want the next one *now*! #
- @BeateVeronica Well there’s The Subtle Knife on IMDB (http://tinyurl.com/l9g74o but it looks stalled :(( #
- Doing lots and lots of admin and analysis on #cheffy right now… #
- Which reminds me, remember folks, we post a daily recipe from http://tinyurl.com/le8ykh on http://tinyurl.com/n8hkwd #
- @Gemmaboyle Best. Song. Ever. !!!! #
- Or alternatively (soon) follow @cheffyrecipes and @cheffycom! #
- Got back on my bike today for the first time in years. Good to be back in the saddle, needs to cool down though #
- @taffer Fantastic!! #
- RT @taffer Who wrote an article for the International Society of Supervillains? I did! – http://bit.ly/wTUPc #
- @datacharmer Ugh, I hope he’s OK! #
- @dups Get us a Hot Apple Cider and a Cranberry for Sharon! #
- Want some now: Idea Paint #
- RT @pchaganti RT @methodmissing: About time http://tinyurl.com/bg6gah #
- Retweeted a retweet #
- #topgear must have a really low opinion of their audience if they think tonights show was even vaguely believable. Idiotically staged #
- Trying to chill while listening to Bo Burnham #
Powered by Twitter Tools.
Twitter Updates for 2009-07-11
- @BeateVeronica I *love* tidying, and deliberately let the house get messy so I can tidy it later. Sharon hates that! #
- @BeateVeronica You’ll get the hang of the enter key with more practice 😉 #
- Getting really really hacked off with #easactive not picking up my movements in the exercises. Just given up for the 2nd time today. #
- @BeateVeronica Oh, and have fun at your party! #
- OK, third time with different controller on #easactive, and the same problem. I give up. #easactive you better get your act together #
- OK #easactive, fourth time was a charm, but hardly trouble free. Shitty software is not a good way to encourage enthusiasm #
- @BeateVeronica Try sleep, movie, or a book! 🙂 #
- Watching Medium, while working, and drinking some smooth Red Mountain coffee… #
Powered by Twitter Tools.
Twitter Updates for 2009-07-10
- @Gemmaboyle Have you seen the new puppet meerkat advert? Very funny! Just found it on YouTube: http://tinyurl.com/n9cdh7 #
- LinkedIn seems to be on a go-slow right now #
- OK, giving up on #LinkedIn, it is now so slow as to be unusable #
Powered by Twitter Tools.