Is there gateway watching changes in a database e.g. new table records?

[AXcrystallis]

Hi all,

I search for a gateway watching changes in a database (e.g. insertions of records in a table etc), as DirectoryWatcher does in a directory for files when creating / modifing / deleting them.

Which of the existing CF gateways fits better to this role? or could fit with some changes???

Is out there any custom made CF gateway doing it??

Thanks in advance

[Charlie Arehart]

There is nothing in cf that can do this, no.

What you're looking for would be the job of your database server, or of a tool designed to watch your db server. That tool also would have nothing to do with CF.

I hope that clarification would be enough to help motivate you to look elsewhere to find what you need, but in case someone may want to chime in with more specific suggestions, why is your database server? 

[BKBK]

As Charlie says, correctly, there is nothing in CF to do this. For good reason. If there were, it would have been a bad idea. I can think of  2 reasons:

1.  Having CF do that would go against at least 2 major software best-practices: Responsibility Assignment (GRASP) and Separation-of-Concerns. The database has the most knowledge of the task, and so should be responsible for it.
2.  Having CF do that would be a security risk. The database is a meeting point for various applications and servers. If you could use CF to monitor changes in the database, you would be able to gain insight into the applications and services of others.

A suggestion: do a google search for how to track changes in the database