Froq supports Oracle, MySQL, PostgreSQL and SQL Server databases. Froq's main goal is to provide a user-friendly browsing and editing experience to the average database user. Its goal is not to fully support every feature a database has to offer, but to provide one consistent,easy and fast interface to your database.
Froq can't offer all the same features for every type of database, this can be due to restrictions of the database or the driver. Below you'll find a schema of some of Froq's key features, set out against the different types of database.
See Database connections for the types of connection Froq can make.
|Editing, sorting, QuickFilter and drag-'n-drop filtering|
|Default column values|
|Sequences in the context menu|
|Editing without primary keys
(Other databases require primary keys to edit.)
|Procedure / Function editing|
|Procedure / Function executing|
|Import / Exports|
|Full data exports|
|Full data imports|
|Object Creation Assistants|
|Tables, Indices, Constraints|
|Mac OS X Integration|
|Time Machine versioning|
Below is the list of connection types Froq can make Froq will always try the most modern or secure way first, and then fall back to an alternate method.
|Service Name connection||Automatically detected by Froq, priority|
|TNS Name connection||Automatically detected by Froq|
|Regular MySQL connection|
|Secure PostgreSQL connection||Automatically detected by Froq, priority|
|Regular PostgreSQL connection||Automatically detected by Froq|
|SQL Authentication connection|
|Windows Authentication connection||Use 'domain\username' as the username in the connection panel|