1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

FB TraceManager 1.6.0 has been released

We are proud to announce FB TraceManager 1.6.0.

The press release is available here:
http://www.upscene.com/displaynews.php?item=20110722

FB TraceManager currently is the only specialized tool available on the
market, which exposes the new Trace and Audit Services in Firebird 2.5
in a very user-friendly way. The following editions are available:

– Lite Edition (FREELY available)
– Standard Edition
– Enterprise Edition

More information is available in the FB TraceManager section on
our website, including an edition comparison sheet, webcasts etc.:
http://www.upscene.com/go/?go=fbtm

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Firebird: how to find SQL queries which use bad index?

In the first part of our optimization story (“How to ruin Firebird performance…“) we mentioned that indices should be analyzed before dropping, even if they appeared to be very bad in IBAnalyst in terms of garbage and number of unique values.
In essence, we need to log all queries used in applications, get their execution plans and check, how indices are used.
For this we need to log all SQL traffic between applications and Firebird database.
Keep reading in IBSurgeon blog.
1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 3.50 out of 5)
Loading...

AnySQL Maestro 11.7 released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro 11.7, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (MS Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc).

    AnySQL Maestro comes in both Freeware and Professional editions (more information).

      New version introduces data pagination, code snippets in SQL Editor, data import from ODBC data sources, and other new features (full press release).

        AnySQL Maestro 11.7 has been successfully tested with Firebird ODBC driver and all the latest Firebird database server versions up to 2.5.

        1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
        Loading...

        1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)
        Loading...

        1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
        Loading...

        Centos 5.X – Build Firebird / Interbase (extension and PDO extension) support into PHP

        Sent by Luis Rodrigues <luisrodrigues.pt@gmail.com>

        1º  # Install Firebird
        # for this tutorial I use FirebirdSS-2.5.0.26074-0.amd64.rpm (downloaded by Firebird website)
        rpm -ivh FirebirdSS-2.5.0.26074-0.amd64.rpm

        2º Obtain php source code

        a)
        # create the /etc/yum.repos.d/CentOS-SRPMS.repo with the following content

        [base-SRPMS]
        name=CentOS-$releasever – Base SRPMS
        baseurl=http://mirror.centos.org/centos/$releasever/os/SRPMS/
        gpgcheck=1
        gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-5
        priority=1
        enabled=1

        #released updates
        [update-SRPMS]
        name=CentOS-$releasever – Updates SRPMS
        baseurl=http://mirror.centos.org/centos/$releasever/updates/SRPMS/
        gpgcheck=1
        gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-5
        priority=1
        enabled=1

        b)
        yum install yum-utils
        yumdownloader –source php

        3º # Install php-devel for phpize
        yum install php-devel

        ######################################################
        #   if you want to build interbase.so extension only
        ######################################################

        4º # change to the folder where the extension code is and run the following command set.
        cd /usr/src/redhat/BUILD/php-5.1.6/ext/interbase
        phpize
        ./configure –with-interbase=shared,/opt/firebird
        make

        5º # the extension interbase.so if builded sucessfully is located  at:
        /usr/src/redhat/BUILD/php-5.1.6/ext/interbase/modules

        6º i’m using 64bits system so i need to copy the extension
        cp interbase.so /usr/lib64/php/modules

        7º last we need to activate extension into PHP
        vi /etc/php.ini

        #add the following line do extensions section

        extension=interbase.so

        #######################################################
        #  if you want to build Firebird Driver
        #######################################################
        4º # change to the folder where the extension code is and run the following command set.
        cd /usr/src/redhat/BUILD/php-5.1.6/ext/pdo_firebird
        phpize
        ./configure –with-pdo-firebird=/opt/firebird/
        make

        5º # the extension interbase.so if builded sucessfully is located  at:
        /usr/src/redhat/BUILD/php-5.1.6/ext/pdo_firebird/modules

        6º i’m using 64bits system so i need to copy the extension
        cp pdo_firebird.so /usr/lib64/php/modules

        7º last we need to activate extension into PHP

        #to work PDO driver need PDO (if you don’t have it, install it using yum)
        yum install php-pdo

        vi /etc/php.ini

        #add the following line do extensions section

        extension= pdo.so
        extension= pdo_firebird.so

        8º restart apache
        service httpd restart

         

        1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
        Loading...

        1 200 201 202 203 204 485