Froq 3 Features
At home at macOS Sierra
Froq feels right at home at latest macOS. With it's new vibrant window, Froq fits right in between all those other Mac programs.
With features such as the new full screen support, the version browser (with Time Machine support) and the auto save and session restore functionality, working with Froq become has become even more natural and easier.
A new browsing experience
Froq 3 comes with a whole new browser. All elements are directly visible and segmented by type, topped of by the trusted browser search field.
The browser has been extended with favourite and recent items, making navigating even more quicker.
The main window now contains 4 optional panels. Next to the browser, a persistent Inspector panel is now always available next to the content of the selected element. Above the content the SQL Editor can be opened to execute custom queries, below the content a log can be opened registering every action you have perform.
Improved SQL Editing
The SQL Editor has been thoroughly updated, to better help you edit SQL. The updated interface now tracks line numbers, helping you better navigate through your code. Froq now better understands the SQL you type, it now offers relevant completions when possible, helping you to write better SQL more quickly.
Froq 3 contains a new Procedure Editor. With it, you can edit functions, procedures and, with the Oracle, database packages as well. Select a function or procedure to open the procedure editor, edit it's code with the same new features as the SQL Editor, build it and execute it.
Welcome to easier connection handling
The new Connection panel lets you sort, group and easily search for your connections. Combined with the colour labels, the right connections are even faster to find.
The new Connection panel allows you to test a connection before creating it, vastly improving the process of finding the correct information.
Improved connections support
Froq lets you connect with Oracle, PostgreSQL, MySQL and SQL Server databases. For Oracle it now prefers connecting to service ids before tns connections, allowing you to connect faster. SQL Server connecting has been updated with support for Windows Authentication.
With Froq you can create various objects. This can be done from the object menu or directly from the browser. Select the appropriate Assistant and follow the steps to create a new object. Depending on your database type support for different Assistants are available:
The Table, Index, Constraint Assistants were already available, new are the Sequence, Function, Procedure and Package Assistants.
Import and Export
Froq has been updated with improved Export support. Using the Export Assistant you can now easily select what you want to export and how to do this.
The new Import Assistant
The new Froq Import Assistant helps you import data into a table. The import assistant can import text formats as well as XLSX (Microsoft Excel) files. The text imports can be comma separated as well as fixed with. Froq automatically detects the import format, while allowing you to tweak the import settings.
Froq supports a QuickLook plugin, to further the integration in the Mac OS X environment.
Froq 3.1 with TouchBar support
As of the 3.1 version Froq supports a context-sensitive TouchBar. Starting when starting Froq or opening a new tab, the TouchBar will provide the most recent made connections. When viewing a resultset the TouchBar helps with easy filtering. During SQL editing and in the Procedure Editor the TouchBar helps you by providing basic commands and SQL suggestions