Back in from the cold - to firebird

I've been looking at several tools for this venture. Delphi is a requirement as I can deliver a great application to the intended audience using Delphi. I've looked very seriously at both Firebird and ElevateDB as the intended database that I will be using. I still have not made up my mind on these yet as both have their strong points.

If I end up going with Firebird, then I'll most likely be using the IBObjects components. I've used these before at a customer's site and have been impressed at the genuine speed that results.

http://stevepeacocke.blogspot.com/2008/06/back-in-from-cold.html

.:(firebird):..:(databases):..:(sql):.

building minimal php with only firebird/interbase extension

if you want to build minimal an php+firebird extension only setup
here is how to do it without xml/mysql/sqlite and all that stuff that
you might not need it

tar -jxvf php-5.2.6.tar.bz2
cd php-5.2.6/

./configure --disable-all --with-interbase --prefix=/tmp/foo
--with-apxs2=/usr/bin/apxs
make
make install


/tmp/foo/bin/

./php -m
[PHP Modules]
date
interbase
Reflection
standard

[Zend Modules]


and you can test the minimal php and eats less memory in apache/lighttpd/nginix

-- ls -lah php
-rwxr-xr-x 1 root root 6.5M 2008-06-19 17:35 php





.:(firebird):..:(databases):..:(sql):.

Firebird 2.0.4 is now in ubuntu

Here are the details for package

.:(firebird):..:(databases):..:(sql):.

Firebird builds on both ARM and ARMEL

from this table you can see that firebird builds on both ARM and ARMEL ( ARMEL is just ARM with some hardware extras.)
http://buildd.debian.org/build.cgi?pkg=firebird2.0
and here is the buildlog

http://buildd.debian.org/fetch.cgi?pkg=firebird2.0;ver=2.0.4.13130-1.ds1-2;arch=armel;stamp=1212179688

if you use debian then you can download from here

http://packages.debian.org/sid/armel/firebird2.0-super/download

According to http://eetimes.eu/showArticle.jhtml?articleID=199702110

from linux tiny

Arm shipped the processors in 250 million "smart phones" in 2006 (83%
market share in that niche).

According to ARM Inc. quarterly results for Q1 2007:
http://media.corporate-ir.net/media_files/irol/19/197211/press/Q12007EarningsRelease.pdf

In the first quarter of 2007, the licensees of ARM Inc. shipped 724 million
ARM processors. In one quarter. (ARM Inc. collected $45 million in license
fees, which is an average of 6.2 cents/processor.)

In a May 23 2006 presentation to ARM investors, ARM Inc. estimated its 2006
market share at 80-90% of the cell phone market, but only 21% of the larger
market. (The embedded world is big, folks.)

Drew highlighted five key growth areas for ARM between now and 2010...

[The first four are] set-top-box, high-definition television and DVD systems,
solid-state and hard disk drive storage, automotive electronics and 32-bit
microcontrollers. In these areas in 2006, ARM had market shares of 14, 20,
5 and 13 percent respectively... They are also market sectors that will
represent a total available annual market of nearly a billion cores or more
each in 2010. The biggest annual market opportunities are likely to be
automotive and 32-bit microcontrollers at 2.0 billion and 1.9 billion cores
each.

ARM's fifth key target market is the smart phone, where it is already
enjoying success. In this area the company shipped 250 million units in 2006
and has a market share of 83 percent, according to its own estimates.


.:(firebird):..:(databases):..:(sql):.

debian build log firebird2.0/hurd-i386 failing reason

[Category: none]
> ../src/jrd/gds.cpp:176: error: 'MAXPATHLEN' was not declared in this scope

http://buildd.debian-ports.org/status/package.php?p=firebird2.0#fail-firebird2.0-hurd-i386

.:(firebird):..:(databases):..:(sql):.

changelog for ubuntu

https://edge.launchpad.net/ubuntu/+source/firebird2.1
https://edge.launchpad.net/ubuntu/+source/firebird2.0

.:(firebird):..:(databases):..:(sql):.

firebird2.0 (2.0.4.13130-1.ds1-1) experimental; urgency=low

* New upstream bugfix release
+ adapt debian/get-orig-source.sh; remove more generated files
* refresh patches, drop patches present upstream:
cvs-security-remote-crash.patch
cvs_security-long-username_CVE-2008-0467_#463596.patch
* cvs-port-ia64.patch: drop -fno-rtti as RTTI is needed in 2.0. Hopefully
Closes: #460219 for real
* move booting ot autotools from patch to rules; cleanup rules; invoke
debconf-updatepo in clean target
* rules, make_packages.sh
+ determine version from src/jrd/build_no.h
+ unify with 2.1's version
* patches
+ add local-CFLAGS.patch from 2.1
+ merge create-run-dir into lock-file-location
+ terminate-lock-manager (as we supply CXXFLAGS from rules)
* add deprecated-charp-conversion.patch
+ add -Werror=write-string to exterminate that warning
* stop provifing libfbclient2 package, firebird2.1 (in experimental)
provides it. Instead, build-depend on it

.:(firebird):..:(databases):..:(sql):.

firebird2.1 Debian package for itanium

The firebird2.1 Debian package has been successfuly built[1] on IA64

[1] http://experimental.debian.net/fetch.php?&pkg=firebird2.1&ver=2.1.0.17798-0.ds1-4&arch=ia64&stamp=1211549239&file=log&as=raw


.:(firebird):..:(databases):..:(sql):.

