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.
07 January 2016
New IBExpert Version 2015.12.21 available
For those of you who may have not yet noticed...
we sneaked out a new IBExpert version just before Christmas last year!
New features include:
- Procedure, Function, Trigger Editors, Extract Metadata, Script Executive: Support of external procedures/functions/triggers (Firebird 3) implemented.
- Database Comparer: Fixed all known bugs introduced in 2015.09.28.
- Create View from Table and Create Procedure from Table: new options added.
- Script Executive:
INSERTEX: support of
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.
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 license still valid for an IBExpert subscription? Check our license conditions here.
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.
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.
If you are interested in the 3-day English-language Firebird Developer Days, please mail us at firstname.lastname@example.org.
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!
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.
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 License 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 License 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 License 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 email@example.com, Re: Special offer 09/2015; this offer is only valid until 30th September 2015!
You can find a detailed product description here.
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.
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
Firebird performance by numbers ...
by Holger Klemt
Read our newly published white paper: Firebird performance by numbers by Holger Klemt.
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.
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.
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.
We guarantee 100% optimal Firebird performance!
German Firebird and IBExpert Roadshow
IFS Server and Performance
Further information regarding our German-language Roadshow can be found on the IBExpert German website.
New! IBExpert Company Year license
We would like to present our new licensing model: the solution for virtual machines and cloud infrastructure.
Use the IBExpert IDE and IBExpert Server Tools on multiple computers and virtual machines without any hardware-related activation key. Order our IBExpert Company Year license! You can choose between 4 license models. Find out more ...
Trust the database experts for Firebird: IBExpert!
Firebird 3.0 Beta 1 release is available for testing
The Firebird Project has announced the first official Beta release of Firebird 3.0 today, the next major version of the Firebird relational database.
This Beta release demonstrates the features and improvements currently under development by the Firebird development team. Download here
Please read the Release Notes carefully before installing and testing this Beta release.
Please note: Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.
Why typical Delphi projects often fail ...
A subjective observation by Holger Klemt
Read our newly published white paper: Why typical Delphi projects often fail by Holger Klemt.
How to retrieve a corrupt Firebird/InterBase® database
Have you ever had the problem that you suddenly cannot open your Firebird/InterBase® database? Firebird won't allow you to back it up, and even gfix cannot solve the problem. Firebird indicates the nature of the problem (e.g. checksum error) and on which database page the problem has occurred, but you can't get at it to take a closer look.
Use IBExpert Database Inside to extract and analyze your database metadata and data, without using the Firebird/InterBase® server or any of their tools at all! See just how easy it is, by viewing our online tutorial: Retrieve corrupt databases using IBExpert's Database Inside.
Special offer IBExpert Day Licenses!
We have extended our special offer until 1st July 2014: 100 IBExpert Day Licenses for just EUR 55.00 (normally EUR 99.00) when paying using PayPal. You can order directly in our online shop: enter the Promo Code 55555, and this special offer article will automatically added to your shopping cart. Once the PayPal payment has been received we will mail you the invoice and activate the 100 IBExpert Day Licenses to your IBExpert Download Center account.
New! IBExpert Day License
The cost-effective way to provide support to your customers!
Use the IBExpert IDE whenever and wherever you need it. The ideal cost-effective solution if you offer remote support to your customers, need to repair a database or just want to take a quick look at a Firebird/InterBase® database when you're out and about! ...more
IBExpert has been busy!
Take a look at the current extent of our Firebird 3.0 support: Firebird 3.0 features already implemented in IBExpert.
And here you can view all new features introduced in our regular updates: What's New?
- Has your license expired? Purchase your software assurance by mailing your order to firstname.lastname@example.org.
- Is your license still valid for a software assurance product? Check our license conditions here?.