Softpedia >Mac >Network/Admin >Froq >  Changelog

Froq Changelog

What's new in Froq 4.1.1 Build 3554

Nov 8, 2022
  • Added support for macOS Ventura 13.0

New in Froq 4.1 Build 3550 (Sep 1, 2022)

  • Added native Apple Silicon support
  • Updated to Java jre 18
  • Improved import stability
  • Improved import speed
  • Added import support for XLSB files (Excel Binary)
  • Tabs can now also be organised across multiple full screen windows

New in Froq 4.0.4 (Sep 1, 2022)

  • Improved performance when adding / duplicating Oracle rows
  • Updated storing of cache files and filters
  • Updated Java backend

New in Froq 4.0.3 (Sep 1, 2022)

  • Improved Catalina support, fixed Window menu
  • Re-enabled Statement Recall
  • Re-enabled Activity Overview
  • Updated MimerSQL default auto-commit setting
  • Stability updates
  • Updated Java version

New in Froq 4.0.2 (Sep 1, 2022)

  • Fixed CSV export, stopping after finding an empty row
  • Updated Postgres connectivity
  • Stability updates

New in Froq 4.0.1 (Sep 1, 2022)

  • Fixed crashed on macOS Sierra and macOS High Sierra
  • Fixed crashed caused while loading certain meta-data
  • Improved persistency of stored resultset filters and sequences

New in Froq 4.0 (Sep 1, 2022)

  • Refreshed interface
  • Dark mode is now supported (macOS Mojave and later only)
  • New SQL Statement Analyse display
  • Autohiding tabbar
  • Fully customisable toolbar
  • Connectivity:
  • Added support for MariaDB driver
  • Added initial support for MimerSQL
  • Added support for Oracle connections with radius authentication, encryption and integrity-checks.
  • Added support for Postgress Json data type
  • Added support for Postgress ::func cast notation
  • Improved Synonym support
  • Improved Connection handling
  • Other:
  • Many stabilisation and performance updates
  • Improved SQL Editor and autocomplete performance
  • Fixed sorting in the browser
  • Fixes to MySQL export
  • Improved float value import
  • Minimum supported OS is now Mac OS X 10.13.2 (High Sierra)
  • Froq requires much less disk space

New in Froq 3.2 Build 3260 (Apr 3, 2018)

  • Added support for column remarks
  • Added basic partitioning info to MySql tables
  • Fixed stability of import as SQL statements
  • Fixed import of data with duplicate column names
  • Improved SQL Editor stability when using Emoji characters
  • Improved Postgres connectivity
  • Various stability improvements

New in Froq 3.1.1 Build 3242 (Oct 12, 2017)

  • Improved Query Analysis display
  • Improved Formatter, no longer breaks queries on multiple single quotes and pipes.
  • Added quote and brace completion when inserting a brace or a quote with SQL text selected.
  • Additional Stability updates

New in Froq 3.1 Build 3224 (Jan 8, 2017)

  • Added TouchBar functionality
  • Added autocomplete to Filter panel
  • Improved MacOS Sierra (10.12) support
  • Improved Export stability
  • Localisation fixes
  • Various other bug fixes

New in Froq 3.0.3 Build 3203 (Sep 21, 2016)

  • Added MacOS Sierra (10.12) support
  • Dutch Textual fixes

New in Froq 3.0.2 Build 3193 (May 23, 2016)

  • Fixed bug in Table Creation Assistant where the ’empty’ option for columns was inverted.
  • Fixed bug in Table Creation Assistant where MySQL VARCHAR and VARBINARY columns didn’t require a size.
  • Now Froq picks up document changes made by other applications.
  • Textual updates.

New in Froq 3.0.1 Build 3185 (Feb 1, 2016)

  • Added option to comment selection in Edit menu (CMD-/)
  • Updates to SQL Formatting
  • Fixes double-click issue in Connection-panel group header
  • Fixes to columns with a default value in the Table Assistant
  • Fixes to export panel layout
  • Fixes to Copying SQL as PHP code
  • Fixes to Copying SQL with multiple queries to code

New in Froq 3.0 Build 3168 (Nov 20, 2015)

  • At home at Yosemite and El Capitan:
  • Froq feels right at home at Yosemite and El Capitan. 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.

