Firebird on Linux and ICU > 4.2

Hi,

there was a bug in Firebird that did not handle well icu > 4.2 see (http://tracker.firebirdsql.org/browse/CORE-3447)

2.1.4 and 2.5.0 packages in distributions were affected (Debian, Fedora, Mandriva, Mageia) because they are using icu 4.4

Adriano fixed it and in these various distro updates are on the way

I know that some of you are using Centos 5.
The problem with Centos 5, is that you can’t have Firebird 2.5 from EPEL
repository. Centos 6 will give you the possibility to have Firebird 2.5 from EPEL6 repository, but seems that Centos6 take a long time to come.
https://www.centos.org/modules/newbb/viewtopic.php?topic_id=25878
http://wiki.centos.org/QaWiki/6/AuditStatus

You can try to use Scientific Linux instead (http://www.scientificlinux.org)
As Centos, the base SL distribution is basically Enterprise Linux
(RHEL), recompiled from source, and Scientific Linux 6.0 was released on
March 3, 2011

Philippe Makowski
http://www.ibphoenix.com

Send your testimonial!

Hello All,

There is “Testimonials” section at the test version of new FirebirdSQL site http://www.firebirdtest.com/en/testimonials/

Please devote 5 minutes of your time and write testimonial  – i.e., your
impression about Firebird. Nothing special, just several words about Firebird experience or, even  simpler – short description and link to the enterprise which uses Firebird.

Testimonials are important to demonstrate number of Firebird users and their satisfaction.

After new web-site launch all valid testimonials from the test site will
be moved to production version.

Regards,
Alexey Kovyazin

Firebird 2.1.4 is out!

The Firebird Project team is pleased to announce the latest minor release in the Firebird 2.1 series, v.2.1.4, addressing bugs that have arisen since the v.2.1.3 release in 2009.

Kits are ready to download for Linux, Windows and MacOSX on both 32-bit and 64-bit Intel platforms. For MacOSX, LIPO (fat client) packages are included and PowerPC kits will follow soon.

Thanks to those who participated in testing snapshots and the release candidate during the months past. Enjoy!

Helen, on behalf of the Firebird team

MySQL -> Firebird converter

From Milan Babuskov blog:

I decided to automate conversion of MySQL database to Firebird. I got tired of manual find&replace process, and created a small parser that changes from MySQL to Firebird syntax. Currently it only supports database structure dump (no data, only structure) from PHPMyAdmin. Not all datatypes are supported, but feel free to “fix” it. It’s written in PHP and it’s open source. It would be great if you would send back any modifications you make. Download it here (source code included).

Firebird slow? Well, maybe it is Windows fault.

So, you just moved to that new cool server, with lots of RAM, Windows and Firebird 64bits, but suddenly you found that Firebird performance gets worse and worse. When you check TaskMan, you see that 99% of the RAM is being used (and so, swap is going on). If you close Firebird process, RAM usage seems to be back to normal. Weird, uh?

First, you may think this is the common problem of Classic/SuperClassic with too many connections and crazy buffers value… but, you checked all the settings, and everything is ok.

If  this happening to you, take a look again in TaskMan (or Process Explorer), and check how much memory the OS Cache is consuming. If you find something abnormal, like if it is consuming almost all of your physical RAM, you should take a look at this: http://support.microsoft.com/kb/976618/en-us

Average of Firebird users DB sizes

In a recent survey for the next Firebird Developers Day in Brazil, one of the questions was about the average size of the participants (and/or their customers) databases. A total of 344 people answered, and the result can be seen below:

In general, your (or your customer’s) database has…

---------------
Percent Count Answers
---------------
20.3% 70/344 up to 500MB
31.1% 107/344 up to 2GB
20.9% 72/344 up to 5GB
17.2% 59/344 up to 10GB
10.5% 36/344 more than 10GB
---------------
100.0% 344/344 Summary
---------------

PS: Note that this survey was directed only to people who intends to participate in the next Brazilian FDD edition.

1 27 28 29 30 31 101