Philippe Makowski, Firebird related

To content | To menu | To search

Firebird other

Entries feed

Tuesday 7 June 2011

Mageia 1 a Firebird friendly new distribution

Mageia 1 is there : http://blog.mageia.org/en/

It is a community driven project and a Firebird friendly distribution with Firebird 2.5.0, PHP, PHP-pdo, Perl, Ruby drivers, Rails adapter, Flamerobin, and Python drivers (kinterbasdb and firebirdsql).

I'm really happy to have now Mageia on my computer, and being one of the packagers.

For people wanting to use Firebird under Gnu/Linux, Mageia can be a really good choice.

The community is active, and in next months will decide what will be the future. Like Firebird, Mageia organisation is community-driven; no commercial management can dictate the path Mageia will take.

Download it, try it !



PS

Some friends of mine created  Hupstream  a company providing commercial services (like IBphoenix for Firebird) with or around Mageia software, tools or project .

So you can imagine Firebird under Mageia with professional support with IBPhoenix and Hupstream if you want !

Friday 29 April 2011

Windows Firebird Classic and cache

From the Firebird support list, posted by Sean Leyne :

We have over 60 production Firebird servers running Windows, some servers with 100s of database connections.

What you need to remember is:

- Each database connection starts a new server process, so more RAM memory is needed/used

- Each database page cache setting should be kept low, improve performance by reduce the amount of synchronization which occurs between the Firebird processes

- 64 bit versions of Windows (very true with 2008) have a poor algorithm for managing OS page cache, which can result in an excessive amount of cache paging, which severely impacts performance. There are some utilities available (SET_CACHE.EXE) which can set the cache size to definable level (we usually set it to 70% of available RAM).

Tuesday 26 April 2011

Firebird on Linux and ICU > 4.2

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

Wednesday 22 December 2010

News from the packaging front

I just finished the Firebird 2.5 packages for Mandriva

They are available in Cooker and in Contrib/backports for 2010.1 and 2010.2

Doing this work, I saw that I made a mistake in Fedora packages, so they are updated in Rawhide and EPEL6

I also updated my Fedora 14 repo (http://repos.fedorapeople.org/repos/makowski/firebird/)

good having doing that before the end of the year !

Tuesday 27 April 2010

Thanks for DOR !

 Henri Gourverst (UIB creator) set up a new powerful tool : DelphiOnRails

The powerfull association of DOR and Firebird help me to build a nice new AppServer. 

The simplicity of coding with DOR help me to focus on database structure and efficient queries. 

This AppServeur will be soon deployed in various location in France, and with the low level of maintenance need, the light network protocol used it will be deployed on large and small business units without trouble. 

The clients software will not use Lua (choice of the vendor), instead there are two clients one in C# and another in PHP integrated to a web server. 

So thanks again Henri, long live to DOR. 

- page 1 of 4