IBExpertDemoDB

Use the IBExpertDemoDB for benchmark testing. The UDFs and SQLs necessary to generate the demo database can be found in the IBExpert Developer Studio's /IBExpertDemoDB directory. The documentation lists the simple steps needed to generate a demo database to the size of your choice.

The IBExpert Benchmarks article illustrates in detail how to utilize this valuable function as a sample web shop.

In the subdirectory, \IBExpertDemoDB, you will find a script, db1_30.sql, which you an use to create a Firebird 3.0 database. Among other things this includes a Soundex function as a stored procedure, as a stored function and as a package. By these means you can create your own functions in Firebird 3.0 or using your own UDF, and use them in SQL as if they were an internal function.

Furthermore there is a basic implementation for a materialized view alternative in this script, which can also be used with older Firebird versions.

By combining a view with a static table it is possible to avoid calculating complex result sets each and every time, and only recalculate them following expiry of specified time intervals.  


Newsletter 10/2024

Our newest IFS servers now deliver even better benchmarks

Our 10 years’ experience constructing dedicated Firebird servers means you do not have to purchase your Firebird server on a trial-and-error basis, but can rely on our experience to provide you with a server that delivers optimum performance.

We constantly research and test the newest available hardware components, to provide the best possible dedicated Firebird servers at a competitive price.

And with our Hardware maintenance and RemoteDBA service, we support you all the way.

The benchmark value on the right was ascertained with Ubuntu Linux 22 and Firebird 5.

Read more about our servers here: https://ibexpert.net/cms/firebird-ifslr-server.

Determine the benchmark of your current server using our free IBExpert Benchmark Tool.

Contact us for a written offer: sales@ibexpert.biz.


Firebird performance issues

How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?

The IBExpert Benchmark is a simple but effective tool, which gives you a reference benchmark, based on our recommended IFS Servers. Using IBExpert Benchmark you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used. 

Perform the comparison yourself using our free IBExpert benchmark software on your Firebird server: https://ibexpert.net/benchmark/setup_benchmark.exe

Read more


IBExpert Firebird 3 Bootcamp



(German-language version below)

The Firebird 3 Bootcamp is for admins and developers who have been actively working with Firebird for at least 2 years. The focus is on upgrading to Firebird 3 and optimization of your own database environment (also for Firebird 2.x). You can expect interesting talks covering all aspects of Firebird, IBExpert, Lazarus and Delphi development. The focus is on the practical application of the technologies and methods presented, which can also be implemented with other programming languages.

Benefit from the knowledge of the IBExpert database experts.

Overview of topics

Client development

  • Debugging a Delphi/Lazarus database application with the integrated debugger
  • Create appropriate events for additional protocols without the Debugger
  • Server-side monitoring of database applications
  • Establishing a 24/7 monitoring protocol on the server
  • Network monitoring of database communication at TCP/IP packet level
  • Performance comparison of different components: TxxTable, TxxDataset, TxxQuery etc.
  • Identify and assess automatically component-generated SQLs
  • Identify SQLs on the server based on source code additions in the Delphi/Lazarus source code
  • Automatically supplement own profiling methods in the Delphi/Lazarus source code
  • Autocommit or manual commit?
  • Use Prepare or not?
  • SQLs with or without parameters? Advantages and disadvantages!
  • Integrate block commands

Server development

  • Basic knowledge regarding the Firebird server functionalities and architecture
  • Detect inadequate transaction handling and assess impact
  • Locate long-running transactions in network operation, identify the cause
  • Techniques to end long-running transactions on the server side
  • Analyze trigger sequences and log the process
  • Measure and evaluate speed benefits of stored procedures
  • Create and debug stored procedures and triggers using IBExpert
  • Global database analysis: lack of primary keys, detection of duplicates, false and missing indices
  • Use calculated fields for maximum performance and manage display using permissions
  • Use data types and table definitions properly
  • Correct use of execute statement on external