New in Froq 3.0 Build 3069 Beta 3 (Sep 21, 2015)

  • Windowing:
  • Fixed issue where tab moved to other window would not always have the correct sql editor / browser / info pane state.
  • Added connection information to document title when not connection (when document was connected before)
  • Data-dragging:
  • Updated Browser in drag-modus, empty section are no longer displayed
  • Add browser section for ‘Similar Tables and View in Filter’ Displaying items with the same column name, which also respond to the current browser filter.
  • Fixed issue where during multi-tab drag-and-drop, the browser could lose the state where it displays relevant drop targets.
  • Fixed issue, where columns and values could be dragged while the table or view is currently loading / filter / sorting, causing Froq hang.
  • Various:
  • Fixed Export overview, displaying pasteboard for xlsx destinations in some cases
  • Fixed Export interface issues
  • Fixed resultset context menu for sql results
  • Improved Sql formatting
  • Fixed issue where info panel would not correctly refresh when constraint section was selected
  • Various stability updates
  • Completed Dutch localization
  • Security update, all links / connections to colourful-apps.com are now secure.
  • OS Specific - OS X 10.11 El Capitan:
  • El Capitan Fixed tabbar drawing issues on Fullscreen Split view
  • Fixed panel distortion issue where Split Screen was cancelled into a full screen

New in Froq 3.0 Build 3020 Beta 2 (Jul 15, 2015)

  • Upgrading:
  • Added new Froq 2 connection import Assistant, for users without connections, but with a previous install.
  • Users that already replicated there connections using connection backup or manually should choose 'Don't import' or de-select all connection you've already re-created.
  • PostgreSQL:
  • Fixed function Assistant result query
  • Fixed function editing source and build
  • Fixed function drop
  • Fixed function executing
  • Removed Procedure Assistant (only functions in PostgreSQL)
  • Fixes automatic connection info updates
  • Oracle:
  • Added RAW datatype support
  • Fixed package assistant result query
  • Furthered Oracle management views,
  • Added Processes, Locks, Long Operations, Object and Tablespaces and Datafiles.
  • Updated Database and Instance info
  • Procedure Editor:
  • Fixed issue when executing functions that return empty values
  • Added connection info update after updating a procedure/function name in the procedure editor
  • Various Interface:
  • Fixed Browser, SQL and Procedure Editor distortion when resizing winters
  • Improved Welcome screen key handling
  • ; no longer runs auto complete
  • Updated statusbar reconnect button tooltip
  • Localised the export assistant
  • Disabled Creation Assistants when not connected
  • Various fixes:
  • Fixed resultset row numbering issues when adding or removing rows
  • Fixed instability issue when using the Sort panel multiple times.
  • stability update, resultset animate update
  • Fixed Index Assistant Script
  • OS Specific - OS X 10.9 Maverics:
  • Fixed resultset cell editor
  • Fixed executing custom SQL
  • Fixed info panel label distortion
  • Fixed Mavericks Assistants stability
  • OS Specific - OS X 10.11 El Capitan:
  • Please note that OS X 10.11 El Capitan is currently not supported
  • Fixed startup crashing
  • Fixed resultset row numbering

New in Froq 3.0 Build 2962 Beta 1 (Jun 22, 2015)

  • Optimized for Yosemite:
  • With features such as the new full screen support, the version browser (with Time Machine support) and the auto save and session restore functionality and its updated vibrant interface, working with Froq become has become even more natural and easier.
  • New features:
  • 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 Froq Import Assistant helps you import data into a table.
  • 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.
  • New Assistants help you to create Tables, indices, but also functions and procedures.

New in Froq 2.4.5 Build 2619 (Nov 10, 2014)

  • Improved stability
  • Resolved crashes on Yosemite
  • Resolved problem with auto-quoting filters

New in Froq 2.4.4 Build 2560 (Oct 13, 2014)

  • Improved stability of Exporter, crashing bug at end of export
  • Improved quickfilter -> custom filter conversion
  • Previous loaded resultsets now recognize new columns added in SQL Editor

New in Froq 2.4.3 Build 2282 (May 26, 2014)

  • Added connection backup functionality
  • Fixed issue where not all default column values where filled-out correctly for all types

New in Froq 2.4.2 Build 2229 (Dec 16, 2013)

  • Fixed export of 'char' type columns, when exporting as SQL Statements
  • Reduced energy requirements on OS X 10.9 Mavericks

New in Froq 2.4.1 Build 2209 (Jun 21, 2013)

  • Fixes:
  • No longer replaces text into symbols in the sql-editor
  • Fixed removing rows on non-oracle tables where the primary key is an timestamp
  • Fixed storing and loading of BLOB contents on Mac OS X 10.7 and higher
  • Updated MySQL driver for better support of MySQL 5.6
  • Fixes issues that prevented Froq to launch after installing Java for Mac OS X 10.6 Update 6 or Java for OS X 2013-004
  • Changes:
  • New tabs now open directly next to the active document.
  • IMPORTANT: As of Froq 2.4 Froq is Intel only and requires Mac OS 10.6 (Snow Leopard)

New in Froq 2.4.0 Build 2125 (Dec 10, 2012)

  • Changes:
  • Completed Retina Macbook compatibility
  • Added Developer-ID for Mountain Lion's GateKeeper
  • IMPORTANT: As of Froq 2.4 Froq is Intel only and requires Mac OS 10.6 (Snow Leopard)
  • Fixes:
  • Instability when executing some specific SQL scripts
  • Improved responsiveness during resultset preloading
  • Various stability improvements

New in Froq 2.3.2 Build 2041 (Dec 16, 2011)

  • Fixes connectivity with SQL Server on Java 1.6.0 Update 29
  • Fixes compatibility with a few Oracle data types in Java 6.
  • Stability updates

New in Froq 2.3.1 Build 2028 (Jul 4, 2011)

  • Improved compatibility with Mac OS X 10.7 (Lion) when reopening Froq
  • Updates to tab dragging.
  • Updates to sql-formatter.
  • Fixes:
  • Fixes to stability when using the QuickFilter on certain configurations.
  • Stability updates

New in Froq 2.3.0.2 Build 2003 (Feb 3, 2011)

  • Fixes minor issue, where (on Oracle connections) the session info window would also open when requesting 'info' on an object or record.
  • Fixes a minor stability issue introduced in Froq 2.3

