MacSQL
MacSQL 3.1
Your rating: Now say why...

(1) 3.75

Interact with mySQL and mSQL databases from your Mac.   Demo ($249.00)
Add to my Watch List
Email me when discounted
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
What's New
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.
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 more...
Requirements
Intel/PPC, Mac OS X 10.4 or later

*Previously available here



MacUpdate - MacSQL



    Be the first to recommend a similar software title.
MacSQL User Discussion (Write a Review)
ver. 3.x:
(1)
Your rating: Now say why...
Overall:
(1)

sort: smiles | time
burypromote


Anonymous reviewed on 26 Jan 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
[Version 3.0.3]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.

There are currently no ratings. Write a comment or review now.

Downloads:18,413
Version Downloads:4,120
Type:Internet : Servers
License:Demo
Date:12 Sep 2007
Platform:PPC 32 / Intel 32 / OS X
Price: $249.00
Overall (Version 3.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-1 of 1
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
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.


- -