Sep 27, 2009 Coldfusion, Coldpress
In my last post:
ColdPress: SQL Server or MySQL or ORM? I had raised the question of what type of data model I should use for ColdPress, should it be SQL Server, MySQL or some other ORM? Steve Bryant was kind enough to suggest in the comments that I use his DataMgr CFC, which supports multiple databases out of the box, will manage your table structures for you (read: no more sql scripts) and even has the ability to simulate test data.
Hat’s off to Steve for this great tool and I have a feeling I’ll be blogging about it more, the more I use it.
Steve Bryants DataMgr CFCIf you haven’t already, be sure to hit
ColdPressBlog.com to sign up to be one of the first to beta test this brand new app.
September 28th, 2009 at 2:33 am
I think its great that you are writing a blogging application but the name “could” be something a little more original instead of wordpress err coldpress.
September 28th, 2009 at 1:58 pm
September 28th, 2009 at 2:02 pm
I personally think DataMgr might not be a good choice down the road when you need more than just read/update/delete using the XML. Then you’ll need to write custom CFQUERY for all DB dialect you support.
September 28th, 2009 at 3:55 pm
Why do you think DataMgr is risky? What do you think you would be able to do with another solution that you could not do with DataMgr?
September 28th, 2009 at 8:35 pm
As I understand it DataMgr has a function that allows me to write custom SQL, so I think I should still be alright.
Steve: Am I right on that?
All: Yes the name is insanely creative.
September 28th, 2009 at 8:55 pm
Yes, you can certainly add in your own custom SQL. It is important to write SQL that will run on any database, however, if you want your app to remain cross-database compatible.
I do run into some situations of sufficient complexity that I abandon DataMgr in favor of cfquery, but in all of those cases I would have had to write a custom query regardless of the data access layer being used.
Thanks for the kind words on DataMgr, BTW. If you run into any issues, let me know.
September 29th, 2009 at 10:48 pm
I tried using DataMgr to implement a rather simple OO blog app, but I remember I had to resort to using cfquery and bypass DataMgr because I simply can’t use DataMgr to do what I needed.
I personally prefer using CF9’s orm, but I guess that was not the goal for ColdPress to only work in ColdFusion 9.
September 30th, 2009 at 2:03 pm
You say “I had to resort to using cfquery and bypass DataMgr because I simply can’t use DataMgr to do what I needed.”
So, what couldn’t you do with DataMgr that you needed to do?
November 8th, 2009 at 9:55 pm