Administrative tasks

  • Visualize a database model using IBExpert
  • Export a database model for version control in SVN or similar
  • Use IBExpert to set up versioning of stored procedures and triggers
  • Automate metadata comparison between the development database and the production database
  • Automate an automatic data synchronization between multiple databases using scripts
  • Data backup using Backup tools during normal operation
  • Optimize running time of the data backup
  • Shadow as an alternative high-speed backup method
  • Basic knowledge of replication as a real-time backup
  • Measure hardware speed and compare using IBExpert Benchmark
  • Tips and Tricks to optimize hardware and software for a Firebird Server 

IBExpert Firebird Bootcamps: What our customers are saying




IBExpert Firebird 3 Bootcamp

Das Firebird 3 Bootcamp wendet sich an Admins und Programmierer, die mindestens 2 Jahre aktiv mit Firebird arbeiten. Dabei konzentrieren wir uns auf den Umstieg auf Firebird 3 und die Optimierung der eigenen Datenbank-Umgebung (auch für Firebird 2.x). Es erwarten Sie interessante Themen rund um die Entwicklung mit Firebird, IBExpert, Lazarus und Delphi. Der Fokus liegt dabei konsequent auf dem praktischen Einsatz der vorgestellten Technologien und Methoden, die auch mit anderen Programmiersprachen umgesetzt werden können.

Profitieren Sie vom Wissen der IBExpert Datenbank Experten.

Themen im Überblick

Client Entwicklung

  • Debuggen einer Delphi/Lazarus Datenbankanwendung mit dem integrierten Debugger
  • Erstellen geeigneter Events für zusätzliche Protokolle auch ohne Debugger
  • Netzwerkmonitoring der Datenbankkommunikation auf TCP/IP Paketebene
  • IBExpert Database Monitoring
  • Trace API einsetzen und auswerten
  • Performancevergleich verschiedener Komponenten: TxxTable, TxxDataset, TxxQuery etc.
  • Automatisch von Komponenten erzeugte SQLs erkennen und bewerten
  • SQLs auf dem Server anhand von Quelltextergänzungen im Delphi/Lazarus Quellcode identifizieren
  • Eigene Profiling Methoden automatisiert im Delphi/Lazarus Quellcode ergänzen
  • Autocommit oder manuelles Commit?
  • Mit Prepare oder ohne Prepare?
  • SQLs mit oder ohne Parameter? Vor- und Nachteile!
  • Befehle in Blocks zusammenfassen
  • Einfache Webanwendungen erstellen

Server Entwicklung und administrative Aufgaben für Entwickler

  • Basiswissen zur Arbeitsweise und Architektur des Firebird Servers
  • Mangelhaftes Transaktionshandling erkennen und Auswirkungen bewerten
  • Zuordnung langlaufender Transaktionen im Netzwerkbetrieb, Identifikation des Verursachers
  • Techniken, um langlaufende Transaktionen serverseitig zu beenden
  • Trigger Sequenzen analysieren und Ablauf protokollieren
  • Geschwindigkeitsvorteile von Stored Procedures messen und bewerten
  • Stored Procedures und Trigger mit IBExpert erstellen und debuggen
  • Globale Datenbankanalyse: fehlende Primärschlüssel, doppelte, falsche und fehlende Indizes erkennen
  • Berechnete Felder performant einsetzen und Anzeige über Berechtigungen steuern
  • Datentypen und Tabellendefinitionen richtig einsetzen
  • Execute Statement on External richtig einsetzen
  • Basiswissen Replikation als Echtzeitbackup
  • Datenbankmodell mit IBExpert visualisieren
  • Datenbankmodell für eine Versionskontrolle in SVN o.ä. exportieren
  • IBExpert für Versionierung von Stored Procedures und Trigger einrichten
  • Automatisierter Metadatenabgleich zwischen Entwicklungsdatenbank und Produktionsdatenbank
  • Automatisierter Datenabgleich zwischen mehreren Datenbanken per Script automatisieren

