IBExpert 2025.06.18

IBExpert, developed by IBExpert KG, is a comprehensive and robust integrated development environment (IDE) tailored specifically for database administrators and developers working with Firebird and InterBase databases. This powerful toolset is designed to streamline and enhance the database management and development process, making it an indispensable asset for professionals in the field.

At its core, IBExpert offers an intuitive and user-friendly interface that simplifies complex database tasks. The software's extensive feature set includes advanced SQL editing capabilities, a sophisticated database designer, and a powerful debugger, all of which contribute to a more efficient and productive workflow. The SQL editor supports syntax highlighting, auto-completion, and error detection, ensuring that code is both accurate and optimized.

One of the standout features of IBExpert is its comprehensive database management tools. Users can easily create, modify, and manage database objects such as tables, views, triggers, and stored procedures. The software also provides detailed metadata analysis and reporting, enabling users to gain deep insights into their database structures and performance.

IBExpert's robust debugging tools are another highlight, offering step-by-step execution, breakpoints, and variable watches. These features allow developers to identify and resolve issues quickly, ensuring that applications run smoothly and efficiently. Additionally, the software includes a powerful data analysis tool that enables users to perform complex queries and generate detailed reports, facilitating data-driven decision-making.

The software's database monitoring capabilities are equally impressive, providing real-time insights into database performance and resource utilization. This allows administrators to proactively address potential issues and optimize database performance. IBExpert also supports automated tasks and scripting, enabling users to automate routine maintenance and administrative tasks, further enhancing productivity.

IBExpert is designed with flexibility in mind, supporting multiple database connections and allowing users to work with multiple databases simultaneously. This is particularly beneficial for organizations that manage large and complex database environments. The software also offers seamless integration with various third-party tools and services, extending its functionality and versatility.

Security is a top priority for IBExpert KG, and the software includes robust security features to protect sensitive data. Users can define and manage access rights, ensuring that only authorized personnel can access and modify critical database information.

In summary, IBExpert by IBExpert KG is a feature-rich and versatile IDE that caters to the needs of database administrators and developers working with Firebird and InterBase databases. Its powerful tools, intuitive interface, and comprehensive feature set make it an essential tool for optimizing database management and development processes. Whether you are a seasoned professional or a newcomer to database administration, IBExpert provides the tools and capabilities needed to achieve success in your database projects.

Release notes:

New Release
Minor bugfixes and small improvements
Event blocks:
"Before start trace session" event block implemented.
See BlocksTemplatesEventBlocksTAS.BeforeStartTraceSession.ibeblock for an example. Also see description of new "Quick start trace session" feature below.
Code editors:
Support for multilevels in User actions submenu.
See BlocksTemplatesEventBlocksCodeEditorUserActions.ibeblock for a working example.
Database Comparer:
Fixed the problem with missing stored functions and packages while comparing Firebird 5 databases.
Quick start trace session feature implemented:
This feature is intended to start a trace session for an active connection with a single click.
Default trace config is provided by IBExpert and can be modified in the "Before start trace session" event block which is fired when quick start or regular start (Services | Trace and Audit | Start new trace session) is performed.
There are several other properties of trace session and trace form which can be customized in the "Before start trace session" event block.
See BlocksTemplatesEventBlocksTAS.BeforeStartTraceSession.ibeblock for complete example. To quick start a trace session, use the corresponding button on the main form tool button. Alternatively it can be done using the [Ctrl] + [Shift] + [T] shortcut.
IBEBlock:
ibec_psql_PreprocessPSQL function implemented.
It inserts some placeholders in the form of single line comments into a provided PSQL source (procedures, functions, triggers and package routines) which can be later replaced with additional debug statements (INSERT into a log table etc.). For a complete example see BlocksDefaultBlocksPSQL.PrepareForDebug.ibeblock.
There is also a working implementation of calling this block from BlocksTemplatesEventBlocks CodeEditorUserActions.ibeblock which performs the preparation of the PSQL source for debugging and removes debug statements and comments from the PSQL source when they are no longer needed.
[ IBExpert full changelog ]