19th September 2016

Firebird 3 Encryption Plugin

Our new Firebird 3 Encryption Plugin will be available from October 1st, and included in all valid IBExpert Developer Studio editions and in the IBExpert Server Tools for use on the registered computer(s). A trial version is available immediately; if you are interested, please mail sales@ibexpert.com.

OEM Distribution and Source Code editions are available upon request.



14th September 2016

IBExpert, LLC has opened an office in Orlando, Florida

We are pleased to announce the opening of a new office location in Orlando, Florida in order to respond to increased demand for our services in the United States region. Our goal is to improve our capabilities to assist, support and consult clients throughout North and South America. Together with a professional development team in the USA and Germany we will be able to better meet our client needs. ... more.

IBExpert Firebird 2.x/3 Bootcamp: October 26th-27th, 2016 in Orlando, Florida, USA

The Orlando IBExpert office is looking forward to welcoming our founder Holger Klemt in Orlando. Holger will hold a 2 day IBExpert Firebird 2.x/3 Bootcamp covering Firebird administration/replication/security/performance topics October 26th-27th, 2016.

All participants will have the chance to purchase all IBExpert software products at special Bootcamp rates!

... ... IBExpert Firebird 2.x/3 Bootcamp October 26th-27th, 2016 in Orlando, Florida, USA.



6th September 2016

New IBExpert Version 2016.09.04 available

New features include:

  • Database Registration: Notification about the case sensitivity of user names (logins) for Firebird 3 added.
  • SQL Editor: You can now create stored scripts/blocks (which are stored in IBE$SCRIPTS table) from the SQL Editor content.
  • IBExpert User Database: It is now possible to set IBExpert User Database connection properties from an .INI file.
  • Blob Viewer: Improved image viewer.

Have you taken a look yet at just how many Firebird 3.0 features are already supported by IBExpert?: Firebird 3.0 features already implemented in IBExpert.

Fully automated update process

As long as you have IBExpert Direct activated in your IBExpert application, you will automatically be informed of all new updates, and automatically directed to the IBExpert Download Center, as soon as they are available. You can find out more about IBExpert Direct in our online documentation.

  • Has your subscription expired? Purchase your IBExpert 12 month software subscription in our online shop.
  • Is your software still valid for an IBExpert subscription? Check our software conditions here.


30th August 2016

What our customers have to say about our bootcamps:

"Three days pure Firebird: Firebird internals, Firebird replication, Firebird configuration, repairing Firebird, optimizing Firebird, basically: all things Firebird. It's not possible to pack more Firebird theory and practice into three days!

"The very next day, following the recommendations, we set about configuring a new PC as a Firebird server, initially without any software optimization: a LIKE search across all data by customer name previously took about 15 seconds, with the new server 2 seconds. Price of the previous server: 3,500 €, price of the new FB-Server PC: 1,000 €.

"We will need a few months to digest it all, and implement other parts of our newly gained knowledge. Thanks for the video recordings; they help enormously!"

Chris Hölzemann, Jürgen Medart, Ingenieurbüro Medart

"We would like to thank you for an excellent workshop. We've really learnt a lot about Firebird and IBExpert. The following topics were particularly important for ourselves: transaction control und error detection; Firebird database replication; shadows; developing Client/Server apps; hardware recommendations and Firebird server configuration; upgrade to Firebird 3.0 and the advantages compared to Firebird 2.5.

"PS: This was by far the best workshop I've ever participated in!"

Jakob Töws, Tele-Trac Kommunikations GmbH

"The bootcamp was, as was my previous participation in several IBExpert courses or workshops, very informative. Customer projects that I have implemented and which have been in use for a long time (replication, archive database, log triggers, etc. ...), can now be extended and optimized even further on the basis of the newly acquired knowledge.

"Working with IBExpert is continually improved, thus I can develop much faster in the database and integrate these improvements in customer projects and also in our ERP software.

"Holger Klemt also constantly offers tips, advice and guidance based on his very long experience, among other things: what should be taken into consideration when implementing customer requirements, so that you can avoid a variety of "beginner mistakes" from the outset, which would otherwise make life very difficult later.

"Participation in IBExpert workshops is firmly fixed in my schedule every 1-2 years."

Michael Clemens, Line Software GmbH

We still have some places available for the September and November dates! Book now to guarantee your place!

... further information



16 August 2016

White Paper: Firebird Replication

By Holger Klemt

A very interesting paper, which illustrates the flexible development of a Firebird replication: From the early beginnings of a database application to modern replication technology, concluding with key figures of a customer project.

A must-read for anyone using or contemplating replication!

You can download the White Paper here: PDF download.

Find out more about IBExpert Firebird replication at our Bootcamps: We also offer both Firebird Bootcamps as corporate training at your premises. If interested please mail sales@ibexpert.com and we will send you our written offer.

And you can now book the IBExpert Firebird 3 Bootcamp and the IBExpert Firebird Admin Bootcamp for your customers. Details here: Firebird Bootcamps as corporate training.



14th July 2016