Administrative Aufgaben

  • Datensicherung über Backup Werkzeuge im laufenden Betrieb einsetzen
  • Laufzeit der Datensicherung optimieren
  • Shadow als alternative High Speed Sicherungsmethode
  • Hardwaregeschwindigkeit messen und vergleichen mit IBExpert Benchmark
  • Serverseitiges Monitoring von Datenbankanwendungen
  • Einrichtung eines 24/7 Monitoring Protokolls im Server
  • Reports, automatisierter Import und Export csv, pdf etc
  • Tipps und Tricks für optimale Hardware und Software für einen Firebird Server
  • Was bringt die neue Mehrprozessorfähigkeit in Firebird 3.0 wirklich?
  • Einsatzmöglichkeiten für Packages und Internal Functions
  • Was muss man bei einer Umstellung auf Firebird 3.0 beachten?
  • Benchmark Vergleich Firebird 2.5/Firebird 3.0
  • IBExpert Tipps und Tricks für die tägliche Arbeit
  • Warum SQL Befehle selber schreiben, wenn diese im IBExpert Assistent schnell und zuverlässig erzeugt werden können
  • Softwaremodelle Developer Studio, Company Year Edition und Day Edition
  • Firebird.conf optimieren  

IBExpert Firebird Bootcamps: Was unsere Kunden sagen




IBExpert products, services & prices



Below you can find a summary of all IBExpert products and services which can be purchased online. All prices listed here apply only for online purchases.

Click on the corresponding icon, and you will automatically be forwarded to our trading partner, PayPro Global. PayPro Global is responsible as the seller for all data and content of the online shop.

If you have any further questions please mail us at sales@ibexpert.biz.

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).

Software Services & Support






IBExpert Developer Studio Edition

IBExpert Developer Studio is the most comprehensive GUI tool for Firebird and InterBase® on the market today. It includes the following components: IBExpert IDE, IBEScript.exe, and IBExpertDemoDB. Read the full software product details here.

IBExpert Developer Studio Packages No. of
activations
Subscription
for the first
12 months

Online price in Euros
(EUR) net of sales tax/VAT
Subscription
for the next
12 months

Online price in Euros
(EUR) net of sales tax/VAT
Subscription
after expiry more
than 12 months

Online price in Euros
(EUR) net of sales tax/VAT
IBExpert Developer Studio Single 1 280.00 132.00 206.00
IBExpert Developer Studio multiple 2-4 2-4 250.00 each 115.00 each 182.00 each
IBExpert Developer Studio multiple 5-9 5-9 210.00 each 99.00 each 154.00 each
IBExpert Developer Studio multiple 10-24 10-24 160.00 each 75.00 each 118.00 each
IBExpert Developer Studio multiple 25-49 25-49 140.00 each 65.00 each 100.00 each
IBExpert Developer Studio multiple 50+ 50+ 125.00 each 60.00 each 90.00 each

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert Developer Studio Day Edition

The IBExpert Day Edition is the ideal supplement to all IBExpert full versions, ready for use on all computers at any time. Read the full software product details here.

IBExpert Day Edition Packages Online price in Euros (EUR)
net of sales tax/VAT
Day Edition 25 activations, valid 12 months
IBExpert IDE 25 individual activations.
43.75
Day Edition 100 activations, valid 12 months
IBExpert IDE 100 individual activations.
155.00
Day Edition 250 activations, valid 12 months
IBExpert IDE 250 individual activations.
237.50
Day Edition 500 activations, valid 12 months
IBExpert IDE 500 individual activations.
300.00
Day Edition 1000 activations, valid 12 months
IBExpert IDE 1,000 individual activations.
500.00
Day Edition 2500 activations, valid 12 months
IBExpert IDE 2,500 individual activations.
1,125.00
Day Edition 5000 activations, valid 12 months
IBExpert IDE 5,000 individual activations.
2000.00

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert Developer Studio Company Year Edition

Use the IBExpert IDE, IBEScript.dll, IBEScript.exe, and the BackupRestore Scheduler modules on multiple computers, also in virtual environments and/or in the cloud, without hardware-related unlock codes. Read the full software product details here.

In a virtual environment, which does not always run on the same hardware, the use of an IBExpert Company Year, Enterprise Server Year, Distribution OEM is necessary to avoid problems such as machine locks.

