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.

Window overhaul

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.

Procedure Editor

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.

Froq Assistants

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.

System plugins

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