Relational Deletes in MySql and Foreign Keys

Managing relational tables in a database is a topic that all developer will eventually bump into. There are quite a few ways of managing relational data, and the best solution sometimes can be hard to find. As a developer you have to look at the scope of the application, the types of tools you have on hand, and where you want the responsibility for the referential integrity to reside. The most often used ways of maintaining referential integrity are as follows:

Tracking Flash – Sift Metrics Private Beta

One of the projects that we’ve been working on over here is the issues of tracking flash creative; not only on our own sites, but also flash assets that may be spread out over several URLs, such as a banner advertising campaign. Over the years, we have also noticed a surprising lack of support in existing metrics programs for flash creative. If the product offers a API, it is typically poorly defined and implemented, relying on calls in the flash player to on page or external JavaScript.

To counter these problems, and largely for our own uses, we’ve created a fully ActionScript based tracking solution, called Sift Metrics. Sift presents a clearly defined API for goal tracking on flash creative.