Author: Cantu

I'm the owner of the Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guides to Firebird 3, 4 and 5. Loving Firebird even before it was born!

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

Leave a comment

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

 

Firebird Randdom Data Generator

Leave a comment

Firebird Randdom Data Generator For Linux and Windows designed with brand new concept is released for download/test.

  • UPDATE OR INSERT INTO for Firebird 2.1+
  • preview of the random test data
  • use standard SQL script to generate random data
  • create/save standard SQL script when generating/inserting random data
  • save/load the SQL script/ embed user defined constants in the SQL script
  • user defined starting number for the auto-incremental filed (min. 0),
  • and can continue from the end number for next round of inserting.
  • save/load the user defined random test data variable definition file.
  • execute any standard SQL DDL script./enable/disable triggers.
  • a data grid to review the populated data of the database.
  • connect to Max. 4 database simultaneously
  • populate multiple tables simultaneously in all connected databases (Max.4),
  • keeping the Primary Key and Foreign Key relations within database,
  • and across all the connected databases.
  • insert user defined files as random test data to blob field, across all
  • connected databases./embed fixed string into CHAR/VAR/BLOB data-type so that
  • user may test ‘searching’ function in database.
  • and much more..

Detailed tech-info
http://sites.google.com/site/firebirdarchitect/Home/guifa/randatagen

DownloadPage:
http://sites.google.com/site/firebirdarchitect/Home/freedownload

You are welcome to download and test

yours
Rock Stone

ADO.NET provider for Firebird – version 2.6.5

Leave a comment

I’m proud to announce new version of ADO.NET provider for Firebird – 2.6.5. It’s half maintenance release, half new features.

You can find all bug fixes in tracker.

The new features include and improvements:

  • Support for Trace API in Firebird 2.5
  • Improvements in SQL generation for Entity Framework.
  • Support for commands logging
  • Slightly faster command execution of big queries.
  • And a lot of small code improvement making it more stable…

You can download it at http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.5/ or http://www.firebirdsql.org/index.php?op=files&id=netprovider.

—
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

New Firebird site is almost ready

Leave a comment

From Alexey Kovyazin:

Hello All,

Current data transfer from old site to the new site is almost complete. There are following areas in process:

  • In Development – QA, Documentations for developers and .NET/Python drivers
  • Old news – we will transfer old news for a while, now at 2009-2008 level.
  • In About Firebird -> Features description, is in progress
  • Grantee reports from old years
  • Some minor content adjustments

Also we need to manage setup for daily snapshot uploads.

For regular site updates, like adding news or new FF members/sponsors, dedicated person from DQTeam will manage data adding/changing, until other site contributors will learn how to use CMS.

Actual transfer and redevelopment is almost over, now web-site redevelopment is about “intellectual” re-writing and new content creatiion.

Such process will be run constantly, and there will be always gap between ideal site and good-enough site.

I ask everyone to join the action now, look through the site thoroughly, and then provide actual help in order to jump over gap and switch to the new site in the next few days, and then go to the Phase 2 – improvements and extensions.
Old site will be live for a while, of course, so no content will be missed.

Regards,
Alexey Kovyazin

1 … 26 27 28 29 30 … 101