MacSQL is a robust solution for database management on the Macintosh. 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: Version 3.0.2: Fixed bug introduced in 3.0.1 when saving password to keychain for the first time. Create Table Tool: fixed crashing bug when adding a column with servers that don't require database selection. FileMaker Synch: fixed bug with FM 7.0v2 when synching via AppleScript. FileMaker Synch: fixed bug where some SQL column names might not be offered when mapping fields to columns. FrontBase: fixed bug that would ocassionally stop row fetches after 10 rows. MySQL: fixed display problem with decimal data type definition. Oracle: numeric data is designated as FLOAT or DECIMAL if appropriate, otherwise NUMBER. Schema Viewer: correct column edited when columns have been re-sorted. Schema Viewer: column details now has an Unsigned column when working with MySQL. Schema Viewer: document remembers order/width of table showing column, index, relationship details. WebScript: fixed simple search bug on line 50 of generated page. |  |
| 
