MacSQL is a robust solution for database management on the Mac. A fully AppleScriptable application, MacSQL provides Web authors, publishers, and developers with a simple, graphical way to interact with SQL databases. MacSQL supports native connections to MySQL, Oracle, Sybase, PostgreSQL,
Microsoft SQL Server, OpenBase and FrontBase. Other features include a comprehensive Schema Viewer for viewing and editing schema, a Create Table Tool for designing new tables, the ability to generate PHP and Embed Perl pages, FileMaker Pro synchronization, import of text files, and export of data in
tab-delimited, CVS, SQL commands, XML, HTML, or Microsoft Excel format.
What's new in MacSQL
MacSQL is a Universal application that runs on PowerPC- and Intel-based Maces.
A new MySQL 4.1+ plugin that supports connecting to MySQL 4.1 and greater database servers (fully licensed from MySQL AB).
A new PostgreSQL 8.1+ plugin offering greater speed and SSL support.
Job Manager supports scheduled, unattended exports including rotation of backups.
Support for generating Entity-Relationship Diagrams using OmniGraffle and OmniGraffle Pro.
Documents are now indexed by Spotlight.
SQL Server plugin updated and includes full Unicode support.
Query editor now supports expressions with function calls, and the distinct qualification.
FileMaker Pro Synchronization now supports connecting to FileMaker via ODBC.
WebScript Assistant supports PHP 5.
Create Table Tool redesigned including support for MySQL enum and set data types.
Query Maker supports autocompletion.
Text imports now allows mapping column names based on data instead of blindly picking the column order.
Spreadsheet supports LinkBack
Supports Growl for Import, Export, FM Synch notifications.