Steve Bryant - DataMgr

DataMgr 2.5 is Gold!

Mon, 04 Mar 2013 10:30:00-0500

One would be forgiven if they mistook DataMgr for abandoned software. After all, I announced work on DataMgr 2.5 back in August of 2009 and come February (now March) of 2013 and still no official release of 2.5 and no word since DataMgr 2.5 Beta 3 was released more than a year ago. Well, that changes here. [More]

DataMgr 2.5 Beta 3

Thu, 02 Feb 2012 14:00:00-0500

Happy Ground Hog's Day! It looks like I have completely stopped releasing open source project lately. Hopefully I can get back on track. More than a year after releasing DataMgr 2.5 Beta 2, I am finally releasing DataMgr 2.5 Beta 3. So, what took so long? Neglect, basically. I have just been busy with other things. Even so, I think this is a very good release and should be a close match for the final release of version 2.5. [More]

DataMgr 2.5 Beta 2

Mon, 13 Dec 2010 15:20:00-0500

What a fun weekend! We got to celebrate my brother-in-law's birthday, I took my girl to a Christmas party, my kids turned 23 months old, and (more relevant to this blog) I finished the second beta of DataMgr 2.5. (What is DataMgr?) So, what is new in DataMgr 2.5 Beta 2 (since Beta 1)?

Optional "XmlData" argument to "init" method (calls "loadXml" automatically)
Filters (and named filters) can now accept CF-style operators (like "GTE" for ">=") as well as SQL-style operators.
Optional "truncate" argument to automatically truncate data to fit in database while saving data.
Optional "fieldlist" argument to limit the data that can be changed while saving data.
New methods to return SQL used internally: getSelectSQL, getFromSQL, getWhereSQL. This is very useful with CF_DMQuery.
New "applyListRelations" method (take tablename,query) for post-calculation of list relations for getRecords() - also useful with CF_DMQuery
For tables with a simple (single-field) primary keys, the ability to pass a single value into the "data" argument for getRecords() instead of a structure of values.
New "isDeletable" calculated field available to "getRecords" determines if each record can be deleted based on "onDelete" property of relation fields.
Verifications on record deletions now check deletes that DataMgr would cascade prior to deleting record.
New "ftable" attribute (this deserves its own blog entry).
Some small MS SQL specific improvements
A few very minor bug fixes

Feel free to download DataMgr 2.5 Beta 2 (zip) or use the repository for the Bleeding Edge Release. For the latest full release, use the DataMgr RIAForge page. DataMgr is open source and free for any use.

Manager.cfc and Elasticity

Tue, 30 Nov 2010 10:30:00-0500

Whenever I see any example saying "See how easy this is!?", I inevitably think "What happens when my needs differs a bit from the expected?". My worry is that I could start with a situation for which the tool is a good match and then things change a bit. Do I have to abandon the tool altogether in those cases? Basically, I always want to know how much elasticity any solution has. More often than not, it seems, systems that are extremely efficient have very little elasticity (think of airline schedules where bad weather anywhere effects flight patterns everywhere). I think that the past several blog entries on Super-Easy CRUD/File Management have demonstrated that the com.sebtools package provides great efficiency for basic CRUD and file tasks. What it hasn't demonstrated (yet) is how elastic it is when the problem is more complicated than what com.sebtools is built to handle. [More]

Introducing CF_DMQuery

Fri, 01 Oct 2010 10:00:00-0500

One of my favorite things about ColdFusion compared to other languages is the CFQUERY tag. It is just a real thing of beauty. I rarely use it any more, however, because I use DataMgr for my every day CRUD work (actually I use Manager.cfc, but that is another story). I rarely have to write any SQL code any more. Rarely isn't the same as never, though. I have actually found a spectrum of cases for which I need to write custom SQL. First is the case where I need something more complicated than what DataMgr is built to handle and I don't need any of the functionality that DataMgr provides. In this case, I can easily move to using CFQUERY and I do so happily. [More]

DataMgr 2.5 Beta 1