Description Months Online price in Euros (EUR)
net of sales tax/VAT
IBExpert Company Year Edition S
The IBExpert Company Year Edition S may only be used by companies with up to 20 employees, of which a maximum of 2 may use IBExpert. For further information and purchase please contact sales@ibexpert.biz
1. Total number of all employees: <= 20
2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: <= 2
3. IBExpert activations: 20
12 550.00
IBExpert Company Year Edition M
1. Total number of all employees: <= 100
2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: <= 5
3. IBExpert activations: 50
12 1,050.00
IBExpert Company Year Edition L
1. Total number of all employees: <= 500
2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: <= 10
3. IBExpert activations: 100
12 2,200.00
IBExpert Company Year Edition XL
1. Total number of all employees: <= 1,000
2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: unlimited
3. IBExpert activations: 1000
12 5,250.00

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert Enterprise Server Year Edition

In a virtual environment, which does not always run on the same hardware, the use of an IBExpert Company Year, Enterprise Server Year, Distribution OEM is necessary to avoid problems such as machine locks.

Work with IBExpert software in a virtual environment
The ESYE contains the following components: IBExpert IDE, IBEScript.dll, IBEScript.exe and the BackupRestore Scheduler. ... Read the full software product details here.

Description Months Online price in Euros (EUR)
net of sales tax/VAT
1 * IBExpert activation for 1 Server, location-independent 12 649.00

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert Server Tools

The IBExpert Server Tools include IBEScript exe and dll, hkSCC.exe, the IBExpert Backup/Restore Scheduler and the IBExpert Encryption Plugin for Firebird 3 on Win32/Win64. The IBExpert Server Tools can also be deployed on virtual machines or in a cloud infrastructure. Read the full software product details here.

Description No. of users Online price (EUR)
net of sales tax/VAT
IBExpert Server Tools single edition for one activation 1 169.00
IBExpert Server Tools multiple activations   upon request

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert Distribution OEM Edition

Our optimal solution for all businesses for flexible and independent working with IBExpert on all physical or virtual computers without activation codes and without an active internet connection. Read the full software product details here.

Description Price in Euros (EUR)
net of sales tax/VAT
OEM Distribution Edition: IBExpert.exe 12,650.00
OEM Distribution Edition: IBEScript.exe 12,650.00
OEM Distribution Edition: IBEScript.dll 12,650.00

Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
By ordering you agree to the OEM Distribution Edition terms and conditions.

Please mail sales@ibexpert.biz if you wish to order this software product.




IBExpert Encryption OEM Edition

The IBExpert Encryption Plugin for Firebird enables you to securely encrypt your Firebird 3 and Firebird 4 databases (also embedded). ... continue reading.

Description Price in Euros (EUR)
net of sales tax/VAT
IBExpert Encryption OEM for Firebird 3 and Firebird 4 incl. 12 months subscription 4,200.00
IBExpert Encryption OEM for Firebird 3 and Firebird 4 (no subscription) 2,950.00
IBExpert Encryption OEM for Firebird 3 and Firebird 4 optional surcharge for the source code 5,950.00

Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).

Please mail sales@ibexpert.biz if you wish to order this software product.




IBExpert Replicator Enterprise IBER

Add real-time replication to any Firebird database without any downtime. ... continue reading.

Description Price in Euros (EUR)
net of sales tax/VAT
IBExpert Replicator Enterprise IBER Starter Package including init and 12 months support 990.00
IBExpert Replicator Enterprise IBERSub Subscription Package 12 months support 590.00

Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).


IBExpertFunctionLibrary

The IBExpertFunctionLibrary is a comprehensive set of functions, suitable for all Firebird versions. ... continue reading.

Description Price in Euros (EUR)
net of sales tax/VAT
IBExpertFunctionLibrary Enterprise Maintenance Subscription 990.00

Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




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.

Description Price in Euros (EUR)
net of sales tax/VAT
IBExpert Benchmark Tool: Download here free of charge



IBExpert Developer Studio Personal Edition

The IBExpert Personal Edition for private users includes the IBExpert IDE. Read the full software product details here.

Description No. of users Price in Euros (EUR)
net of sales tax/VAT
IBExpert Personal Edition 1 workstation free of charge



IBExpert Developer Studio Full Educational Edition

The IBExpert Developer Studio Full Educational Edition is a full IBExpert Developer Studio version. Read the full software product details here.

