Dec 4
In this show we talk Hall Helms's decision to leave CF and move to RoR. Dave talks about his feelings about using different database techniques. Mike gets distracted by little shiny things. We talk a little about ColdFusion Builder and our experience so far with ColdFusion 9. The winner(s) are announced for our Railo schwag give away. We also give the details on how to enter the contest to get the can't buy ColdFusion 9 item.
Show Topic links:
Railo http://www.getrailo.org/
Hal Helms leaves ColdFusion for RoR
Dec 5, 2009 at 3:52 PM Store procedures suck~! ok, there, I said it. :)
However, having said that, if store procedure can be tracked by source control easily, I will consider using more of that.
Dec 6, 2009 at 7:15 PM @Henery SPs suck?? You can't be serious. Care to elaborate on your statement?
Dec 7, 2009 at 10:37 AM With the topic of RonR on this episode, have you ever seen or played with ColdFusion on Wheels (or CFWheels for short)? It is inspired by RonR, how do you compare to other frameworks with CFWheels? Maybe you can discussed it on your next show? I would like to hear what are your thoughts about CFWheels.
Dec 7, 2009 at 11:09 AM Yeah, lots of good press on the interwebs lately about CFWheels:
http://www.oxalto.co.uk/blog/post.cfm/discovering-cfwheels
http://nagpals.com/blog/post.cfm/cfwheels-rediscovering-beauty-in-cf-code
http://andreacfm.com/post.cfm/my-first-cfwheels-plugin-ioc-interface
I also wanted to comment about CFBuilder's memory leak problem on Mac OSX (which you mentioned on the podcast). I read a solution to it (I forgot where), which is to install CFBuilder as a plugin instead of standalone. So I set up a fresh install of Eclipse and re-installed CFBuilder as a plugin and I haven't experienced the memory leak since (I can now keep CFBuilder running for days on my Mac). You should give it a shot.
Dec 7, 2009 at 2:45 PM If cfwheels doesn't even get mentioned, does it still exist? Convention over Configuration Rulez! Where is the love, guys :-) http://www.cfwheels.org
Dec 8, 2009 at 10:32 PM sp have their place. i've used them extensively when transforming data, however i feel them don't belong in web applications. reason being is that if you're in an environment like i am where you don't have access to the database, it makes debugging and testing your application harder. most of the logic in a sp can be replicated within cf. so unless you're doing something very specific, i would avoid them at all costs.
Dec 9, 2009 at 7:24 AM Concerning your problem with the CFBuilder memory leak.
I had this too, as did a number of others, and submitted a bug report. The Adobe team came back with a temporary solution:
http://is.gd/5gVzP
Seems to solve the problem for me...
Dec 10, 2009 at 6:40 AM @tony I have never understood peoples stance against using stored procedures. I guess I am just spoiled and have always worked on apps that had them. However, even when I work on something small I still make them. I feel a show topic coming on.
Dec 10, 2009 at 1:07 PM I think that stored procedures can have their place in your dev cycle. But it really depends on a couple of things. Does your dev team work well with them? If you rely on a DBA to write and/or deploy your code, are they usually readily available to help out?
If you're a one- or two-man team, I'm seeing little reason to use them unless you're doing a ton of complex queries. It's just faster to use an ORM.
Dec 10, 2009 at 1:13 PM I also meant to mention that there can be some performance gains for stored procedures.
And if you do have large enough of a team, it is a great way to encapsulate database logic too.
Different strokes for different folks. :)
Dec 11, 2009 at 5:50 AM I agree that there's no "wrong" or "right" when it comes to stored procedures. If you work on an internal enterprise application with a lot of complex DB stuff going on (and you have a DBA), things like sp's and views can be extremely useful and appropriate.
But if you develop web applications for distribution and need them to be portable and deployable on multiple platforms, the use of sp's is not really feasible.