Smoke, flames, explosions and other effects are possible with Particle Physics! Collision detection can also be used for particles for realistic, physics-based effects.
Revolution 4: The Better Way to Construct Software
More...
Valentina DB: The Fast, Cross Platform Database System
More...