Directly Viewing/Editing Rails Databases

The "heart" of Track Magic is the ability to interact directly with the data in any Rails database without using a web browser (of course Track Magic doesn't prevent you from also accessing the data with a web browser, in fact, you can do both at the same time). Track Magic includes powerful and easy-to-use visual tools for directly viewing, editing, analyzing and printing any database managed by Active Record. Track Magic seamlessly supports your existing Rails applications and maximizes your productivity while creating, managing, testing and deploying Rails applications. Track Magic accesses your databases through standard Active Record API’s so absolutlely no modification to your Ruby code is required, and you can access the data in both development and production environments.

002_OrdersDataSheet
Data Sheet View
001_ExportFixtureMenu
Rails Menu

Track Magic and Panorama

Track Magic is implemented in Panorama (ProVUE Development’s ultra-fast RAM based database engine) and Ruby. For high performance Track Magic uses Panorama to keep a mirrored RAM based copy of the Rails tables you want to work with. Changes made to the RAM based mirror are automatically uploaded back to the SQL server thru Active Record. By using a RAM based mirror Track Magic facilitates advanced high speed searching, rapid “en masse” data modifications, and powerful analysis/reporting tools including cross tabulation and interactive data outlines. The diagram below illustrates how Panorama and Track Magic interact with your Ruby on Rails applications.

FlowDiagram01

For more information on Panorama please see the main ProVUE Development web site.