blog.rubicon.je

MySQL Indices – what, how and when

Rob — Fri, 03 Sep 2010 12:25:40 +0000

One simple area of MySQL optimisation that is often overlooked is indexes* on tables.

Basically an index is a sub set of the data that allows the MySQL engine to match against values much faster than normal.

In short, it speeds up the sorting of data and therefore reduces the time it takes to . . . → Read More: MySQL Indices – what, how and when

Scheduled Tasks – vanishing into the Void

Rob — Thu, 02 Sep 2010 15:36:05 +0000

We’ve got a really frustrating issue with our ColdFusion 8.01 box that seems to be getting worse as time goes on.

Every so often (the actually time seems pretty random – it could be 24 hours it could be 5 days) scheduled tasks that have been created in the ColdFusion Administration are simply disappearing.

There’s no . . . → Read More: Scheduled Tasks – vanishing into the Void

SOTR 2011 Speakers – the wraps are off

Rob — Wed, 01 Sep 2010 13:02:20 +0000

Almost on schedule and the immensely hard-working team behind Scotch on the Rocks have unveiled the speaker list for the 2011 conference in Edinburgh.

Amongst the usual luminaries of the CF community it’s good to see some UK community names in the list. The only problem? With that many speakers and 3 tracks I’m going to need to work double time on my self cloning . . . → Read More: SOTR 2011 Speakers – the wraps are off

How to access the font list in ColdFusion 8 …

Rob — Mon, 09 Aug 2010 11:33:39 +0000

… without Java or authenticating against the CFIDE object!

I’ve recently been working on a pure ColdFusion / CFImage implementation to generate dynamic title images in specific fonts.

As part of the configuration of this particular code I needed to access the installed font list but the only method I could find documented required . . . → Read More: How to access the font list in ColdFusion 8 …

Why Adobe should support ColdFusion Builder on Linux

Rob — Wed, 04 Aug 2010 15:55:48 +0000

#bbpBox_20297427052{background:#9ae4e8 url(http://s.twimg.com/a/1279901730/images/themes/theme1/bg.png) no-repeat !important;padding:20px;}#bbpBox_20297427052 p.bbpTweet{background:#fff;padding:10px 12px 10px 12px !important;margin:0 !important;min-height:48px;color:#000000 !important;font-size:18px !important;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px}#bbpBox_20297427052 p.bbpTweet a {color:#0000ff !important}#bbpBox_20297427052 p.bbpTweet span.metadata{display:block;width:100%;clear:both;margin-top:8px !important;padding-top:12px !important;height:40px;border-top:1px solid #e6e6e6}#bbpBox_20297427052 p.bbpTweet span.metadata span.author{line-height:19px}#bbpBox_20297427052 p.bbpTweet span.metadata span.author img{float:left;margin:0 7px 0px 0px !important;width:38px;height:38px;padding:0 !important;border:none !important;}#bbpBox_20297427052 p.bbpTweet a:hover{text-decoration:underline}#bbpBox_20297427052 p.bbpTweet span.timestamp{font-size:12px;display:block}

@sagarganatra @robdudley if only a single feature was added to ColdFusion Builder 2, . . . → Read More: Why Adobe should support ColdFusion Builder on Linux

Scotch on the Rocks 2010 – Day Two

Rob — Wed, 02 Jun 2010 21:39:11 +0000

ColdBox Platform 3.0.0 : Developing Sustainable ColdFusion Applications - Luis Majano (Ortus Solutions)

As a firm believer in roll your won code I’ve always viewed large frameworks with some suspicion. Especially when Mike in his caching session pointed out that a framework with 1000’s of CFCs before you even start writing your own code . . . → Read More: Scotch on the Rocks 2010 – Day Two

Scotch on the Rocks 2010 – Day One

Rob — Wed, 02 Jun 2010 13:40:36 +0000

Keynote (Adobe)

Terry Ryan kicked of the first day with an indy themed KeyNote. His initial demo was of a very impressive ColdFusion builder extension. Apptacular is a code generation system that runs natively from within CFBuilder and was demoed as being able to wire up CRUD from a DB (with smart table renaming . . . → Read More: Scotch on the Rocks 2010 – Day One

Scotch on the Rocks 2010 – The slightly emotional preamble.

Rob — Wed, 02 Jun 2010 13:40:08 +0000

Scotch on the Rocks is done and done! I’m back home and relaxing the glow of 2 (and a bit) days spent learning stupid amounts of cool stuff, meeting even cooler people and doing it all in one of the coolest conferences I’ve ever had the good fortune to attend.

I’ll get onto the . . . → Read More: Scotch on the Rocks 2010 – The slightly emotional preamble.

SOTR 2010 – What I’m going to see

Rob — Wed, 12 May 2010 12:07:00 +0000

The premier UK ColdFusion conference Scotch on the Rocks 2010 is less than 2 weeks away!

I’m starting to get excited. My flights are booked. My hotel is confirmed (and it’s all of 2 minutes away which is nice) and I’ve got my selection of geek t-shirts picked out. The laptop is loaded and . . . → Read More: SOTR 2010 – What I’m going to see

Upgrade Java POI for Better Excel Support in ColdFusion 8

Rob — Fri, 07 May 2010 10:33:54 +0000

For those of us running on ColdFusion 8, Ben Nadel’s wrapper to the Apache POI classes are still the best way of working with native Excel files.

That said, the POI that ships with CF 8 is old … very old … 2004 old in fact and as such it has to be treated . . . → Read More: Upgrade Java POI for Better Excel Support in ColdFusion 8