IBExpert Newsletter 11/2022
Read our latest newsletter here: IBExpert and Firebird News 11/2022
New IBExpert version 2022.11.14
and bugfixes 2022.11.28, 2022.12.02 & 2023.01.03
- SQL Editor: new features: Execute with commit, Autocommit for the current SQL Editor, Convert SELECT / WITH into IBEBlock.
- Metadata Search: Web-style search implemented.
- Version history support for Firebird and IBExpert blocks.
- Visual Options: Disable undocked toolbars option introduced.
- ibec_StartTraceSession: function improvements.
View all new features here: IBExpert documentation: What's New.
IBExpert Firebird Newsletter 10/2022
IBExpert: How to do it?
Part 1: Automatic comparison of the database structure between several databases
Part 2: Automatic synchronisation of table contents between several databases as a permanently active backup
You can read this month's newsletter here:
How to do it? Automatically synchronise metadata and data and create a permanently active backup!
or download the PDF version.
You can subscribe to our newsletter in the IBExpert Download Center (see Subscribe for details)
Firebird and IBExpert White Paper: ibec_StartTraceSession
Read here: Firebird and IBExpert White Paper: ibec_StartTraceSession (PDF download)
Firebird and IBExpert White Paper
The Cloud and Firebird: The physical fundamentals of failure or
why it works really well when you do it right!
Read here: Firebird and IBExpert White Paper: The Cloud and Firebird (PDF download)
Basic introduction to the Firebird Security Database, port redirection and multi-instances
Read here: Basic introduction to the Firebird Security Database, port redirection and multi-instances
Firebird and IBExpert White Paper:
Advanced debugging event block
Read here: Firebird and IBExpert White Paper: Advanced debugging event block
More examples will be published here during the next few weeks.
Further information regarding IBExpert's IBEBlock feature Event Blocks can be referred to here: Event Blocks.
Firebird and IBExpert White Paper:
DBEncryption Plugin Delphi demo for Firebird 3 and Firebird 4
The second in this series of Firebird DBEncryption documents shows you how to create a Delphi example and pass encryption keys: DBEncryption Plugin Delphi demo for Firebird 3 and Firebird 4
See also: IBExpert Encryption OEM for Firebird 3 and Firebird 4.
Firebird and IBExpert White Paper:
Firebird and REST
Read our newest White Paper all about dealing with REST requests: Firebird and IBExpert White Paper: Firebird and REST
Firebird and IBExpert White Paper:
Firebird external engine and UDRs written in Pascal
An example of UDR functions, triggers and procedures
We have just published a new White Paper explaining Firebird 3's ExternalEngine and UDRs: Firebird and IBExpert White Paper: Firebird external engine and UDRs written in Pascal
IBExpert and Firebird News 01/2022
Topics include:
- White Paper: 3rd Party Backup Solutions on IFS Servers and why we explicitly advise against it!
- IBExpert telephone hotline support
Performance comparison with the new IBExpert Benchmark v2.0
Following the release of our IBExpert Benchmark Tool 2.0, we have revised our Firebird Performance comparison, which you can read here: Firebird Performance comparison of Windows and Linux Operating Systems.
Win a free IBExpert Developer Studio Edition
You will find the IBExpert Benchmark Tool v2.0 in the current IBExpert Developer Studio Edition (2021.11.16). If you do not yet own an active IBExpert Developer Studio full version, download our free IBExpert Benchmark Tool here: https://ibexpert.net/benchmark/setup_benchmark.exe
Post your results on Facebook or Twitter (#IBExpertBenchmark) and win a free IBExpert Developer Studio full version. Details here: Benchmark Offer
IBExpert Firebird Benchmark test result
Post your results on Facebook or Twitter (#IBExpertBenchmark) and win a free IBExpert Developer Studio full version. Details here: https://bit.ly/3pUsajs
White Paper: Firebird 4 versus Firebird 3 single thread performance comparison
We have just published a White Paper, with what some may find as surprising results when comparing Firebird 3 to Firebird 4. It also includes a sample IBEBlock, so that you can perform a comparison in your own environment: White Paper: Firebird 4 versus Firebird 3 single thread performance comparison
We are currently compiling a selection of links and documentation dedicated to Firebird 4, which you can find on our documentation page: Firebird 4.0.
Thoughts on Firebird Performance
A brief paper by Holger Klemt: Thoughts on Firebird Performance.
IBExpert and Firebird News 10/2021
Take a look at our current newsletter!
Topics include:
- Free benchmark test and consultation
- IBExpert Firebird SQL Performance Monitoring
- IBExpert Firebird Database Server
How to start with FbNetExternalEngine, by Jiri Cincura
In this YouTube tutorial, Jiri provides an easy to follow guide to install the FbNetExternalEngine into Firebird and create a simple function.
This example is not just for .NET developers of interest; it shows how easy it is to create a UDR external function and connect it to Firebird as a Plugin.
You can find a comprehensive list of all Firebird and IBExpert related tutorials in the IBExpert Learning Center.
White Paper: Firebird 4 database replication
We have published a White Paper, introducing you to the new Firebird 4 replication feature: White Paper: Firebird 4 Replication
We are currently compiling a selection of links and documentation dedicated to Firebird 4, which you can find on our documentation page: Firebird 4.0.
Firebird 4 technical specifications
Discover the true technical potential of Firebird 4 databases: Firebird 4 technical specifications
Firebird White Paper: Firebird 4 and IBExpert
by Fikret Hasovic, July 2021
Read our new White Paper introducing you to Firebird 4.0, along with tips about what to look out for, when upgrading to Firebird 4 from older versions.
Download the PDF here: White Paper: Firebird 4 and IBExpert
You can find all IBExpert White papers here: Database Technology Articles
Firebird 4.0 has been released!
You can find all download packages here: https://firebirdsql.org/en/firebird-4-0/
Firebird 4.0 introduces new data types and many improvements without radical changes in architecture or operation, the most important are:
- Built-in logical replication;
- Extended length of metadata identifiers (up to 63 characters);
- New INT128 and DECFLOAT data types, longer precision for NUMERIC/DECIMAL data types;
- Support for international time zones;
- Configurable time-outs for connections and statements;
- Pooling of external connections;
- Batch operations in the API;
- Built-in cryptographic functions;
- New ODS (version 13) with new system and monitoring tables;
- Maximum page size increased to 32KB.
Link to the Firebird 4.0 Release Notes (along with all Firebird Release Notes) can be found in our online documentation here:
Firebird documentation
Link to the Firebird 4.0 Language Reference (together with all Firebird Languages References) can be found in our online documentation here:
Firebird SQL language references
Firebird White Paper: Firebird 3 Stored Functions
by Fikret Hasovic, May 2021
Read our new White Paper explaining Firebird 3's stored functions and demonstrating how easy they are to implement in your database development.
Download the PDF here: White Paper: Firebird 3 Stored Functions
You can find all IBExpert White papers here: Database Technology Articles
We are here for you!
There is still time to order your IBExpert software this year. For payments received today, the 21st December 2020, we will activate your product before the end of the year.
- IBExpert Developer Studio Edition
- IBExpert Developer Studio Day Edition
- IBExpert Enterprise Server Year Edition
- IBExpert Server Tools
- IBExpert & Firebird Hotline (for hotline/support appointments from 4th January 2021)
Is your software subscription about to expire? Please check our email reminder, which contains your order link.
Is your IBExpert Software Subscription still valid? Please take note of our reminder to renew your IBExpert Software Subscription, which you will receive by email 4 weeks before your software subscription expires. Your order link is included in this email.
IBExpert Firebird IFS Server
30% discount on all newly purchased Firebird IFS basic rack servers IFS2020ML with Linux server operating system*
We offer Firebird servers, as they should be. We won't reveal the technology used, but the end result is unbeatable performance, because we know what we need to put in, in order to accelerate your work.
Start the new year with your new Firebird server plus remote maintenance and support. We support you with the server setup and are there for you in case of modifications requests, such as backup/restore schedules or any issues. With us you will not experience infinite loops but direct contact with our specialists.
You can order the latest generation of our Firebird IFS Rackservers 2020 as a basic version with Linux operating system. The Firebird IFS2020ML server basic version comes with 500GB SSD storage space. The IFS2020ML reliably achieves IBExpert benchmark values between 230% and 400% with the current Firebird 64-bit Linux version, and our pre-installed configuration has proven to be extremely fast and reliable.
We are happy to offer further Firebird IFS2020 servers to meet your requirements on request: sales@ibexpert.biz.
We can analyse your current system within a short period of time and offer you a conversion to a high-performance system for the use of Firebird. Contact us and order your hotline credit. 60 minutes should be sufficient for an initial analysis: IBExpert and Firebird hotline - you can order here: https://order.shareit.com/cart/add?vendorid=24948&PRODUCT%5B300766149%5D=1.
* Our end-of-year offer is valid until 31.12.2020 (receipt of payment). Please send your effectual order with all requisite details by e-mail to sales@ibexpert.biz.
Our new IBExpert and Firebird Forum is online - register now
All questions regarding the IBExpert software and the Firebird database are welcome.
In order to ensure basic protection against bots and the like, we have added a mandatory login authorization for access to the URL.
You can access the forum here: https://ibexpert.com/forum
You must enter the user name SYSDBA together with the default password m***y, familiar to all Firebird users, at least once before you can register or log in.
Once you have accessed the forum, you can then register using your own personal details.
If you need more information about the forum, or have any questions or requests, please contact us at register@ibexpert.com.
IBExpert Benchmark Tool - Free special version
Compare your computer performance and test the speed of your Firebird Windows server with the free IBExpert Benchmark Tool. ... continue reading.
