3
Thank you for your review
$66 80
http://www.macupdate.com/download/20464/froq2.4.3.b2282.dmg%3F
Email me when discounted: 
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, more...

What's New

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

Requirements

  • OS X 10.6 or later
  • Java 1.5 or later

Similar Software

Open Comparison
Suggest Other Similar Software
Leave a Review

Froq User Discussion

Nobody has reviewed or commented on this app yet. Add your own comment and get a discussion going!
Sort by: Time | Smiles
barefeettom Member IconReview+20
barefeettom
+1

Froq leads in many features over rival SQLite capable GUI editors.

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

Reply0 replies
Version 2.2
barefeettom Member IconReview+20
barefeettom
+0

Froq is coming along very nicely. Contrary to the previous review, I think the green motif and icons adds to its charm while still being professional.

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

Reply0 replies
Version 2.0rc4
semioticmonkey Member IconReview+25
semioticmonkey
+1

two things merely about usability and user experience design:

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.

Reply0 replies
Version 2.0rc4
barefeettom Member IconComment+20
barefeettom
+0

Here are a few more points:

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)

Reply0 replies
Version 2.0b2
barefeettom Member IconComment+20
barefeettom
+0

It's great to see SQLite support added in Froq in version 2.0b2. I've had a quick look and hit some obstacles/bugs:

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

Reply0 replies
Version 2.0b2
barefeettom Member IconComment+20
barefeettom
+0

Froq looks like a very nicely polished Mac application. I noticed in the list of supported databases doesn't include SQLite, which surprises me since SQLite is so prolific and so pervasive on the Mac platform. Would you consider adding SQLite support in your 2.0 version?

Reply0 replies
Version 2.0b1
kaz219 Member IconComment+25
kaz219
+0

A bit slow:

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.

Reply0 replies
Version 1.2.4
MikaelF Member IconComment+162
MikaelF
+0

I don't understand why I should pay for something that is so limited in functionalty and Oracle themselfs provide FREE alternatives (SQL Developer, Java Client too or APEX, a web tool) that provides MUCH more functionality.

I think TOAD is still free but it's only for Windows. Provides tons of features over Froq.

/Mikael

Reply0 replies
Version 1.2.2
NadeemF Member IconComment+2
NadeemF
+0

Didn't work for me; I entered all the normal info (same as the details I use in Aquadatastudio) and got the message
'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.

Reply1 reply
Version 0.9.3
MikaelF
+0

Try http://www.oracle.com/technology/products/database/sql_developer/index.html

It's free, works and runs circles around Froq....

/Mikael

There are no Ratings for this App yet.
> 3 3

Ratings

Overall
(3)
Current Version (2.x)
(3)

Details

Downloads 11,017
Version Downloads 50
License Demo
Date 25 May 2014
Platform OS X / Intel 32
Price $66.80
Learn how MacUpdate Desktop makes installing apps from MacUpdate.com one-click easy.
Next time, install Froq with 1-click

Learn how MacUpdate Desktop can install apps on MacUpdate with the simple click of the Install apps with MacUpdate Desktop icon. Plus, keep all your apps updated. Play video...