Thu, 02 Sep 2010 12:00:00-0500

So I released the Alpha of DataMgr 2.5 more than a year ago. This is about as long as I have gone between a release. Why so long? Well, basically I have been neglecting DataMgr a bit to work on other things (more on that in another post). Also because DataMgr has been doing everything I want. Finally, however, I have the first beta of DataMgr 2.5 ready. [More]

DataMgr 2.2.0.3 Released

Wed, 04 Aug 2010 14:30:00-0500

DataMgr 2.2.0.3 Released This may be the first release of DataMgr in which I have made no significant contribution myself. This is a small point release, but could actually have a big impact. This release consists of a few small database-specific bug fixes from the 2.5 branch and two significant enhancements. [More]

DataMgr hits 2000 Downloads!

Tue, 08 Dec 2009 08:20:00-0500

I happened to look at my RIAForge page yesterday and I saw that DataMgr has been downloaded 2,000 times. This doesn't actually encompass all of the downloads as the project had been around since before I put it on RIAForge, but it is still an exciting milestone. What is DataMgr? This really inspires me to double my efforts on DataMgr 2.5.

DataMgr is Better than ColdFusion ORM

Tue, 22 Sep 2009 09:00:00-0500

I have been thinking this for some time, but it seemed like hubris (and flame bait) to say it. So be it - it needs to be said. I worry that ColdFusion ORM is being / will be marketed where it isn't appropriate. (What is DataMgr?)

What is Better?

It can't be helped, "better" is a word that only makes sense in the context of goals to be met. After all, it is impossible to tell if a sedan is better than a truck unless you know your goals. Do you need to get to work on low gas mileage or haul cargo? I will use the criteria that Adobe ColdFusion engineer, Rupesh Kumar, has laid out in "ColdFusion ORM - An Evolution in building datacentric application": [More]

Extending DataMgr 2.5

Thu, 03 Sep 2009 10:00:00-0500

One of the new features in the upcoming DataMgr 2.5 release that I am really excited about is the ability to extend DataMgr to add or modify its functionality to your liking. This is a feature that John Farrar really had to push me into. Now that I finally see the light, however, I am really excited about the possibilities. [More]

DataMgr 2.5 Alpha 1

Tue, 25 Aug 2009 12:45:00-0500

It has been seven months since DataMgr 2.2 was released and now DataMgr 2.5 Alpha 1 is finally available. I have gotten quite a bit of help on this version, both in terms of ideas as well as code. [More]

DataMgr Basics

Mon, 22 Jun 2009 09:00:00-0500

I saw a comment recently that said of DataMgr "His project does a lot more than what i need, otherwise I would use it myself. ". This was in the context of suggesting someone look at DataMgr, so I certainly don't want to seem ungrateful. Even so, this got me thinking. I have certainly seen programs that do so much that the extra stuff gets in the way of doing the easy stuff. I don't think that is the case with DataMgr, however. The download for the current version of DataMgr (2.2.0.2) is a 71KB zipped file (under 400KB unzipped) - hardly massive. So, how hard is it to use? I have a database on my local computer named "TestSQL" that has a table named "widgets". Fields in this table include "color" and "size". Here is actual code to save a widget to the widgets table: [More]

DataMgr 2.2.0.2 and com.sebtools Build 2

Mon, 15 Jun 2009 07:30:00-0500

I just fixed a couple of bugs in DataMgr which caused an update in both DataMgr and in the com.sebtools pack. The com.sebtools package also includes an update to FileMgr among other components. [More]

Using Filters in Relation Field Definitions

Mon, 04 May 2009 09:00:00-0500

Using Filters in Relation Field Definitions It recently came to my attention that I haven't yet covered in blogs or documentation one of the most powerful features in DataMgr. I have covered relation fields and filters, but (until now) not how to use a filter in a relation field definition. [More]

DataMgr 2.2.0.1 Released

Fri, 24 Apr 2009 13:30:00-0500

In the last several weeks, I have gotten a few bug reports on DataMgr 2.2. Most of them are fixed in this release. [More]