Hurricane Rita caused a lot of problems for us, leaving us without Internet access for months. As Humberto approached, we weren’t too worried since it was only a category 1 hurricane. Unfortunately, it hurt us.

Power was just restored at Runtime Labs HQ and we’re hoping to get caught up on email/phone messages over the weekend. Today’s priority is household cleanup — throwing out spoiled food, restocking the fridge, cleaning branches off the yard, etc. We’re also hoping to get a generator setup for other RTL staffers today.

Runtime Labs is proud to announce the release of MacSQL 3.1. This free, major upgrade offers a number of new features including:

• MacSQL is a Universal application that runs on PowerPC- and Intel-based Macintoshes.
• 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.

For users of MacSQL 3.1b19 (our last beta release), the following changes were made to the final version:

• New Connection Dialog: fixed crashing bug when window wasn’t closed by
  Connect or Cancel button.
• SQL Server: fixed potential crashing bug when connected to SQL Server 7.
• Create Table Tool: database menu selets default/current database correctly.
• Export: xslt label no longer appears unless exporting xml.
• Statistics: now records server version numbers.

MacSQL 3.1 is available from our downloads page.

MacSQL Version 3.1b19 is now available. We are considering this version to be a final candidate release — unless a significant bug is found that we feel must be addressed, there will be no changes between this version and the final release of MacSQL 3.1 next week. (The one exception is documentation — we still have a little work to complete on the user manual.)

An updater and full download are available from our downloads page.

Changes in this version include:

• Fixed bug that could result in crash when document was closed
  (particularily if services or applescript was used).
• Revert Document menu item now only enabled when document is dirty.
• Query Editor and Schema Viewer properly reload data when document is
  reverted.
• Schema Viewer: add/edit relationship save button is now dynamically
  enabled based on if there is a name and destination column.
• Statistics: help button works.
• Statistics: prompted at initial launch to enable/disable stats reporting.