Search Mac Software Downloads
|
MacUpdate Desktop 5     |     Weekly Popular  |  Hot Picks  |  iPhone  |  Mac OS X  |  About     |     Deals: Daily  /  Discount StoreAdd a File +
DESCRIPTION
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.
Download Now
WHAT'S NEW
Version 3.1:
  • 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.
REQUIREMENTS
Mac OS X 10.4 or later.

Bookmark and Share

SCREENSHOT

Developer:Runtime Labs, Inc.
Downloads:16,917
  - Version d/l:2,624
Internet:Servers
License:Demo
Date:12 Sep 2007
Platform:PPC/Intel
Price:$249.00
RATING
****.
OTHER PEOPLE SUGGEST
    No similar products suggested yet
    Suggest something else:
    MacSQL User Reviews (1 post)Write A Review
    sort: smiles | time
    Jan 26 2005
    ****.

    ANONYMOUS  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)

    praisebury
    0
    [ Reply ]