This page describes Calíope 1.5, the version we are building right now. 1.4 is finished and in App Review, and the store serves 1.3 on the Mac and 1.2 on iPad. The changelog says which version each feature landed in.

Adds an “Open in Calíope” button to every topic. It only works with the app installed.

Table Maintenance

Table Maintenance

Run ANALYZE, CHECK, CHECKSUM, OPTIMIZE, or REPAIR on selected tables.

Where it is: Workspace › Tools › Table Maintenance

Open Maintenance from the workspace navigation bar. Select tables using the left-side tree (you can select entire databases or individual tables). Choose the operation in the right selector and click Execute.

Per-table results appear in the bottom table with the message type (info, warning, error) color-coded.

The tree has a filter by name in its header, just like the SQL Editor: type part of a database or table name to narrow the list. Each database loads its tables the first time you expand it, so if you filter with databases still unexpanded, the footer tells you how many are missing and offers to load them. Select all does sweep the whole server and may take a few seconds.

Keywords: ANALYZE, CHECK, OPTIMIZE, REPAIR, maintenance, CHECKSUM

Operation Modifiers

Additional options that modify the behavior of the operation.

Where it is: Table Maintenance › Modifier Grid

The modifier grid lets you enable options such as LOCAL, FOR UPGRADE, QUICK, FAST, MEDIUM, EXTENDED, CHANGED, and USE_FRM. Available modifiers vary depending on the selected operation. For example, QUICK speeds up CHECK by skipping logical deletions, and FOR UPGRADE verifies compatibility with the current server version.

Keywords: QUICK, EXTENDED, FOR UPGRADE, LOCAL, modifiers