• Introduction
  • What is DataMgr?
  • Exceptions
  • Contributions
• Basic Functionality
  • Getting Started
  • Structures in DataMgr
  • Save Data
  • Replace cfinsert/cfupdate
  • Replace SQL Inserts and Updates
  • Delete a Record
  • Get Records
  • Check Existence
  • Truncate Data
  • Change Sort Order
  • Save Many-to-Many Relationships
  • Update Multiple Records
  • Delete Multiple Records
  • Synchronize Database Structure (ActiveSchema / loadXml)
    • Define a Column
    • Remove a Column
    • Remove a Table
    • Define / Introspect Table
  • Seed Data
    • checkFields
  • Indexes
• Advanced Functionality
  • Logging
  • Simulated Database
  • Specials
    • Special Date Type
  • Relation Fields
    • Aggregates
    • Labels
    • Concatinations
    • Lists
    • Has / HasNot
    • Math
    • Now
    • Custom
  • "ftable"Attribute
  • Migrating Fields
  • Filters
  • Named Filters
  • Insert Custom SQL
  • SmartCache
  • Extending DataMgr
  • Database Adaptor
  • Is Deletable
• Informational Methods and Extra Functionality
  • Table Existence
  • Get Fields Meta Data
  • Run SQL Commands through DataMgr
  • Convert MS Word Character to ASCII
  • Get the Datasource that DataMgr is Using
  • Find out what Databases DataMgr supports
  • View DataMgr's Table Definitions
  • Get Methods SQL
  • Apply List Relations
• Change Log
  • Change Log

DataMgr Information

Download from RIA Forge

API Documentation

XML Schema

Demonstration Site

Blog Entries

DataMgr CFC Docs

Subscribe to DataMgr

Email:

Visit this group

What is DataMgr?

DataMgr is a database abstraction tool to simplify common interactions with the database. This encompasses three major types of functionality:

• CRUD: Database reads/writes including those of the type performed by cfinsert/cfupdate
• ActiveSchema: The ability for your code to define your database structure. DataMgr can introspect the database structure or it can define it.
• Prototyping: The ability to use simulated data for prototyping (much like QuerySim, but more powerful and less work).

Additionally, DataMgr provides some advanced functionality that allows you to define special behaviors and relation fields that can dramatically assist development. Taken together, these features can effectively create interactions with the database that fit the way we develop web applications.

DataMgr could be viewed as a competitor to an ORM approach - though it doesn't require the same types of interactions. While ORM solutions effectively change the perspective of development from database to object, DataMgr maintains the database perspective, but makes common database interaction code more concise and powerful.

DataMgr currently supports the following databases (others are generally easy to add):

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

DataMgr currently supports (and has been show to work in) the following CFML engines:

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