MacSQL 3.0 is a major update that provides the following new features:
| • | Interface completely rewritten from the ground up. |
| • | Query editor: visual editor for building SELECT queries (including table JOINs). |
| • | Flexible data views: view query results as text, in a spreadsheet, or in a single-record form view. |
| • | Query folders: save and organize frequently used queries in the query drawer. |
| • | Syntax highlighting: keywords, quotes, operators, and comments are colored as you type queries. |
| • | Relationships: define relationships between tables for JOIN support throughout MacSQL (ideal for MySQL which does not support foreign keys). |
| • | Enhanced Schema Viewer: now uses a column format to display columns, indexes, foreign keys, constraints, and relationships. |
| • | User management: add/edit users and their privileges (Oracle and MySQL only). |
| • | Support for table options: Create Table Tool offers support for MySQL options such as table type and for Oracle options such as tablespace and pctfree. |
| • | Rendezvous support: automatically finds Sybase and PosgtreSQL servers on the local network. |
| • | Expanded export options: save exports directly to Microsoft Excel®, text, SQL, XML, or HTML files. |
| • | Remembers open documents: optionally opens all documents that were open the last time the application quit. |
| • | WebScript Assistant enhanced: new templates added and fully supports HTML 4.0. |
| • | Significant performance improvements. |