geting firebird locks

sudo /usr/lib/firebird/2.1/bin/fb_lock_print
[sudo] password for xxxx:
LOCK_HEADER BLOCK
Version: 244, Active owner: 0, Length: 1048576, Used: 25208
Semmask: 0x0, Flags: 0x0001
Enqs: 1530, Converts: 0, Rejects: 342, Blocks: 42
Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
Acquires: 0, Acquire blocks: 60060822667264, Spin count: 0
Mutex wait: inf%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 0
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners: *empty*
Free owners (9): forward: 20848, backward: 21040
Free locks (21): forward: 24384, backward: 21752
Free requests (20): forward: 23872, backward: 21560
Lock Ordering: Enabled

Event log:
DEL_OWNER: owner = 20848, lock = 20848, request = 0
DEL_OWNER: owner = 22200, lock = 22200, request = 0
DEL_OWNER: owner = 21368, lock = 21368, request = 0
DEL_OWNER: owner = 21040, lock = 21040, request = 0


The tool for checking the lock table is fb_lock_print, which is a command line utility in the bin directory of the Firebird installation tree. The full lock print describes the entire state of the lock table and is of limited interest. When your system is under load and behaving badly, invoke the utility with no options or switches, directing the output to a file

Read more on this page
http://ibdeveloper.com/issues/issue-2-oct-17-2005/locking-firebird-and-the-lock-table/

.:(firebird):..:(databases):..:(sql):.

firebird 2.1 for fedora 9 and fedora 8

here is for fedora 9
http://mirror.yandex.ru/fedora/tigro/9/i386/
here is for fedora 8
http://mirror.yandex.ru/fedora/tigro/8/i386/


.:(firebird):..:(databases):..:(sql):..:(fedora):..:(linux):.

firebird 2.0.4 is now in mandriva

http://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/devel/cooker/SRPMS/contrib/release/

.:(firebird):..:(databases):..:(sql):..:(mandriva):..:(linux):.

maintainer for suse offer

http://thread.gmane.org/gmane.linux.suse.opensuse.packaging/2237

Hi I'm Philippe Makowski
 I'm a member of Firebird Project and will be pleased to help you
 as I did for Mandriva

May I suggest you start from the Mandriva RPM

http://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/devel/cooker/SRPMS/contrib/release/
 firebird-2.0.4.13130.1-1mdv2009.0.src.rpm

In Mandriva you will find also rpm for Flamerobin,
 PHP driver, Python driver, Java driver

 just let me know what you need or to what or other things
 I have to subscribe

 I would be pleased to setup  an opensuse box to test your future work

.:(firebird):..:(databases):..:(sql):.

Old security bug fixed already in 2.0.4 and 2.1

Security vulnerability in Borland InterBase

A security vulnerability discovered early this year in open source database Firebird also affects Borland's InterBase. The security vulnerability allows ...


.:(firebird):..:(databases):..:(sql):.

Popularity contest statistics for firebird2.1

here are stats for debian firebird2.1 installs
http://qa.debian.org/popcon.php?package=firebird2.1

.:(firebird):..:(databases):..:(sql):.

firebird ports for intanium and hppa

if you watch the debian building logs for different architectures then there are a few ones left to be done , intanium , hppa and alpha (dead one)
http://buildd.debian.org/build.cgi?pkg=firebird2.0

and seem that this will be solved very soon




.:(firebird):..:(databases):..:(sql):.

remember to upgrade to firebird 2.0.4 or firebird2.1

Stack-based buffer overflow in Firebird before 2.0.4, and 2.1.x before 2.1.0 RC1, might allow remote attackers to execute arbitrary code via a long username.

http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-0467

.:(firebird):..:(databases):..:(sql):.

firebird2.0 2.0.3.12981.ds1-14 (source) in Ubuntu

latest package 2.0.3 from debian is now imported in ubuntu intrepid
https://bugs.edge.launchpad.net/ubuntu/+source/firebird2.0/2.0.3.12981.ds1-14

and here are the successful (power and sparc are new )

Builds

• intrepid sparc Successfully built (DONE)
• intrepid powerpc Successfully built (DONE)
• intrepid lpia Successfully built (DONE)
• intrepid i386 Successfully built (DONE)
• intrepid amd64 Successfully built (DONE)

.:(firebird):..:(databases):..:(sql):.

Firebird downloads for April

there is an high number of downloads for April , traffice is at ~600GB and downloads at 117,467
http://sourceforge.net/project/stats/detail.php?group_id=9028&ugn=firebird&mode=year&&type=prdownload

.:(firebird):..:(databases):..:(sql):.

The ministry's Money Laundering Prevention Directorate (MLPD) uses Firebird

The ministry's Money Laundering Prevention Directorate (MLPD) used Gnu Privacy Guard (GPG) between 2004 and 2007. This is Open Source software for encrypting and electronically signing data, allowing it to be transmitted securely even through public networks. The directorate also uses the Open Source relational database management system Firebird. "Both the banks and the MLPD accepted our solution without any objections, and it did not introduce any costs", comments Jovanovic.

http://ec.europa.eu/idabc/en/document/7370/469

.:(firebird):..:(databases):..:(sql):.

FB 2.1 Week of Year Feature

With new functions in FB 2.1 extracting week of year is supported (based on ISO-8601). So this past article is more simple to do with the new syntax :

extract(week from some_date_field)

.:(firebird):..:(databases):..:(sql):.