Drupal and Flex are used here to give easy and dynamic access to the data in the LiteratureReferences table in the Reactome online genomics database. Reactome runs on a MySQL database, and the data is pulled via SQL queries of the table, and converted first into PHP objects, via a server-side PHP script. The PHP objects are then converted into ActionScript objects, via the AMFPHP library, and sent as binary data over the internet. The Drupal client serves web pages (such as this page) with links to the data presented as a Flex user interface ("widget").

On this page, hovering over the link below will partially display a jQuery Ajax iFrame showing a Flex interface that can give access to the Reactome Literature Reference table. If you wish to see the full display, clicking on the link will display the full page dynamic Flex interface to the MySQL DBs, which you then can explore in detail. To return to this page, hit the back button.

Reactome Literature Reference table When you are ready to view the Reactome Literature Reference table, hover over this link.

Note that the data in the Flex table can be sorted on any column, the columns can be dragged into any order, and it also is possible with Flex datagrids (but not shown here) to edit data in any cell, and save the edited data back into the locally-installge Reactome database, or into a Drupal node, etc.

The goal of this type of combined Drupal / jQuery / Flex interface is to provide rapid and easy ability to view large, complex data sets in the iFrame, by just hovering over the link, and then if you find something that you want to explore, you can just click on the link to get access to the full Flex datagrid functionality and data.