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 [...]

Picalo can connect to most relational databases. It can also load data from text files (CSV, EBCDIC, fixed width, etc.) and from email applications.  It provides a visual query editor (although we’d like to make it better) and can send any type of SQL to the engine of your choice.
As of 2010, Picalo ships with [...]

Picalo can load data from a variety of text files.  These data come into Picalo as tables.  You can work with them immediately, or you can push them up to a relational database.  As of 2010, Picalo imports the following types of files:

Delimited text files like Comma Separated Values (CSV), Tab Separated Values (TSV), and [...]

Picalo supports a number of languages, including English, two types of Spanish, Portuguese, and Italian.  We also included a few fun languages for testing purposes.  If you have a few hours, please translate Picalo into your language!

Picalo contains a large library of functions that help users analyze their data. The Function Composer (pictured above) lists all the available functions with their documentation, parameters, and return values.
The filter wizard helps users filter tables using exact values, simpler patterns and wildcards, or full-power regular expressions.  This is shown below:

Scripting in Picalo is great, but the reality is that most users will go only as deep as the menus do.  That’s where detectlets come in: they allow you to easily add a wizard interface to your scripts.  With detectlets, script-savvy users can share their work with others in the group, who see the scripts [...]

Picalo is all about automation.  The software developer believes strongly that fraud detection is best done through scripts.  Scripts provide documentation, continual improvement and reuse of routines, and most important, speed.
Picalo uses the excellent Python programming language, rated by Tiobe as one of the most popular languages in the world.  This provides a full-featured language as [...]