Run Time Access

Live Demonstration

- Table Editor

RTA comes with a table editor which lets you view and edit any of the tables in your RTA program. The table editor is composed of four short PHP programs which use the information in the two system tables to figure out how to display and edit the other tables in the program.

Click on the link below to give it a try.

You might want to try changing one of the "notes" fields in mytable. Be sure to hit 'reload' to see the effect of your changes.

- Virtual File System

RTA provides a /proc-like access to your program's tables as well as PostgreSQL-like access. In our demo application we have mounted the RTA virtual file system under the root of Apache. This lets you browse the application's tables as directories and files visible with your web browser. Click on the link below to give it a try.

- Direct psql Access

If you have the 7.2 or 7.3 PostgreSQL command line tool psql on your system you can access our demo application directly with

     psql -h -p 8888

Once connected, try a few of the following simple SQL commands.

     SELECT * FROM mytable;
     UPDATE mytable SET myint=4 LIMIT 5 OFFSET 10;
     SELECT * FROM mytable;
     UPDATE mytable SET notes="Hi Mom!" LIMIT 1 OFFSET 0;
     SELECT name FROM rta_tables;