MacSQL
MacSQL
3.1

3.8

MacSQL free download for Mac

MacSQL

3.1
12 September 2007

Interact with mySQL and mSQL databases from your Mac.

Overview

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

Version 3.1:
  • 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.

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

1 MacSQL Reviews

Rate this app:

Anonymous
26 January 2005

Most helpful

As an MS SQL DBA who uses a Mac for preference there are only a couple of alternatives. Sadly although SQL4X-J is powerful it just doesn't "feel right" for me MacSQL is about 85% of the way to being a great app, but (for me) there are still a couple of niggles that mean I can't switch totally from Enterprise Manager on my VirtualPC... For personal preference I like the MacSQL interface and feel, but... There's a couple of things that are missing that won't get me switching from my VirtualPC for day to day management.... SQL4X-J is powerful, but I can't see it making my work day any easier However, MacSQL could with a couple of small enhancements, which I'd love to think are already on the to-do list... Stored Procedures. For me this is a must as for performance reasons I try and use Stored Procedures wherever possible (one of the sites I manage has over 2.5 million page impressions a day, and every one of those is dynamic from a database !) - being able to review, edit and execute SPs is important. Table Structure editing. I like the Table Create dialogue and would love to be able to grab an existing table into that interface when I'm adding/editing columns (rather than having the ‘add column' function). Would also be neat to be able to re-order columns in the dialogue. Also, in the current edit mechanism I can't change a column to become an Identity (if I forgot) Edit results from a query. When I get data back I'd like to be able to update it (or add rows back into the database). At the moment there is an icon for add/delete rows (but I've not seen it live). Query Editor won't let me run a query until I save it. Can be a nuisance. The Query Maker is good, but limited... It doesn't seem to support multiple tables (or sub selects etc) - in fact I find the two a little confusing ! Minor things; for Identity columns, being able to add the start and increment values would be handy would be good to be able to edit a free-form description. I document within the table structure in Enterprise Manager a lot and miss that facility
Like
Version 3.0.3
Anonymous
26 January 2005
As an MS SQL DBA who uses a Mac for preference there are only a couple of alternatives. Sadly although SQL4X-J is powerful it just doesn't "feel right" for me MacSQL is about 85% of the way to being a great app, but (for me) there are still a couple of niggles that mean I can't switch totally from Enterprise Manager on my VirtualPC... For personal preference I like the MacSQL interface and feel, but... There's a couple of things that are missing that won't get me switching from my VirtualPC for day to day management.... SQL4X-J is powerful, but I can't see it making my work day any easier However, MacSQL could with a couple of small enhancements, which I'd love to think are already on the to-do list... Stored Procedures. For me this is a must as for performance reasons I try and use Stored Procedures wherever possible (one of the sites I manage has over 2.5 million page impressions a day, and every one of those is dynamic from a database !) - being able to review, edit and execute SPs is important. Table Structure editing. I like the Table Create dialogue and would love to be able to grab an existing table into that interface when I'm adding/editing columns (rather than having the ‘add column' function). Would also be neat to be able to re-order columns in the dialogue. Also, in the current edit mechanism I can't change a column to become an Identity (if I forgot) Edit results from a query. When I get data back I'd like to be able to update it (or add rows back into the database). At the moment there is an icon for add/delete rows (but I've not seen it live). Query Editor won't let me run a query until I save it. Can be a nuisance. The Query Maker is good, but limited... It doesn't seem to support multiple tables (or sub selects etc) - in fact I find the two a little confusing ! Minor things; for Identity columns, being able to add the start and increment values would be handy would be good to be able to edit a free-form description. I document within the table structure in Enterprise Manager a lot and miss that facility
Like
Version 3.0.3