Description No. of users Online price in Euros (EUR)
net of sales tax/VAT
IBExpert Developer Studio Full Educational Edition incl. 12 month software subscription 1 workstation upon request

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).

Furthermore, IBExpert is also available as a free IBExpert Developer Studio Educational Edition.




IBExpert services & support

We offer a wide range of training and support services for Firebird, InterBase®, Lazarus, Delphi®, FastReport® and of course, IBExpert. All support and training services are available worldwide; languages spoken: German and English. View the full details and conditions of these services here.

Description Online price in Euros (EUR)
net of sales tax/VAT
IBExpert Prepaid Hotline Account 60 minutes
Firebird, InterBase®, IBExpert, Delphi®, FastReport support hotline
135.00
IBExpert Prepaid Hotline Account 120 minutes
Firebird, InterBase®, IBExpert, Delphi®, FastReport support hotline
260.00
IBExpert Prepaid Hotline Account 240 minutes
Firebird, InterBase®, IBExpert, Delphi®, FastReport support hotline
500.00
IBExpert Prepaid Hotline Account 480 minutes
Firebird, InterBase®, IBExpert, Delphi®, FastReport support hotline
970.00
IBExpert Prepaid Hotline Account 960 minutes
Firebird, InterBase®, IBExpert, Delphi®, FastReport support hotline
1,880.00
Database analysis: evaluation fee 150.00
Database analysis express: evaluation fee 300.00
IBExpert Firebird SQL Performance Monitoring
... further information.
1,200.00

Please mail sales@ibexpert.biz if you wish to order one of this software products. We will send you an invoice.

All prices quoted here apply only to online purchases. Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).




IBExpert and Firebird Training and Workshops

Our training sessions using online video transmission combine personal training with physical independence: promptly and flexibly and tailored to your requirements

Perhaps your team is also located at different sites?
All employees can take part in our training courses, even from their home office.
The number of participants does not affect the cost.

The coaching days can be scheduled at relatively short notice and you and your team will not be absent from productive work for too long during the course.
The course can take place in a much shorter period of time. We train in blocks of 2-4 hours at a time.

We tailor all topics individually to your company and the requirements of your team, taking into account the level of knowledge of the participants and also look at tackling current projects.
The training courses can thus be structured in blocks and/or key topics can be scheduled for different employees, and can of course also be adjusted during an ongoing training session.
Our workshops are complemented by video recordings, which we capture during the workshops and make them available to you in digital form.

Workshops are much more effective when you structure them interactively. We offer our courses as interactive workshops and not in a classic lecture format.

You can send your training enquiry to register@ibexpert.biz

We coordinate the agenda, the dates and the technical implementation together with yourselves.

Topics

Upgrading from Firebird 2.5 to 3.0/4.0
Setting up a permanent SQL monitoring on your own database
Applying the Trace API and results for optimization
Setting up and understanding basic master-slave replication
Working with multiple databases and transparent external blob storage

IBExpert is the ideal partner for training and workshops in your company

Years of experience allow you to gain access to tried and tested strategies and techniques for software development. The training sessions take place over a period of 1-5 days, depending upon the participants’ previous knowledge and the depth and range of the topics covered.

We provide expert workshops at your company, tailored to fit your needs. Send us your detailed list of requirements, and we will send you a written offer, recommending the number of days necessary to ensure your team can learn the necessary skills to fulfil your requirements.

Our standard courses:

IBExpert und Firebird Power Workshop
IBExpert Firebird 3 Bootcamp
Bootcamp database web applications using Firebird
Firebird Developer Days
Lazarus training for Delphi programmers



IBExpert Personal Edition features

The IBExpert Personal Edition is a free version, offering new users the chance to get acquainted with IBExpert at their own pace. It is however somewhat limited in its functionality, and does not include the following features:

Further information regarding the free IBExpert Personal Edition can be found on our website.

Please note: due to the vast amounts of downloads the free IBExpert Personal Edition registration procedure is fully automated. We can therefore provide neither support nor service for this software edition.

Further information regarding the free IBExpert Personal Edition can be found in our IBExpert online documentation:

You can also find tips and solutions to a number of frequently asked questions: