- Download
12.7 MB -
Visit Developer's Site
Colourful Apps
Froq is a tool for rapid database querying, it's a Mac OS X application providing easy access to different databases, focusing on browsing through your data with ease.
It provides a intuitive and fast interface to your database. By providing some unique searching features, it allows you to browse through your data in fast and easy fashion. While the 'Quickfilter' allows you to simplify the search for specific data, the 'CrossQuery' feature allows you to jump from table to table to quickly find any related data.
Froq 2 brings you an enhanced, new,
It provides a intuitive and fast interface to your database. By providing some unique searching features, it allows you to browse through your data in fast and easy fashion. While the 'Quickfilter' allows you to simplify the search for specific data, the 'CrossQuery' feature allows you to jump from table to table to quickly find any related data.
Froq 2 brings you an enhanced, new,
What's New
Version 2.4.2:
- Fixed export of 'char' type columns, when exporting as SQL Statements
- Reduced energy requirements on OS X 10.9
Requirements
- Intel
- OS X 10.6 or later
- Java 1.5 or later
| Downloads:10,953 |
| Version Downloads:75 |
| Type:Business : Applications |
| License:Demo |
| Date:15 Dec 2013 |
| Platform:Intel 32 / OS X |
| Price: $70.00 |
Overall (Version 2.x):  |
| Features: |
| Ease of Use: |
| Value: |
| Stability: |
-
-
-
Froq is a tool for rapid database querying, it's a Mac OS X application providing easy access to different databases, focusing on browsing through your data with ease.
It provides a intuitive and fast interface to your database. By providing some unique searching features, it allows you to browse through your data in fast and easy fashion. While the 'Quickfilter' allows you to simplify the search for specific data, the 'CrossQuery' feature allows you to jump from table to table to quickly find any related data.
Froq 2 brings you an enhanced, new, natural, easy, fun and fast access to your Oracle, MySQL, PostgreSQL, SQL Server and SQLite databases. The new tabbed interface with increased multi-tasking capabilities offers a new and improved connection to your database, while the new drag-&-drop QuickFilter further enhances the browsing experience.
Froq is available in English and Dutch.
It provides a intuitive and fast interface to your database. By providing some unique searching features, it allows you to browse through your data in fast and easy fashion. While the 'Quickfilter' allows you to simplify the search for specific data, the 'CrossQuery' feature allows you to jump from table to table to quickly find any related data.
Froq 2 brings you an enhanced, new, natural, easy, fun and fast access to your Oracle, MySQL, PostgreSQL, SQL Server and SQLite databases. The new tabbed interface with increased multi-tasking capabilities offers a new and improved connection to your database, while the new drag-&-drop QuickFilter further enhances the browsing experience.
Froq is available in English and Dutch.
+1
+18
barefeettom reviewed on 25 Jul 2009
The ability to drag entities (views and tables) into the SQL editor and the pop up autocompletion are great, but need refinement. Eg entity names should be quoted (eg if containing a space) and column names should appear in the autocompletion pop up (eg after the "where" clause when the table has already been specified after "from".
It still has problems with data entry changes, often giving "database locked" or "invalid entry" errors where it shouldn't. In the process it damaged at least one of by databases.
I'd still like to see Froq capable of editing data in views which would make it usable on everyday databases for me.
I've updated the comparison review at:
http://www.tandb.com.au/sqlite/compare/?mu
+18
barefeettom reviewed on 14 Apr 2008
The lack of support for editing in views is a show stopper for me, but the SQL syntax coloring and quickfind features are up with the best I've seen.
I've published a detailed comparison of features in Froq and other SQLite editors for Mac at:
http://www.tandb.com.au/sqlite/compare/
Tom
BareFeet
+1
+2
semioticmonkey reviewed on 14 Apr 2008
a) the site is totally a mess. navigate in search of info about you and your software is a guess game. The stupid menu (dock like) is the worse offender but the page menu is even worse (with that Helvetica 12 clashing with the rest). Please, consider clean up your 'personal home page' and give it a more professional looking, usable and customer centric layout If you want to charge 79$ for your application. Don't understimate your 'client'.
b) the same for the application.
b1 - The stupid widgetesque splash is irritable. The user begin to work with the splash still waving around. Shut the splash down. It doesn't give me useful info making only noise.
b2 - The icons (both the App Icon and the toolbar icons) are toonish and perception disturbing. Stick with the OS X color palette and integrate your app with the rest of OS X world.
The Ugly
Why on heart it is mandatory to give the database name on a new connection?
The Bad
The Sql editor doesn't follow the selected table. You have to manually clean up each and every time the editor to start writing.
Always the SQL editor doesn't autocomplete fields in a given table.
Always the SQL editor doesn't have collapsed region (ala Database Spy)
When an error in the statement occurred, we have a disturbing popup window. give contextual information in context without using popups (as everywhere in OS X - check mail, TextMate and the likes)
After a statement error, the table selection reset itself. (!?)
The infuriating behavior
The SQL editor insists on operate on the database selected in the connection panel ignoring the user choice. If you switch to another database (the application permits it and there is a Select menu), the SQL editor doesn't follow you. But the commit button yes. This inconsistency is the worse thing in this application. Choose a behavior and stick with it. Or no operation at all on databases other than the choosen one, OR all operations permitted. And, please, make the stupid SQL editor follow the user and not the application.
suggestions:
smart folders to store e retrieve sql staments on a given table.
All in all i like your application. It is a good starting point. But if you compare to the professional competitors, as Altova Database Spy or Navicat, priced in the same price range or above, it gives no distinct feature set to justify the price. Lower it and i'll consider buy it and use it instead of terminal.
If you use MySQL, continue to use the Terminal or CocoaMySQL.
If you need Oracle support, give it a try.
+18
7. I notice that if I "Add" a row, enter the value for one column, I have to click on another row to make it save the changes to the first row. Perhaps a "Save" button or similar would make this more direct and obvious. Also, I notice that Froq seems to insert a value for every column, perhaps nulls or "" (hopefully not) for those columns where I didn't enter data. I suggest that Froq should only specify the fields in the insert that were actually edited.
8. Froq's syntax coloring looks pretty good. Could you please make it optional to capitalize keywords (or provide the option to make them lowercase) since we don't all like them capitalized. Comments default color would be better as something more subtle (eg grey instead of green).
9. At present Froq colors identifiers (table/view names, column names) such as "First Name" as if it were a literal. Froq should show identifiers in a different color. Coloring those that are unquoted and those that are double quoted the same color would be great, but at least color the double quoted identities different to the single quoted literals)
+18
+14
almost 9 minutes on a G4 1.3GHz to export 31000 lines in a text file...
AquaDataStudio 4.7 did this for free (same computer, same SQL script) in 2 minutes.
-1
-18
I think TOAD is still free but it's only for Windows. Provides tons of features over Froq.
/Mikael
+1
'Couldn't connect to the database
Io exception: Invalid connection string format, a valid format is: "host:port:sid" '
I don't know what error log it is logging to (if any) so I can't see any more details of what has gone wrong.
-18
It's free, works and runs circles around Froq....
/Mikael
+18
1. Views aren't showing, just tables.
2. Froq won't allow editing of data where the table name or column name contains a space. I suggest that you include the "" double quotes in all references to identifiers in your behind the scenes update, delete, select, insert etc statements to avoid this problem.
3. Furthermore, when Froq shows a "couldn't update database" error, it won't allow me to select any other table or cancel the update. I can only quit.
4. Somewhere Froq mentions that it won't allow editing of data in views. It should allow this since SQLite supports it via "instead of" triggers, which allow editing of views.
5. Froq fails to open a SQLite database on an AppleShare volume. The SQLite built into Mac OS X does not have this problem. You need to disable a locking option in the compiling of SQLite in Froq to allow opening on remote volumes.
6. I can't see how to show/edit triggers.
Tom
BareFeet