Entrance IDE for MySQL

ENTRANCE IDE FOR MYSQL

Entrance IDE, shown above, is a desktop application combining SQL browser functionality with tools for making charts and performing data analysis.

Its main strength is that charts can be specified using a SQL-like syntax . These “PLOT” commands can be embedded with other MySQL commands in SQL scripts.

The same script language can also be executed using a command line tool or EntranceServlet.

NEW:

A US STATES COLORING BOOK

Use Entrance coloring books to report election results or make marketing “heat maps”.

Read more about them here.

REGENERATE QUERY RESULTS AUTOMATICALLY

The latest version of Entrance improves the way it reruns scripts. Now you can set different timer delays for foreground and background tabs, and the settings and open tabs persist between sessions.

ANIMATION AS AN ANALYTIC TOOL

Entrance supports "flip book" animation, a technique that is useful for spotting time-related patterns in XY data. Here is an example you can try for yourself.

RUN ENTRANCE SCRIPTS FROM THE COMMAND LINE

Beginning with Version 1.2.74 Entrance scripts can be run from the command line utility to generate PNG files.

ANALYZING WEB SERVER LOGS

In the first in a series of application notes on mining web server log data, we'll you how to use the MaxMind GeoLite or GeoIP datasets with Entrance to find out where your web site visitors are coming from. Click here for more.

WRITING EXTENSIONS IN APPLESCRIPT

On a Mac, you can embed AppleScript in EntranceExtensions This note shows you how, and includes an example that connects Entrance to Google Earth.

Chart of the Week:

Madoff’s Golf Scores