Above is the Windows version of Picalo.  The main screen is split into three areas:

• The project browser (left side) shows the tables, database connections, saved queries, and scripts available in this project.  These correspond to a directory on the user’s machine.
• The work area (top tabs) shows the tables or scripts that are currently open and in memory.  It provides a spreadsheet-type view of the data and filter capabilities along the top.
• The shell (bottom tabs) provides a direct interface to the Picalo engine.  As the user interacts with tables, menu options, etc., Picalo shows the actual commands being run behind the scenes.  The user can simply use the graphical menus or type commands directly into the shell.  The Script Output and History tabs provide feedback from scripts as well as a full history of everything done in the project.

Picalo runs on Windows, Mac, and Linux. The codebase is identical across the operating systems, and the menus and interface work exactly the same.  Picalo can also run in text-only mode with no graphical user interface at all.  This allows it to be embedded into other systems.

The following graphics show the Mac and Linux versions of Picalo: