You can join to the
Telegram chat for discussion.
New version of RedExpert 2023.01 is available.
Recompilation all triggers, procedures, functions and packages
Association of *.fdb files with RedExpert
Recalculation of index selectivity
Support for external triggers
SQL SECURITY support for procedures, functions and triggers
“Switch data display” button and key combination [ALT + NUM_ADD] in data tab
Exit confirmation dialog
Specifies explicitly how a table field is sorted (COLLATE) when creating a table
“DDL to create” tab in “Edit constraint” panel
Ability to view password during user creation and authorization at reddatabase.ru
Ability to replace “\n” with another symbol when exporting to file with separators
Ability to work with functions and packages in privilege manager
Support for triggers on views
Parsing SQL script with queries that have complex nested constructions
Incorrect default value generation for procedures and functions
Impossibility to create a new connection through the menu in the Russian localization
Generating of primary keys when creating a table, if their names must be escaped
Quotation mark when exporting into CSV
Error when interacting with table constraints that have invalid default names
Error when generating SQL script for adding table constraints when only one constraint was inserted into script instead of multiple ones
Red Expert hangs after a data access error in the “Data” tab of the “Table” menu.
Adding comments to database elements like “User” or “Domain” while editing them
Generating SQL script when adding a new column to a table
Export to a spreadsheet. Now export to Excel 2007 is possible
Automatic generation of table name on creation
Updating auto-complete cache after metadata changes
Incorrect displaying of procedure parameter sizes
Script execution error output if there is no connection
Executing non selective procedures in the query editor
Wrong message about authentication error
Invalid connection status in the toolbar
Loading data in a table when moving the cursor to the last table row
Updated keyword list for syntax highlighting
Creating a database with default charset
Flickering interface in privilege manager
Invalid representation of “DATE” type when exporting to SQL
Undo/redo (Ctrl+Z/Ctrl+Y) in the query editor
Nonoptimal space usage by result set in query editor
Application hangs when opening objects
Download and install the
Upscene Productions is happy to announce the next version of their test data generator tool:
“Advanced Data Generator 4.1.0”
A fast test-data generator tool that comes with a library of real-life data, can generate data to your database,
script or data files, many filling options, templates and much more.
Generate JSON data files
Sample generated data
New feature highlights:
HiDPI aware user interface
New demo-project video
Additional sample data and additions to data library
Support for generating data into JSON data files
Many macro improvements
Ability to generate sample statistical data
There are special editions for Firebird, MySQL, InterBase and Access.
Read more at
our website or download a trial version.
« Hide it
Upscene Productions is proud to announce
version 2.2.0 of “Hopper”, a stored routine debugger for InterBase, Firebird or MySQL.
This release brings support for Firebird 4 data types and MariaDB 10.3 and up PSQL features.
For more information, check the
Hopper page at our website.
About Hopper Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If you use stored procedures on these database systems, Hopper will be a great tool for debugging these routines.
About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 20 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
New version of RedExpert 2022.09 is available.
Ability to save columns order and width in trace manager Field with performance counters in Trace Manager Export tables of Trace Manager Import data from a text file with separator Export data to SQL script Ability to change activity for several triggers and indexes in the object tree External tables support Support for external procedures and functions Support for comments on tables, procedures, functions and views English version of the release notes
Quoting of table names when generating INSERT, UPDATE, DELETE queries Slow loading of tables Incorrect recognition of default value for procedure parameters if ‘=’ is used Table column comment formatting in DDL query Rollback transaction on closing request dialog Error in generating date and time values in the test data generator Wrong message about successful creation of external procedures and functions in request editor Incorrect generation of “create generator” query Errors of trace parsing Autocomplete columns to alias escaped table
Download and install the
In the article “How to install Firebird 3.0 and 4.0 on Linux” you can find the installation instruction for Firebird versions 3 and 4 on the popular Linux versions: CentOS 7, Oracle Linux 7/8, Debian 9/10, Ubuntu18/20, and OpenSUSE15.0.
How to install Firebird 3.0 and 4.0 on Linux
Recently we published the source code of IBProvider built-in client for work with Firebird without fbclient.dll.
It supports Firebird from v0.9.4 till v3.0.
It’s a stable and completely tested thing which has worked since 2017.
If you are interested in such things – you are welcome.
Source code of the test system is available, too.
Regards, IBProvider team.
Edit object button Password request dialog if password is empty Ability to work with cursors in a procedure Downloading updates in the background
Request for saving data when closing a dialog box Displaying tables on Firebird with version less than 2.5 Generating a function creation request with EXTERNAL NAME Inability to set the order of the index fields Incorrect display of dependencies Wrong generated column edit query when using a domain Syntax highlighting in views Recognition of object names in queries if they are at the beginning of a string Error adding a record with IDENTITY field Autocomplete errors in queries with aliases Tab-indexing order on connection page Wrong error “TABLE is in use” on attempt to remove table Error opening browser in Linux Index is active by default when created Modified the update dialogs High CPU load after connect DDL command generation error due to case-sensitive identifiers Connecting to a database immediately after it is created Commit transactions after they have been used Re-executing an SQL script without mandatory commit/rollback after a previous run Option to set null for string parameters in the parameter dialogue
Download and install the
We have a great New Year’s gift for everyone who uses IBProvider to work with Firebird.
This is the provider for Entity Framework Core v6.0 —
We tried to make it as good as possible.
And most importantly — we opened its
So you can make it even better 🙂
NET6 (Windows) Entity Framework Core v6.0 Firebird v3.0.8 LCPI ADO.NET Provider for OLE DB LCPI.IBProvider v5 Key Features
Supporting of databases with 1 and 3 dialects. Supporting of all FB3 datatypes, except arrays. Providing a local evaluation by server’s rules. Supporting mapping wide set of C# functions to SQL. Providing extensions for nullable value types. Acknowledgments
Thanks to our users and special thanks to Jeff Hampton who initiated this development process.
Thanks to the EFCore developers and special thanks to Andriy Svyryd.
Thanks to the developers npgsql/efcore.pg and FirebirdSQL/NETProvider.
This news on our website:
KR, IBProvider Team.
New version of RedExpert 2021.10 is available
Autocomplete in query editor (not all tables were displayed in the list) Syntax highlighting Wrong table name after editing the trigger Hiding system packages for version prior to 3 Connection cancellation Displaying an error while fetching ResultSet Parsing errors in the trace manager Slow work of the grant manager Inability to undo domain selection Inability to add a column to a table if cursor is outside the fields area (while table creating). Reloading objects in the tree after changing Jump to an object from the dependency tree Formatting of generated SELECT, INSERT, UPDATE queries
A name of constrained is generated immediately when the form is opened
Display foreign key data while editing a table Context menu in “Set NULL” table A tab with object privileges System generators in the object tree Updating objects when they are changed in the query editor An update button for system tables
Download and install the