MacSQL 2.0, the latest version of Runtime Labs’ database management solution for the Mac, is now available. A fully AppleScriptable application, MacSQL gives Web authors, publishers and developers a simple, graphical way to interact with SQL databases.
“We are very pleased to offer MacSQL 2.0 to the Mac community” said Mark Lilback, president of Runtime Labs, in a statement. “MacSQL fills a definite need for those Mac users who require an easy to use application for working with SQL databases.”
Included in MacSQL are native drivers for MySQL, Microsoft SQL Server, ODBC (with the Merant ODBC Driver Manager installed on Mac OS 9) and Oracle (on Mac OS X via JDBC). MacSQL 2.0 includes several new and upgraded features from the original shareware versions of MacSQL, Liback said.
The update offers the ability to connect to MySQL, SQL Server, Oracle and ODBC database servers. It runs natively on Mac OS 9 and Mac OS X. MacSQL 2.0 offers spreadsheet-like viewing/editing of remote data and a Web Script Assistant that will generate PHP or Embeded Perl to interact with a database. It has complete AppleScript support, including recordability and the ability to save frequently used queries as scripts for later execution.
MacSQL 2.0 users can create a “table tool” to help visually design tables. It sports a multi-panel display of schema including databases, tables, columns and indices. The newest version adds the ability to export data as SQL commands, tab-delimited text, comma-separated text, or directly to Microsoft Excel. You can also now access SQL files and data in CSV or tab-delimited text files.
MacSQL costs US$249, but a “lite” version is available for $99. A demo version, which expires after 10 days, can also be used for a test drive. Previously registered MacSQL users can upgrade to 2.0 at discounted prices. MacSQL 2.0 requires a PowerPC computer running Mac OS X or Mac OS 9.x with CarbonLib 1.3.1 or greater installed. ODBC support requires the Merant ODBC Driver Manager. Oracle support requires the Oracle JDBC for Java 2.
MacSQL 2.0 and MacSQL 2.0 Lite can be purchased and downloaded at the Runtime Labs store. The demo version can be found at the company’s download page.