Using IBEBlock to change all triggers

Have you ever tried to change all existing triggers, because they need to ignore the operation of a specific user?

This is extremely easy using the IBEBlock scripting language and Firebird 2.x as you can see in this example, which will simply add another line of code if (current_user<>'R$') then begin after the first begin and an additional end at the end of the source code. This is used in our replication system to ignore operations initiated by the replication user R$.

 execute ibeblock 
 as
 begin
 DB = ibec_CreateConnection(__ctInterBase,
                            'DBName="LOCALHOST/3050:C:\db\db.FDB";
                            ClientLib=C:\Program Files (x86)\HK-Software\IBExpert\IBEUDB\fbembed.dll;
                            User=SYSDBA; Password=masterke; Names=NONE; SqlDialect=3;');
 use db;
 for
   select rdb$triggers.rdb$trigger_name,rdb$triggers.rdb$trigger_source
   from rdb$triggers
   where rdb$triggers.rdb$trigger_name not containing '$'
   and rdb$triggers.rdb$relation_name not containing '$'
   and rdb$triggers.rdb$trigger_source not containing 'R$'
   into trgn,trgsrc
 do
 begin
   trgsrc=ibec_StringReplace(trgsrc,'begin','begin if current_user<>R$ then begin',__rfIgnoreCase);
   trgsrc=trgsrc||'
   end';
   update rdb$triggers set rdb$triggers.rdb$trigger_source =:trgsrc where rdb$triggers.rdb$trigger_name=:trgn;
 end
 commit;
 ibec_RecompileTrigger(db,'');
 end

You can find many more IBEBlock examples in our online documentation: IBEBlock examples.



6th July 2016

IBExpert Firebird Admin Bootcamp

From August 2016 onwards, IBExpert is offering an optional additional day to the Firebird 3 Bootcamps: The Firebird Admin Bootcamp (currently planned in German; if you're interested in an English-language course, please mail sales@ibexpert.com). This one-day Bootcamp can be booked together with the IBExpert Firebird 3 Bootcamp or separately as an individual day course.

You can find details on our website:

You can book your place in our onlineshop or by email to sales@ibexpert.com.

We also offer both Firebird bootcamps as corporate training at your premises. If interested please mail sales@ibexpert.com and we will send you our written offer.

Benefit from the knowledge of the IBExpert database experts.



29th June 2016

IBExpert Firebird 3 Bootcamp

 

From August 2016 onwards, IBExpert will once again be offering regular monthly workshops, currently planned in German (if you're interested in an English-language course, please mail sales@ibexpert.com).

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. ... read more here.

Optionally you can also participate on the additional third day: IBExpert Firebird Admin Bootcamp.

Benefit from the knowledge of the IBExpert database experts.



20th June 2016

Discontinuation of the IBExpert Desktop Edition

Development cycles are becoming ever shorter and continual innovations mean that it is hardly possible any longer to provide a software product without a subscription service.

This is nothing new or even surprising. It just means that in the foreseeable future nothing will remain as it is today and which we use and accept as a matter of fact. To keep up with progress, it is essential not to ignore new developments. Which also means that no one should work a long time without updates.

Consequently, we have decided to discontinue the development and sale of the IBExpert Desktop Edition with immediate effect.


7th June 2016

New IBExpert Tutorial:

IBExpert Database Designer

There are many situations where it can be useful to create Firebird database diagrams to provide a better understanding of an existing database, or to aid the planning of new Firebird databases. The IBExpert Database Designer is a comprehensive tool, which allows database objects to be managed visually. View in our Learning Center or on our YouTube channel.

Read the full documentation on our website: Database Designer.

The German-language version is to be released shortly!



19 April 2016

Firebird 3.0 has been released!


22 March 2016

White Paper: Big Data, Replication or "Where are the limits of Firebird?"

By Holger Klemt

A very interesting paper about a customer project, where we developed multimaster replication for EPOS systems. This demonstrates just how efficient Firebird is, when using the right hardware and replication configuration.

A must-read for anyone using or contemplating replication!

You can download the White Paper here: PDF download.



18 March 2016

Firebird Developer Days 2016

English language: 23rd-25th May 2016 in Frankfurt/Main, Germany

The Firebird Developer Days is the training event for Delphi and Lazarus developers who want to benefit from the knowledge of the IBExpert database experts. 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. You can view the range of planned topics here: English | German, and fees here.

Optional: Power Workshop Replication 26th May 2016

For participants from further afield Holger Klemt is offering an individual Power Workshop on the Thursday. Building upon a basic knowledge of replication, we will provide you with indepth knowledge on the subject of IBExpert and Firebird replication. Further information here.



17 March 2016

Firebird 4.0 roadmap and checklist

The Firebird Foundation have just published their roadmap and checklist for Firebird 4.0: http://www.firebirdsql.org/en/planning-board/. The first Alpha release is planned for later this year.



07 March 2016

The official Firebird 3 RC2 is now available for testing!

Firebird Project announces the second Release Candidate of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.

This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in “almost-production” environments. Please report about any found bugs to the bugtracker.

Please read the Release Notes carefully before installing and testing this Release Candidate.



09 February 2016

IBExpert file system inventory tips and tricks

Have you ever tried to find how many large duplicate files are taking up space on your storage system?

We had the same idea and used some very easy IBExpert scripts to read all network files into a database. With about 8 million files on several NAS systems, the tools available in Microsoft Windows are not really helpful. Here you can find our solution, including sample code, using IBExpert's IBEBlock scripting language and a Firebird database for storing the inventory.

View the full example in our IBBlock online documentation: IBExpert file system inventory tips and tricks.



10 November 2015

The official Firebird 3 RC1 is now available for testing!

Firebird Project announces the first Release Candidate of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.

This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in "almost-production" environments. Please report about any found bugs to the bugtracker.

Please read the Release Notes carefully before installing and testing this Release Candidate.



03 November 2015

Firebird Developer Days 2015

9th-11th November 2015 in Hamburg (German language)

The Firebird Developer Days is the training event for Delphi and Lazarus developers who want to benefit from the knowledge of the IBExpert database experts. 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.

You can view the range of planned topics here: English | German.

If you are interested in the 3-day English-language Firebird Developer Days, please mail us at sales@ibexpert.com.



15 October 2015

Did you know?

... that every Firebird database up to version 2.5 has a built in "End of Life"?

But don't worry, this isn't a problem at all, because with every backup and restore, the "End of Life" is reset.

Here is a simple SQL statement to check the expected date on your current database, based on the creation date and the number of currently used transactions.

 SELECT current_date+(current_timestamp-mon$creation_date)
 *4294967295/mon$next_transaction livetime
 FROM mon$database

The data is simply calculated based on the fact that any Firebird database will need a backup/restore, when the maximum number of transactions 232-1 = 4294967295 is reached. If your database uses 1 transaction per second, this value will be reached after 130 years. When you do a backup and restore, the counter is reset, so …
no need to worry!



21 September 2015

Dear customers,

Please note that as of 01 October 2015 we will have to increase the prices for all IBExpert software subscriptions by 20%. These price adjustments are necessary due to the extensive enhancements that are required for Firebird 3.0. You can purchase the necessary subscriptions for your IBExpert software at the previous price up to and including 30 September 2015. Please take advantage of this opportunity, even if your IBExpert software subscription is still valid. The extension of the subscription period will then be added to the current validity of your account in the IBExpert Download Center.

You can find our new price list from 01 October 2015 as usual on our website under IBExpert products, services & prices.



16 September 2015

This month's special offer!

We know the virtual infrastructure of larger companies very well, an realise it is often not possible, to determine the number of users working with IBExpert. For this reason, we now offer the IBExpert Company Year Edition XL including 1000 IBExpert software activations:

Pay the 12 month fee and you get the right to use the software for a full 24 months!

Smaller companies pay our low introductory price for the IBExpert Company Year Edition S including 20 IBExpert Software activations.

Select the right solution for your company; four software models are available:

Our offer applies to all four IBExpert Company Year Edition software models:

Pay the 12 month fee and you get the right to use the software for a full 24 months!

Order today by email to sales@ibexpert.com, Re: Special offer 09/2015; this offer is only valid until 30th September 2015!

You can find a detailed product description here.



10 August 2015

Visit us at the German Delphi Days!!

23rd-26th September 2015 in Fürth, Germany

The German Delphi Days are the major annual meeting of the German Delphi community. This year the event is taking place for the eleventh consecutive year and still attracts an ever-growing circle of participants.

The workshops are being held from the 23rd to the 25th September organized by the Developer Experts. The main event follows on Saturday, 26th September. The Delphi Days have been extended this year for the first time to a total of four days.

IBExpert KG is one of the principal sponsors

Come and visit our booth at the Delphi Days and let us give us you an insight into our tools and techniques and take advantage of our special offers. ... Details



16 March 2015

Firebird performance by numbers ...

by Holger Klemt

Read our newly published white paper: Firebird performance by numbers by Holger Klemt.



03 March 2015

Lazarus training for Delphi programmers

27th-30th April 2015 in Wardenburg, North Germany

This 4-day workshop for experienced developers offers participants a comprehensive insight, how to become successful using Lazarus as a replacement or supplement for Delphi.

Course contents and details



29th January 2015

Our second Firebird 3.0 IBExpert tutorial

Firebird 3.0: Introduction to packages

Firebird 3.0 packages are a new database object type, which allows the logical grouping of stored procedures and functions, similar to Oracle. Firebird 3.0 packages offer you possibilities to make your business logic more modular, offer security features, and facilitate permission management and dependency tracking. View in our Learning Center or on our YouTube channel.


19th January 2015

New IBExpert tutorial

Firebird 3.0: Introduction to stored functions

This brief introduction to Firebird 3.0 stored functions explains what they are and why you should use them. It also includes a simple example to demonstrate how they work. View in our Learning Center or on our YouTube channel.



news archive