What's New

IBExpert 2020.05.10

1. Database Explorer

  • Filtering of the Project View tree implemented.

2. Database Monitor

  • Fixed the issue with queries get messed up when two or more instances of the Database Monitor were started.
  • Fixed the problem with new queries disappearing after closing the Database Monitor.

3. Code Editor

  • Output parameters tip for the EXECUTE PROCEDURE statement implemented.
  • Parameter hints for new Firebird 4 functions (HEX_ENCODE, HEX_DECODE, MAKE_DBKEY, RDB$GET_TRANSACTION_CN) added.
  • Highlighting of new Firebird 4 keywords and reserved words.

4. Database Statistics

  • Statistics parsing has been improved.
  • Support of additional statistics data (Firebird 3, 4) in the table/index grids.
  • Fixed the problem with overflow of some statistics values which causes incorrect (mostly negative) data in table/index grids.

5. Option | Environment Options | User Database

  • Support of environment variables in a database path and client library name implemented.
    To use value of an environment variable as a part of a path enclose it between the percent chars:
    %USERPROFILE%\somedata\ibedb.fdb

There is IBE_APPDIR environment variable that contains the location of the IBExpert.exe directory.

6. Script Executive

  • SET DBTRIGGERS ON/OFF directive implemented.

If DBTRIGGERS is OFF all consequent CONNECT/RECONNECT statements will be executed with the isc_dbp_no_db_triggers flag. Default value is ON.

  • Add CONNECT statement feature adds SET DBTRIGGERS OFF automatically if the Supress database triggers option is specified in a database registration record.

7. Performance Data

  • Fixed the problem with overflow of some performance data values.

8. Event Blocks

  • Process the Code completion list event block implemented.

This event happens just before the Code Completion list appears, so the user can customize what to see and what to hide in that list. See the template block for example.

9. IBEBlock

  • ibec_CompareTables, ibec_CompareMetadata functions: NoConnect option implemented.

If this option is specified in the option string the result script will not contain CONNECT statement and corresponding SET NAMES, SET SQL DIALECT and SET CLIENTLIB directives.

  • ibec_CompareMetadata: AppendMode option implemented.

If this option is specified and the file ScriptFile already exists the resulting script will be appended to the ScriptFile. Otherwise a new file will be created or an existing file will be overwritten.

  • ibec_CompareTables: Return option implemented.

By default, this function returns null, but now it is possible to force it to return the total number of different records: specify Return=DiffCount in the option string.

  • ibec_CompareMetadata: Return option implemented.

By default, ibec_CompareMetadata returns null, but it is possible to force it to return the total number of actions (CREATE/ALTER/DROP etc.) in the result script: specify Return=ActionCount in the option string. Normally ActionCount = 0 if there are no differences found.

  • ibec_ExecSQLScript: TransactionParams (or TrParams) option implemented.

This option can be used to specify the initial transaction isolation level for the SQL script. Transaction parameters should be separated with a colon or semicolon: TrParams="read_committed,rec_version,nowait"

10. New IBEBlock functions

11. Minor bug fixes and small improvements

back to top of page


IBExpert 2020.01.06

and bugfix version 2020.02.12

1. Test Data Generator

  • Initial support of DECFLOAT / NUMERIC(38) fields (Firebird 4).

2. Data Grid

  • Support of DECFLOAT and NUMERIC(38) fields (Firebird 4): sorting, filtering and aggregate functions implemented.

3. SQL Editor

  • Support of UPDATE OR INSERT into another database implemented.

Syntax is similar to INSERT into another database:

    UPDATE OR INSERT into [another_database_alias].<table_name> 
    <select>  

4. Table/View Editor

  • Columns grid: [Ctrl] + [C] / [Ctrl] + [Ins] now copies name of focused field into the clipboard.

5. Blob Viewer

  • Support of JSON data format implemented.
    If blob data is modified using "As JSON" page IBExpert will try to remove all insignificant whitespaces before post.
    There is Remove whitespaces on post checkbox to control this behaviour.
    If there is a syntax error in JSON data - it will be posted "as is", without removing whitespaces.
  • JSON syntax highlighting is available also on As text page.

6. IBEBlock

  • ibec_BackupDatabase, ibec_RestoreDatabase, ibec_CreateConnection functions now support the WireCompression option (if both client and server support them).

    To enable compression it is necessary to specify 'WireCompression=TRUE' (or just 'WireCompression') in the options string.

7. Minor bug fixes and small improvements

back to top of page


IBExpert 2019.11.13

The free IBExpert Personal Edition and the IBExpert Developer Studio full versions now include a free IBExpert Watchdog Version S in the Tools directory. The S version may also be distributed free of charge.

back to top of page


IBExpert 2019.10.9

1. PSQL Debugger

  • Support of Trace Into for package routines and stored functions.
  • Support of DECFLOAT and NUMERIC(38, x) variables and parameters (Firebird 4).

2. SQL Editor

  • Support of DECFLOAT and NUMERIC(38,x) parameters (Firebird 4).

3. Trace and Audit

  • Analysis of large trace logs is now possible. The main idea is to retrieve only necessary items from a trace log file using the Grid View mode with applied filter criteria.
    It is also possible to save filtered data as a trace log file.

4. Database Designer

  • Support of identity columns (GENERATE BY DEFAULT AS IDENTITY and GENERATE ALWAYS BY IDENTITY).

5. Trigger Editor

  • Fixed bug with missing SQL SECURITY clause in lazy mode (Firebird 4).

6. Grant Manager

  • Fixed bug with missing USAGE privileges while working with a Firebird 4 database.

7. Minor bug fixes and small improvements

back to top of page


IBExpert 2019.07.24

1. Package Editor

  • Formatting of package header/body sources implemented.

2. Table Data Comparer

  • It is now possible to limit the synchronization queue size.

It is possible to limit the queue by the number of statements in it or by the memory occupied by the queue. A positive value means limitation by number of statements. A negative value means limitation by memory size (in megabytes). Default value is 0 - no limits.

  • Detailed statistics for comparison and synchronization actions have been implemented.

3. Environment Options / PSQL Debugger

  • Toggle to the Message tab on error/warning/message while debugging option implemented.

By default the PSQL Debugger activates the Message tab on every error/warning/message which occurs while debugging. If you don't like the default behaviour turn this option off.

4. BLOB Viewer

  • Fixed the problem with the display of icon pictures (ico format).

5. Script Executive

  • Fixed the problem loading BLOB values from BLOB-files when a blob data offset exceeds 2 GB.

6. IBEBlock

  • ibec_CompareTables: the QueueLimit option has been implemented.

A positive value means limitation by number of statements. A negative value means limitation by memory size (in megabytes). Default value is 0 - no limits.

Examples:

    QueueLimit=100 - number of statements in the queue must not exceed 100.
    QueueLimit=-5 - the queue must not occupy more than 5 megabytes.

7. Minor bug fixes and small improvements

back to top of page


IBExpert 2019.04.14

1. Code editors

  • Support of Firebird 4 functions in parameters tip.

2. PSQL object editors

  • Support of Firebird 4 syntax extensions.

3. Database backup

  • Support of backup to local machine - Backup to client side option.
    If this option is ON the backup file will be created on the client side instead of the server side.

4. Database restore

  • Support of restore from a local backup to a remote server - Restore from client side option.
    If this option is ON the local backup file will be used while restoring a database.

5. PSQL debugger

  • Support of management statements (Firebird 4).

6. Database explorer

  • For inactive indices IBExpert uses the same color as for inactive triggers (customizable in Options | Environment Options | DB Explorer).

7. Script Executive

  • Support of case-sensitive user and role names (FB 3, FB 4) in CREATE DATABASE and CONNECT statements.
    Case-sensitive names should be quoted with double quotes:

    CONNECT ... USER "SYSdba" ROLE "Admin_Role" ...;

8. Export data into a script

  • Support of DECFLOAT values (Firebird 4).

9. Test Data Generator

  • Support of TIME/TIMESTAMP WITH TIME ZONE columns (Firebird 4).

10. Grant Manager

  • Support of system privileges (Firebird 4).

11. IBEBlock

  • ibec_BackupDatabase, BackupToClient option implemented.
    If specified, the backup file will be created on the client side instead of the server side.
  • ibec_RestoreDatabase, RestoreFromClient option implemented.
    If specified, the local backup file will be used while restoring a database.

12. New IBExpert Backup Restore Service Version

  • Allows all options for IBEGbak and gbak also for Firebird 3.

13. New tools subdirectory with IBEGbak, IBELog and ufw

  • IBEGbak allows service-based backup/restore tasks to run faster, especially when using multiple servers over the network. Start the command-line tool IBEGbak.exe to view all possible parameters.
  • IBELog.exe and IBELogGUI.exe allows you to convert a Backup Log into a table-based compressed format to see which tables are responsible for long run times.
  • ufw.exe is an easy command-line tool to allow opening or closing TCP/IP ports in the Windows firewall. ufw is known in the Linux world.

Examples:

    		ufw allow 3050 

		ufw deny 3050 

14. Other minor bugfixes and small improvements

back to top of page


IBExpert 2018.12.15

and bugfix version 2019.01.15

1. Initial support of time zones (Firebird 4)

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md

2. Support of alternatives for embedding quotes in string literals

https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk02ch09s06.html#rnfb30-dml-altquoting

3. Support of BINARY/VARBINARY datatypes (Firebird 4)

4. Code Insight

  • Field descriptions are displayed if they exist.

5. SQL Editor

  • Now it is possible to start the SQL Editor without an active connection to execute IBEBlocks and to search for queries.

6. Minor bugfixes and small improvements.

back to top of page


IBExpert 2018.11.15 - bug fixes

This version includes important bug fixes for:

back to top of page


IBExpert 2018.10.18 & 2018.10.28

1. Database Inside

  • The issue with the incorrect extracting of generator values has been fixed.

2. PSQL Parser, Code Editors

  • Support for LOCALTIME and LOCALTIMESTAMP context variables has been implemented (Firebird 3.0.4).

3. User Manager

  • Support for cumulative roles has been implemented (Firebird 4).
  • Support for default roles has been implemented (Firebird 4).

4. Other minor bug fixes and improvements

back to top of page


IBExpert 2018.10.02

1. PSQL Debugger

  • Debugging of FOR SELECT ... AS CURSOR statements implemented.

2. Table data comparer

  • Synchronizing of internal generators for IDENTITY columns (FB 3, 4) implemented.

3. Extract metadata

  • Use RECREATE for tables option implemented.

If this option is ON IBExpert will use the RECREATE TABLE statement instead of CREATE TABLE.

4. Database Restore

  • Buffers option has been added to set the default database cache size (in number of database pages) for the database being restored.

5. SQL Editor

6. DB Explorer

  • Events log page implemented which contains the log of executed event blocks within the IBExpert session.
    • Double click a log entry to edit the existing event block.
    • Use the context menu to create a new event block or edit an existing one.

7. Event blocks

  • Process general template event block implemented.

This event block is an extension for Options/General templates and is intended for generating new object names, new PSQL object templates etc. For compatibility IBExpert first processes the specified "general template" and then passes it to the event block (if such a block is defined), where you can modify the result or compose it from scratch.
See the block template for more details.

8. IBEBlock

  • ibec_http_xxx functions now support the HTTPS protocol.
  • ibec_ExtractMetadata: UseRecreate option implemented. If this option is specified, the RECREATE TABLE statement will be used instead of CREATE TABLE.

9. Other minor bug fixes and improvements

back to top of page


IBExpert 2018.06.03 & 2018.07.19

1. Query datasets

  • To reduce number of possible out of memory errors we have redesigned the internal mechanism of storing records fetched from the server. If the records buffer is too much to fit in the RAM it will be flushed into a temporary file and the dataset will continue to work with that file instead of RAM. In that case the records fetched label above the data grid will change its color from Windows text (usually black) to blue. Also it will display the temporary file size, i.e. Records fetched: 1000000 :: 8366 M.

2. PSQL debugger

  • Possibility to debug procedures/triggers/functions that contain subroutines has been implemented. To debug such PSQL objects IBExpert will create a temporary debug package with subroutines declared in PSQL object source. Normally that package will be deleted when the debugger window is closed.

3. Database Backup

  • Backup IBEBlock page implemented. It contains an autogenerated IBEBlock for the database backup.

4. Database Restore

  • Restore IBEBlock page implemented. It contains an autogenerated IBEBlock for the database restore.

5. Data grid

  • OCTETS option (button) implemented. If this button is down IBExpert displays CHAR/VARCHAR CHARACTER SET OCTETS strings in a hexadecimal representation. If there are no octets fields in a record set the OCTETS button is hidden.

6. Metadata Extract

  • Bugfix: database event triggers were extracted as inactive if Delayed activation of database events and DDL triggers option was deactivated.

7. Input parameters form

  • Compact view style implemented.

8. Export data

  • Bugfix: some symbols of page footer/header were not escaped (i.e. some symbols need to be replaced with combination of other symbols) when exporting data into XLSX file.
  • Bugfix: Open file after export option didn't work with XLSX files.

9. Table Data Comparer

  • Ignore syncronization errors option implemented. If this option is ON all INSERT/UPDATE/DELETE errors during online synchronization are ignored allowing an attempt to execute all statements in the synchronization queue.

10. IBEBlock

  • ibec_CompareTables: IgnoreSyncErrors option added.
  • ibec_BackupDatabase, ibec_RestoreDatabase:
    • Support of SQL role implemented. To use an SQL role specify it in the option string: Role=SOMEROLE.

11. Other minor bug fixes and improvements

back to top of page
<< DBEncryption Plugin for Firebird 3.0 | IBExpert | IBExpert new features archive >>