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.
What's new in ProSQL
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 AppleScript commands.
Support for Mac OS X 10.3 "Panther".
Single-file application distribution for easy installation and updates.
New rendering system for displaying on-screen queries, resulting in query speed increases up to 400% (compared to ProSQL 1.1.4, the last release).
Drag-reorderable entries in the New Table editor, SQL Script Builder, Query Builder, and SQL Favorites windows.
Redesigned database connection dialog to facilitate easier access to database servers.
Refinements for use on Mac OS X, including smooth window resizing and faster GUI performance.