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 [...]
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.
If 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.
9 Responses
Just a note to the name “coldpress” I find in the CF community that just about every application written has the word “cold” or “fusion” in it.
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.
I guess your Coldpress won’t be very OO?
Have you used DataMgr before? I think it might be too risky to just pick DataMgr just like that. Especially when your ColdPress project aims aims as high as being the CF’s WordPress.
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.
Henry,
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?
Henry / Steve
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.
Justin,
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.
Don’t get me wrong, I don’t think DataMgr is risky. I think picking DataMgr base on the fact that it will work across multi-DB can be a risky assumption.
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.
Henry,
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?
Such a useful blog