Aarrgghh!!

One guy's take on the web, programming, cigars, politics, Philadelphia, and whatever else comes to mind.

January 2007 Archives

Project: Squidhead

January 31, 2007

I've been reading Peter Bell and drinking the application generation Kool-Aid. To that end, I've been working on what I consider a development tool, but others I have talked to have called a baby framework. My gut feeling is that it might be a little bit too specialized for mass consumption, but I figured I would see if anyone else could use something like this.

For this to make sense I need to tell you a bit about my workplace environment:

  • We run ColdFusion 6 and 7, against large installations of MS SQL.
  • The Admin team (of which I am a member) mandated that developers cannot use direct SQL calls in ColdFusion, instead that we have to use Stored Procedures. I'm not going to get in the particulars of whether this is absolutely right or wrong, but it has done good things specifically for us.
  • Traditionally we have been anti-framework. A few of us have been moving towards it for the past few years, but there is still a lot of mistrust of frameworks, or patterns for that matter.
  • Traditionally we have been slow to adopt object-oriented ColdFusion. Likewise, I, and a few others came around a few years back, but others have not.
  • CFC's took a long time to get adopted, and they are still not fully in use.

With all of that in mind, I took at look at maybe developing something that would get rid of our most repetitive tasks. So I built a stored procedure creator that I extended, and extended until now, it actually does a whole CRUD application albeit a crude one.

In a nutshell here's what it does:

  • It inspects a Database
  • It analyzes the tables and views
  • It creates INSERT, SELECT, UPDATE, DELETE and LIST stored procedures for every TABLE.
  • It creates LIST stored procedure for every VIEW.
  • It adds them to the database.
  • It assigns the proper GRANT permissions

Then it does a second pass.

  • It inspects the database
  • It analyses all of the stored procedures not just the ones the process creates
  • It creates the <cfstoredProcedure> code for each stored procedure
  • It creates the <cffunction> to wrap the storedprocedure in.
  • It creates two sets of CFC's: GATEWAY and DAO
  • It creates a DAO for each TABLE and VIEW.
  • It adds each <cffunction> <cfstoredproc> combo within the appropriate CFC per table.
  • It places any operation with SELECT, DELETE, UPDATE, AND INSERT in the title within the DAO CFC'S.
  • It places all other actions to the GATEWAY CFC's.
  • It writes the CFC's to disk.

Finally:

  • It writes Custom Tag components to produce nuggets of Editing and Listing widgets.
  • It strings all of these together to produce a simplistic CRUD application.

There are a few restrictions on its use:

  • Only works on MS SQL
  • Requires account with ability to create and drop objects
  • All tables must have identity.
  • Preferably the id should be [table name]Id (Meaning I haven't found all the bugs)
  • Fields named "createdOn", "updatedOn" will be automatically set
  • Field named "createdBy" will only be set on create method
  • All stored procedures should be named "usp_[tableName]_[action]"
  • Table names need to be one word, Camel case is okay
  • Action can contain dashes.

I've found that this sort of thing is much better received with a demonstration. Please check out this Demonstration of what it can do.

Also I have a sample of what I think its killer feature is: it analyzes all stored procedures in the database, not just the ones it wrote. So you can write your own stored procedures, press a button, and have the code generator frame out the CFC calls for it. Here is a Demonstration of this in action.

It's worth it to say that this borrows a lot of successful patterns from Reactor for ColdFusion and ModelGlue. However, it is not as complex, flexible or powerful as either of these two. Let me make that very clear, so I don't get any flame here. This is far inferior in terms of feature set and flexibility than either of these solutions. There is a lot this thing doesn't do. But is also doesn't require you to come completely over to the frameworks camp. It doesn't require you to learn MVC. To that end, it fits my environment. I think it could be a good bridge between going it alone, and a full flexible, powerful, framework.

Would this be useful to anyone else, or am I right in thinking it's too specific to our environment?


January 31, 2007 Posted by Terrence Ryan at 3:25 PM

ColdFusion, Squidhead, Web Development,

CFEclipse 1.3 and Vista

January 26, 2007

I desperately wanted to be one of the cool kids and try switching over to CFEclipse now that the new version is out. But Vista balked when I went to install it. It rand through the process, and then said that it couldn't write certain files. (.bat files to be exact.)

Right clicking on Eclipse, and running it as administrator fixed this problem. I'm looking forward to give CFEclipse another try now.


January 26, 2007 Posted by Terrence Ryan at 9:30 AM

ColdFusion, Web Development,

Shortcut to Blogging in Word 2007

One of the features I love about Word 2007 is the fact that I can write my blog with it. It's annoying that it takes the following steps:

  • Open Word
  • Go to big button thing in the top corner
  • Choose "New"
  • Choose "New Blog Post"

I finally figured out a way to do it, and figured I would share.

  • Search your computer for Blog.dotx.
  • On my computer it's in C:\Program Files\Microsoft Office\Templates\1033\
  • Create a shortcut to that file.
  • Voila!

It seems so simple, I can't believe I missed it for so long.


January 26, 2007 Posted by Terrence Ryan at 2:15 AM

ColdFusion, Web Development,

Running a ColdFusion Shop 2

January 25, 2007

I had more to say about running a ColdFusion shop. Hopefully I'm not overstaying my welcome on the topic.

Developers are your Users

This might be an odd bit of information, and you shouldn't forget about the users of the applications, but developers are your users. This has a few different implications:

Development servers are production servers as far as your developers are concerned. I learned this the hard way a few years back when we lost our production environment due to a compromise. (Yeah, I had a server or two hacked, don't judge me.) We only had a single node production environment. Part of our recovery plan was, in case of emergency, use the staging environment as the production environment. This could work for a day or two, but day three came around and the complaining started. Perhaps justified, but when you are trying to get a new production environment up, you don't want to hear "we need to work." In the end, you want to make sure that the development servers stay up during regular working hours.

Users have their own definition of what is and is not your responsibility. "What's that you say? You deleted your entire directory, and want me to run a backup?" Developers will eventually either accidently wipe out files, or go down a bad path with their code and want a restore. We've all done it, but as an administrator you're going to want to ensure that their problems don't become yours. Make sure they have access to a source control product. Encourage them to use it. If you're running on Windows enable Shadow Copy. If you do regular tape backups try and have a local backup that you can easily restore from. The idea here is that at some point you will be asked to run a restore, you want to make sure that you never really have to.

Don't be an asshole about security. I know I just said something about being hacked, but bear with me. The first of Microsoft's Immutable Laws of Security is:

If a bad guy can persuade you to run his program on your computer, it's not your computer anymore.

Your developers can run code on your server; by definition you are already compromised. Don't lock down tags. Don't prevent object creation. A smart annoyed developer will get around you. The administrator is pretty easy to get around if you can do any sort of file manipulation. Even if this doesn't work, there are many ways a developer can outsmart you if you are unnecessarily restrictive.

Obviously this is for groups of developers that work for the same company. I hope hosting companies don't have this attitude. Additionally, don't ignore external security.

Be open about your standards. A few years ago people left every code review we had saying, "Why didn't anyone tell us about these new standards?" The reason was that the central group of administrators trolled the blogs, read articles and paid attention to what was the newest recommendations. We would talk about them, and come up with new guidelines. Problem was that we didn't talk to the rest of the group until code reviews came up. My group started posting our standards on our Developer's blog, and now people don't leave code reviews feeling like they've been ambushed.

That's it for now, I'm sure I remember something afterwards which can wait for an eventual part 3.


January 25, 2007 Posted by Terrence Ryan at 9:30 PM

ColdFusion, Running a ColdFusion Shop, Web Development,

Padron 1964 Anniversary Diplomatico

January 18, 2007

Mmmmmm. Alternative happy hour started back up this week.

Review in extended section.

Continue reading "Padron 1964 Anniversary Diplomatico"


January 18, 2007 Posted by Terrence Ryan at 11:46 PM

Cigar Reviews, Cigars,

Running A ColdFusion Shop

This is a post I've been mulling for awhile and since my office is so cold that I can't concentrate, I figured I would give it a shot.

In addition to writing applications in ColdFusion I'm also responsible for maintaining our environment. Our environment consists of 20 or so full time developers, with another 10 to 20 or so part time developers. Our code lives on around 20 servers, which are split up according to different versions and purposes. We run sub-environments for ColdFusion 6, ColdFusion 7 and Flex 1.5 (which is a much different animal then Flex 2.0.) The developer's group as a whole maintains about 100 or so applications. These applications range in size from a simple one form troubleshooting reporting tool to our student portal that serves our entire student body, and won a Max Award for Education Experiences back in 2004.

I figured I would share some of my observations about what has made our environment more stable over the past three years. Maybe it can help; maybe I'm wrong and need correcting.

Continue reading "Running A ColdFusion Shop"


January 18, 2007 Posted by Terrence Ryan at 4:53 PM

ColdFusion, Running a ColdFusion Shop, Web Development,

Gadgets and Widgets and Apollo, Oh My!

January 17, 2007

I've been building my first Vista Gadget. Dave K inspired me by writing an awesome targeted Gadget for our environment. For those of you who don't know, Gadgets are little HTML, JavaScript enabled applications that run on the desktop and server up little bits of information like weather, or stocks, or what have you. For those of you that are saying "OSX has had them for awhile... they're called widgets," Shhhh, be quiet. Apple stole the idea from Konfabulator, who stole it from Apple, who probably stole it from Xerox. But let's just say the idea has been around for awhile, and we all think it's cool.

Anyway... I've been writing a Gadget, and it's shockingly easy. However I'm annoyed at the prospect of translating it to a OSX Widget. It's HTML, it's JavaScript, it's CSS; a widget is HTML, a widget is JavaScript, a widget is CSS. Why the hell do I have to do any translation? This is the age of Web Standards, and SOA, I thought I would never have to work to make a basic HTML application cross platform again. Both Microsoft and Apple deserve a little finger wagging here. You're making us take a giant step backwards!

I could rewrite it as a Yahoo! Widget. That would make it cross platform. But I would have to rewrite it as XML and JavaScript. (Not as much fun as HTML and JavaScript. ) Plus, it's not like Yahoo! Widgets is lighting up the Internets.

If only there was a cross platform application engine that could present applications written in HTML and JavaScript. It would harness the ease of HTML and JavaScript development with a portable runtime. It could also package them into self contained little applications that don't need the screen real estate of an entire web browser.

Oh wait, isn't that what Apollo is supposed to be? Can't it do Flash and Flex too? Isn't it also going to package whole applications, not just nuggets of applications?

I finally get it Adobe. I was lukewarm at first. But now that I see how effective these little applications can be, how easy they are to write, and my frustration with platform issues, I totally get it now. Assuming you can leverage your "Version Penetration" for Flash into seats with Apollo, you will kick the crap out of all of those other options.

But now I want Apollo. Crap.

Oh well, my plan is to keep writing the occasional Gadget, really get the whole Ajax thing down, and be better positioned to take advantage of Apollo when it is released.


January 17, 2007 Posted by Terrence Ryan at 1:57 AM

ColdFusion, Random, Web Development,

Laphroaig

January 4, 2007

My houseguests left a little something when they left: a bottle of Laphroaig Quarter Cask. For those that don't know, it is a single malt scotch which is believed to be one of the more strongly tasting scotches. It's supposed to taste like peat. (Intentionally tasting like decaying vegetation) Additionally, it supposedly it tastes like scotch did 100 years ago.

At first I was apprehensive. The last time I tried Laphroaig I didn't like it, as it tasted like suffering. But that was not the Laphroaig Quarter Cask.

This time, it's not that bad, maybe it was my older palate. Maybe it was the whole 100 years ago thing. Maybe I like the taste of peat.

I'm glad Janice is asleep though. She doesn't like when I come to bed smelling like cigar. I can't imagine her reaction to "peat moss breath."


January 4, 2007 Posted by Terrence Ryan at 1:54 AM

Personal, Random,

Happy New Years

Happy New Years to all. I've been silent because I've been busy.

I had house guests who promote hangovers. (Well, only one of them did that.) But I've need a couple days to recover from all of the Black Label, (and Captain Morgan's and Aberlour and egg nog) and cigars and food that were consumed.


January 4, 2007 Posted by Terrence Ryan at 1:42 AM

Personal, Random,