New in Froq 2.3 Build 1993 (Jan 28, 2011)

  • Multi-touch. Swipe horizontal to navigate through the current documents history, swipe vertical to navigate through the current windows tabs. (Requires Mac OS X 10.6.2 and supporting hardware)
  • Generate urls to Froq database connections (froq:mysql://[email protected]:3306/maindb), once connected see the connection menu.
  • Added connection preference to allow immediate connection from a document or url (without confirmation), off by default.
  • Added option to open a Session Info window for the current (Oracle) session, see connection menu.
  • Changes and Fixes
  • Froq better handles connections from files that contain connections that haven't been accessed before and creates a new connection.
  • Updated cell-editor to be read-only when the resultset is.
  • Decreased frequency of background connections.
  • Some minor enhancement and fixes

New in Froq 2.2.3.1 Build 1963 (Nov 9, 2010)

  • Fixes issue where one couldn't browse for an SQLite database on the connection sheet.

New in Froq 2.2.3 Build 1957 (Oct 31, 2010)

  • Fixes issue where not all rows where updated, when using update SQL queries on SQL Server.
  • Fixes stability issue when dragging value to a constrained table (option-drag)
  • Fixes issue where analyse would result in an error on Oracle connections with autocommit enabled
  • Fixes issue where after reconnecting an Oracle management window no data would load.
  • Fixes issue where dropping value's on Oracle synonyms in the browser didn't have expected result.
  • Allows drag of statement recall query to other applications
  • Other stability enhancements

New in Froq 2.2.2 Build 1937 (Nov 18, 2009)

  • Improved reliability of Excel exports
  • Fixed issue where Exporter setting 'Re-execute SQL statements when exporting' wasn't persistent
  • Fixes the 'Program' name in Oracle Management for Froq sessions
  • Stability improvements
  • Improved stability when commit / rollback is no longer possible after losing the connection
  • Improved Object-info (Table, View etc…) stability when requesting info and no database connection can be made
  • Fixes to the initial schema selection
  • Improved reconnecting to a SQLite database, from an .sql file
  • Fixes stability when changing the QuickFilter to the 'custom filter'
  • Fixed issue when loading Froq SQL documents that were stored with newlines in their SQL parameters
  • Improved background services stability, when active under a locked workstation

New in Froq 2.2.1 Build 1903 (Sep 7, 2009)

  • Updated & Fixed QuickLook plugin for Snow Leopard, added 64 bit support
  • Updated SpotLight plugin for Snow Leopard, added 64 bit support
  • Stability fixes to background services
  • Updated 'Record Info' sheet layout
  • Fixed distortion issues when resizing window manually
  • Fixed issue where resultset layout wasn't maintained when refreshing the results of a custom SQL command
  • Fixes issues when inputting the first record in an empty SQLite table
  • Fixed issue where command-E wouldn't open the Edit Value window anymore
  • Fixed issue of huge context menu's in resultsets with large text values.
  • Improved exporting to SQL.
  • Localization fixes.

New in Froq 2.2 Build 1864 (Jul 20, 2009)

  • New features:
  • Snow Leopard Compatibility, rewrote engine to no longer depend on the Cocoa-Java bridge
  • Added QuickFilter options, store your current QuickFilter for later usage
  • Added option to the Connection-preferences to keep the connection alive
  • Added Activity Window (See Window menu) to view all database activity
  • Added Auto-commit options to other than MySQL databases
  • Added Recycle bin support for Oracle 10 and later databases.
  • Updated:
  • Improved performance when filtering Oracle partitioned tables
  • Improved compatibility of exported Microsoft Excel files, reduced file size
  • Moved the commit and rollback action to the background
  • Now allows Connecting to a database while an other document is still trying to connect
  • Connecting can now be cancelled, documents can now be closed while connecting, application can be quit while connecting
  • Upgraded SQLite driver
  • ROW column can no longer be moved
  • Sql Scripts are no longer being registered in the Statement Recall collections
  • Manually updating connection information no longer clears the history
  • Fixes:
  • Custom QuickFilter, didn't update correctly if it wasn't the first of multiple filters
  • Improved stability when reloading the resultset without filtering and sorting, after first canceling the selection
  • Improved stability when performing Sql Analysis on Oracle databases
  • Improved stability for background actions
  • Canceling execution now also works with fast scripts
  • Localization Fixes
  • Various performance & stability updates

New in Froq 2.1.1.1 (Aug 18, 2008)

  • Froq 2.1.1.1 Fixes Oracle / insert issues, introduced in Froq 2.1.1

New in Froq 2.1 (Jun 20, 2008)

  • Column drag, vertically drag a column header to use all its loaded values as a QuickFilter item, add them to the current filter or drop them on a table in the left browser
  • Improved dropping onto the browser; hold Command to start filtering the table in a new tab, hold Command-Option to start filtering the table in a new window
  • Added scrollbar to the 'Custom filter'
  • Re-designed interface
  • Improved performance and stability
  • Select / rename columns to export and in which order
  • Export as Microsoft Excel documents
  • Export as SQL Statements
  • Added 'Duplicate Tab' to the File and tab context menus, use it to duplicate the current tab including its selection and filter
  • Added 'Tab title' preference, to customize the tab title
  • Added tabs to the 'Window menu'
  • Re-arranged tabbar context menu
  • 'Select'-statements executed in the SQL-Editor can now simply be re-executed by selecting Refresh from the Resultset Menu
  • Added 'Keyboard Shortcuts' to the help documentation
  • Added possibility to retry to connect after a connection failure
  • Improved SQL dropping from resultset onto the SQL-Editor
  • Improved Visual feedback when dropping items onto the tabbar
  • Major performance enhancements for the SQL-Editor, including auto-completion, the QuickLook and the Spotlight plugin, most noticeable on larger SQL document
  • Additional trial period, for users who have evaluated Froq 2.0
  • SQL-Results (drawer) now only keeps a limited number of results, to prevent performance problems
  • Fixed issue where a new window would 'flicker' in front of the current document, when 'Select new tabs when they are created' is un-checked
  • Fixed date/timestamp/datetime stability issues in the 'QuickFilter'
  • Fixed issue when sorting on columns with spaces in their name
  • Fixed issue where SQL variables that only differed in case would be represented in the variable input panel twice
  • Fixed issue where matching braces where sought while in a comment or a literal element
  • Fixed connection panel sizing, it now automatically shrinks when it doesn't fit
  • Localization fixes
  • Additional stability & performance updates

New in Froq 2.0.1 (May 4, 2008)

  • Improved memory usage, updated settings to a maximum of 256MB Java memory
  • Improved performance when browsing connections with many tables (500 )
  • Improved resultset scrolling performance
  • Improved performance when loading connection meta-data
  • Disabled automatic meta-data update when connection contains more that 4000 tables
  • Extended max font size SQL-Editor preference from 16 to 28
  • Changed 'check for updates on startup' into 'periodically check for updates'
  • Fixed focus issues with software-update panel
  • Fixed issue where too much Oracle Connection Info was retrieved
  • Fixed an application lock-up that could occur during initial Connection info retrieval
  • Fixed issue where row-changes weren't submitted when starting to QuickFilter directly after editing a row
  • Fixed issue where the selection in the cell editor was placed at the end of the text
  • Fixed issue where tabs could be distorted when going opening a second tab when the first is busy
  • Fixed issue with wrong items in the context menu in the resultsets created with custom queries
  • Fixed resultset deadlock issues
  • Fixed some stability issues when closing documents
  • Fixed issue where opening documents would directly cause them to be marked as edited.
  • Improved Tiger / PowerPC stability

New in Froq 2.0 RC 4 (Apr 14, 2008)

  • Added support for SQLite autoincrement columns
  • Added support for editing tables without primary keys in SQLite
  • Added TNS or SID indication to Oracle's connection details
  • Enabled Connection Details when using Oracle Management
  • Replaced SQLite driver with a native driver to improve performance
  • Added support for SQLite triggers in the Table info panel
  • Added matching brace highlights to the SQL-Editor
  • Added automated auto-completion to the SQL-Editor
  • Extended SQL-Editor preferences with 2 syntax recognition options
  • Fixed issue where certain errors (none decimals in a text field) could result in an application crash in SQLite
  • Fixed Session Info (Oracle Management) window, to be unified under Mac OS X 10.4 (Tiger)
  • Fixed issue where Connection Details weren't available when using Oracle Management
  • Fixed issue where program-name wasn't set to oracle connections when using sid connections (i.s.o. tns service-names)
  • Fixed issue where print-job wasn't named correctly
  • Fixed issue where scripts couldn't be printed when the document isn't connected
  • Fixed issue where the constraint creation assistant could generate invalid sql
  • Fixed issue where 'comment on' syntax wasn't recognized as a ddl statement
  • Fixed issue where the cell editor didn't allow Undo actions
  • Fixed issue where the localtime modifier in SQLite didn't function
  • Fixed Table Info layout
  • Fixed Quickfilter for table / views with spaces or reserved words in there name
  • Fixed Quickfilter for table / views with spaces or reserved words in there column names
  • Updated main window to show syntax coloring when displaying an SQLite trigger
  • Fixed issue where Froq still would uppercase certain keywords in the Table info 'ddl' tab
  • Updated SQL formatter (SQL>Format SQL)
  • Updated Syntax coloring
  • Fixed issue, where auto-completion list upper-cased all context related words

New in Froq 2.0 RC 2 (Mar 31, 2008)

  • Added Create SQLite database to File menu.
  • Froq now no longer requires a password to be used for a connection
  • Updated performance when closing windows
  • Extended expiration date to April 25th
  • Small artwork adjustments
  • Fixed issue where the focus would get lost after using the 'Record info'.
  • Fixed issue where double-clicking a tab would open a new tab
  • Fixed startup sequence
  • Fixed Value-Editor, so it doesn't render off screen.
  • Fixed localization of SQLite paths in interface.
  • Fixed timestamptz support for Oracle
  • Fixed issue where Value Editor, would display empty cells as '(null)'
  • Updated Value-Editor layout
  • Fixed issue with readonly icon
  • Stability fixes
  • Performance fixes
  • Improved compatibility with certain Oracle and MySQL datatypes

New in Froq 1.3.0 (Mar 2, 2008)

  • Added Color label to the Connection manager connections list
  • Updated help documentation, added Feedback and More than Browsing your data.
  • Localized help documentation.
  • Added resultset context menu, to the current editing value. Making is easier to use a sequence from the context menu.
  • Added Object management feature to the Oracle Management window.
  • Added context menu to the Management window's sessions, locks and longops tables.
  • Localized Oracle management.
  • Changing the Color label of tabs will also update the Color label registered with the connection.
  • Updated Connection Manager to automatic fill in the password field from the keychain when available after changing the username.
  • Updated Color label graphics
  • Changed Management controls back to Command-1 through 6 i.s.o. Command-Option-1 through 5
  • Moved clustering-sensing to the front, to prevent an unnecessary additional refresh
  • Changed default sorting of sessions and locks to longest through shortest
  • Moved session info to its own window, and its own processing thread
  • Removed stack traces from the log.
  • Updated install sequence, Spotlight refreshes only occurs for specific versions
  • Updated document open / reconnect, to better use existing connections / color labels
  • Fixed that the browser behind the management window could be used
  • Fixed issue when loading resultsets with empty CLOB's
  • Fixed 'check now' button on Preferences window
  • Improved Oracle Management Locks speed (factor 5 )
  • Improved Oracle Management Sessions speed (factor 2 )
  • Improved Long ops performance (factor 8 ), by truncating number of results

New in Froq 1.3.0 (Oct 29, 2007)

  • The Froq application has been updated to perform correctly on Apple's latests operating system, Mac OS X 10.5 codename Leopard.
  • Other than that this update brings a small number of updates to the unlicensed version, enhancing the trial experience