FrontBaseManager
Version 4.x
Release Notes

### Welcome!

Welcome to the latest revision of the FrontBase database management application!

Please note that once you close this file, it will not re-open automatically until you upgrade to a newer version of FrontBaseManager. However, you can always get to this Release Notes file from the FrontBaseManager Help menu.

### Changes in FrontBaseManager 4.4.10

- When doing a flat file import to a table, the list of COLUMNS names were not comma-separated.
- Progress bar was not correctly positioned after resizing of result window.

### Changes in FrontBaseManager 4.4.9

- In the replication panel the create client button has been disabled when the replicator is not running.
- When creating new tables the normalization flag is not set by default on columns supporting normalization.
- Backup no longer requires a file name.

### Changes in FrontBaseManager 4.4.7

- Focus changed to the sql view in the content window instead of the fetch limit.

### Changes in FrontBaseManager 4.4.6

- When creating constraints across different schemas the constraint name is qualified.
- It is now possible to specify a fetch limit in the content window.
- It is now impossible to drop implicit indeces.
- Replication clients can now be created with the FrontBase Manager.
- It is now possible to specify passwords when adding replication clients.

### Changes in FrontBaseManager 4.4.5

- Some special characters were not allowed in the sql view.

### Changes in FrontBaseManager 4.4.4

- When creating named constraints, the schema name is now added to the constraint name.

### Changes in FrontBaseManager 4.4.3

- A number of windows used when editing a table definition have been made resizable.

### Changes in FrontBaseManager 4.4.2

- When importing data, the list of tables available was not updated between imports. This has been corrected.

### Changes in FrontBaseManager 4.4.1

- When clicking the License option in the connection pane, no information was displayed. This has been corrected.

### Changes in FrontBaseManager 4.4

- FrontBaseManager now saves size and position of opened windows.

### Changes in FrontBaseManager 4.3

- It is now possible to manage clusters.
- Replication management has been improved.
- From the SQL Interpreter panel the 'Execute File' now recognizes files with extensions .sql, .txt and .text.

### Changes in FrontBaseManager 4.2

- The panel to stop a database has been simplified.
- The panel to connect to a database by double-clicking at it has been simplified.
- You can now remove a reachable host from the host list in the monitor panel.
- When specifying -sdisk as a startup or create option you must specify the path to the key file. This field has been added to the panel.
- It is now possible to see the startup options for the selected database by clicking the 'Show Options' in the Database menu.
- It is now possible to create and delete domains and use them in column definitions.

### Changes in FrontBaseManager 4.1

- Sometimes when editing schema objects and an error was encountered, no further changes could be made until you made a new connection to the database. This has been currected.
- When viewing table content and adding a where clause, you can now use the ESC button to refetch objects.
- When editing table definitions the order of the columns is the order retrieved from the database server. Now you can sort the columns by their name by clicking the header of the 'Name' column.
- When updating table definitions you would have manually end the editing for the update to take effect. This has been changed.
- The sql for retrieving privilege information has been optimized.
- The two columns: 'Transaction #' and 'Calls' in the usage pane can now be resized.

### General Feature Overview

- Documentation
  - Documentation is available from the FrontBaseManager Help menu. Check it out!
- Multithreading
  - FrontBaseManager is multithreaded, allowing multiple, concurrent connections to the same database, without the possibility of deadlock. This also prevents the main application thread from being bound when the user encounters a table or row lock during a fetch.
- Aqua User Interface
  - The interface conforms to the Aqua human interface guidelines.
- Transaction Status
  - Transaction information is available at all times on the database connection window. This includes whether or not a transaction is in progress, as well as the SQL 92 transaction settings such as Isolation Level, Locking Discipline, Updatability (or Access Mode), and Commit Mode.
- SQL Interpreter
  - The SQL interpreter provides helpful keyword highlighting, supports Copy (Command-c) in the history list, and supports file drags into the SQL text area. Context menus, available by right clicking in the SQL Interpreter text area, provide rapid access to actions such as changing isolation level, locking discipline, toggling auto commit, etc.
- Easy Database Information Access
  - The database pane readily provides basic information about your database, such as the database version, the up time, the size of the database on disk, the mode the database is in, etc.
- SQL 92 Session Customization
  - Using the Session pane, you can configure the transaction settings associated with your session. For instance, you can make your isolation level and locking discipline more permissive, or switch to Read Only mode, enable/disable autocommit, etc.
- Enhanced Usage Information
  - The usage pane provides information about connected users, such as their SQL 92 transaction settings, their connection time, their transaction duration, etc.
- Licensing Demystified
  - The licensing pane displays detailed information about your database license. As an added bonus, you can remotely license database servers.
- Schema Objects Browser
  - Using the Schema Objects Browser pane, you can traverse all of the objects within your database, including Tables, Views, Procedures, Functions, Collations, and so on. At any point, you can easily create a new schema object, or browse the content or definition of an existing schema object. Using Right-Click on the mouse will bring up a context menu to quickly copy the fully qualified name of the selected object to the clipboard.
- Powerful Table Editor
  - While not a graphical modeler, the table editor in FrontBaseManager provides great control over table creation, allowing you to change almost everything about a table with a few mouse clicks. The column editor is especially helpful, since it provides ALTER SQL in real-time as you change your table definition. This helps to ensure that you know what's going to happen for a given change, and teaches you a little more about SQL 92 and FrontBase in the process.
- Full Text Indexing
  - Using the table definition editor, you can quickly configure the powerful LookSee full text indexing engine and create full text indexes for your data. The indexing engine can handle text, HTML, and XML, and has several options for stemming, folding case, trimming indexes, etc.
- Powerful Table Content Editor
  - Using the content editor, you can browse table data, insert rows, update rows, and delete rows. You can even insert and download BLOB and CLOB objects by clicking on a simple hyplerlink!
- Drag & Drop
  - You can select rows in the content editor or in the fetch result window and drag them to the desktop, or to applications such as TextEdit, Mail, Excel and Word.
- Easy Backup
  - The backup pane provides backup functionality with the click of a mouse. Backups are always a good idea!

### Reporting Bugs & Gathering Feedback

User feedback is what makes an application great! Please send your suggestions, bug reports, etc., to support@frontbase.com. Our support team will make sure that your suggestions are logged and bugs are directed to the appropriate member of our engineering team.