DataMgr 2.2 is Gold!

After more than a year in development, including plenty of help from others, DataMgr 2.2 is now in final release state.

(What is DataMgr?)

As of this version, DataMgr will now automate database interactions for a large number of databases and CFML engines.

Databases

• Apache Derby
• MS Access
• MS SQL Server
• MySQL
• Oracle
• PostgreSQL

CFML Engines

• ColdFusion MX 6.1
• ColdFusion MX 7
• ColdFusion 8
• OpenBD 1.0
• Railo 3.0.1

DataMgr has a small footprint and doesn't dictate how you must code in order to take advantage of it - you can simply use it wherever you would normally hand-code simple queries. (Data Access Layer Comparison)

New features in 2.2 include:

• Complete Documentation
• Automatic Database Detection
• New Supported Databases
  • Apache Derby
  • Oracle
• New Supported CFML Engines
  • Railo 3.0.1+
  • OpenBD 1.0+
• New Methods:
  • removeColumn
  • updateRecords
  • deleteRecords
  • getFieldLength
  • removeTable
  • getDefaultValues
  • getBooleanSqlValue
• New Relation Field Types:
  • has
  • hasnot
  • math
  • now
• New getRecords() arguments
  • filters
  • advsql

• loadXml():
  • Added optional filters elements in relations.
  • New "checkFields" (and "onexists") attribute for seed data
• SmartCache (experimental feature)
• saveRelationList() now works on fields without a compound primary key

DataMgr is open source and free for any use. You can see it in action on the DataMgr demonstration or download it from RIAForge.