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.
Create or modify tables with a visual interface without writing DDL manually.
Where it is: Catalogs › right-click › New Table / Edit Table
The Table Builder opens from Catalogs: click New Table in the toolbar or right-click an existing table and select Edit Table. Available on macOS, iPad and iPhone, and on all three it opens as a persistent Workspace tab: you can switch to another tab (for example Catalogs to check another table) and come back without losing your work.
The editor shows three tabs: Columns, Indexes, and Foreign Keys. When you finish configuring the table, click Apply to run the corresponding CREATE TABLE or ALTER TABLE on the server.
In the Columns tab, click + to add a column. Configure the name and data type (INT, VARCHAR, TEXT, DATETIME, DECIMAL…), the type argument (e.g. 255 for VARCHAR), and the options: nullable, primary key, unique, auto-increment, unsigned.
The default value can be none, a literal value, NULL, CURRENT_TIMESTAMP, or an arbitrary expression. You can also assign a charset and collation per column and add a comment.
New columns have no origin name. Edited columns retain the original name so ALTER TABLE can rename them correctly.
Keywords: column, data type, INT, VARCHAR, PRIMARY KEY, AUTO_INCREMENT, nullable
Manage table indexes: INDEX, UNIQUE, FULLTEXT, and SPATIAL.
Where it is: Table Builder › Indexes Tab
In the Indexes tab, click + to add an index. Choose the type: INDEX (standard), UNIQUE (no duplicates), FULLTEXT (full-text search on CHAR/VARCHAR/TEXT columns), or SPATIAL (geospatial data).
Assign a name to the index and select the columns it covers. An index can span multiple columns (composite index).
The primary key is defined per column from the Columns tab (the PK checkbox); it does not appear here as a separate index.
Define referential integrity relationships between tables.
Where it is: Table Builder › Foreign Keys Tab
In the Foreign Keys tab, click + to add a FK. Configure the source column, the reference database and table, and the referenced column.
Choose the ON DELETE and ON UPDATE actions: RESTRICT (error if integrity is violated), CASCADE (propagates the change), SET NULL (sets the FK to NULL), or NO ACTION (equivalent to RESTRICT in MySQL).
In MySQL and MariaDB both tables must use the InnoDB storage engine; engines without storage engines impose no such requirement. The builder generates the CONSTRAINT with an explicit name to facilitate future removal with ALTER TABLE … DROP FOREIGN KEY.