ProSQL offers users the ability to directly access the tables and data in their database, display and search that information, and generate reports without requiring any knowledge of SQL query syntax or database engines. Advanced users can utilize standard SQL syntax to perform queries from within the 'SQL Console'. Furthermore, data can also be stored and retrieved locally using ProSQL's integrated single-user database engine.
Version 2.0 adds the following:
- SQL Favorites stores commonly used SQL statements, allowing for easy "quick execution" from the SQL menu, or custom execution using the Favorites menu in the SQL Console.
- New AppleScript query automation capabilities, allowing ProSQL to act as a helper application to other applications for SQL data retrieval. ProSQL can pass or tab-export any query via
PowerPC, MacOS 8.6 or later
*Previously available here