Firebird Weekly News #3

This is the firebird related news from week 7-14 June
News around firebird world:
Firebird django backend call for testing help and progress.
Firebird 2.1.2 included in SourceMage Linux.
Flamerobin 0.9.2 packages into Fedora Linux and epel repository
Fedora 11 released with Firebird included in the main repository

New IBProvider version with enhanced Firebird 2.5 support
About FB support in Delphi Weaver
How to Query the Firebird Fisheye
Firebird: Deal with Unavailable Database
Firebird DTP Plugin for Eclipse released

Firebird Source Patches and Commits:
Fix CORE-2370: SQL Plan greater than 2048 characters is not printed at all in ISQL.
This is the client side fix. Server-side fixes will follow.
We should be careful to not upset FB2.1 and before.
New messages to fix CORE-2505: beware of built-in functions returning NaN and Inf. Code will follow in one day.
Better input type for SQZ_decompress plus a bit of style
Apply Alex/Bill/Jerry/me patch re. portability in redefinition of operator new
Sign extension problem, thanks Bill Oliver.
Update logic for ininf() in POSIX and use macro isnan instead of _isnan in Windows.
Update to-do a tad.
Locking something in AST turns out to be a bad idea. Let's use a "dirty read" approach and honestly return the "unknown" state for a not initialized backup manager (quite rare situation in practice).
The third incarnation of the monitoring internals. I'm not happy to commit such big changes into the point release, but this is the only solution for the AST signal safety issues in POSIX (see CORE-2483).
The change consists of a few parts

Remove unneeded reference to isc_ipc, since this file is not needed to build gpre_boot
In 3.0 binreloc should be turned on

Opportunist developer sees the place to constify the code.
:-)
Undo huge and not friendly fix for Sun compiler. Missed file
Patch by DS and VKh to speed up SQZ in some cases
Avoid sign extension problems in CVT
Much more easy way to please Sun compiler and not touch anything more
isc_ipc usage cleanup

Though we do not actively use signals since 2.5, let's better initialize paths before setting handlers

Rename function as agreed with Alex and Dmitry.

Don't be strictive with compiler warnings

Reworked class Semaphore:

1. Mach semaphores on Darwin.
2. No more local SysV semaphores.
3. Fixed bugs in conditional var based semaphore.
4. Moved big methods from .h to .cpp file.

Mac port - use correct full name for libib_util

Fix CORE-2501: bin_shl and bin_shr shouldn't accept negative shifts.

Put bad_port_context() in alphabetical order and created a little helper, send_error().

Use PORT_FILE for port file lock - thanks to Claudio

Make initialization distributed - each subsystem does what it needs when needs, removed gds.cpp:init()

Backport improvement CORE-1171: make floating point's exponential format the same across platforms.

After asking Alex, he confirms that calling fb_shutdown_callback in isql is for everything except WIN_NT (make code equivalent to previous versions).

Improvement CORE-1171: make floating point's exponential format the same across platforms.

Declare exported functions correctly - thanks to Paul Beach

Robocop added Paranoid checks in server.cpp

Slightly improve the retry loops in inet.cpp. Let's give up as soon as the call fails with any unexpected error.

CORE-2263: RemoteAuxPort for SuperClassic and regular Classic.
This change also fixes the possible races in SuperServer (possible after getting rid of the global mutex in the remote subsystem).

robocop is Minimizing casts (reinterpret_cast).

Fixed use of monitoring tables in on disconnect trigger, make pool for DatabaseSnapshot independent

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

Firebird Weekly News #2

This is the firebird related news from week 1-7 June
News around firebird world:
phpBB “quite furry” 3.0.5 released
Under the Firebird umbrella - site updates
Lazarus and Firebird Embedded tutorial on Windows 32 bits
Embarcadero Tools and FB , news from Delphi Day Italy

Here is an interview with Jim Davis, SAS Institute SVP and Chief Marketing Officer.

Firebird Source Patches and Commits:
Improvement CORE-2498 - Make a single attachment usabe by more than one simultaneous threads in embedded

Fixed CORE-2499 - Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
Backported changes extending range of usable auto* tools

What is new and fixed in Version 2.1.x

Backport fix for bug CORE-2348 : More problems with transaction numbers overflowing 32-bit signed integer and corrupting database

Backport sub-task CORE-1647 : Close external table's file even if it used by some cached (inactive) requests.
It also fixed bug CORE-2475 : External table data not visible to other sessions in Classic.

Backport fix for bug CORE-2416 : AV preparing a query with aggregate over derived table

Minor cleanup by robocop

Dimitry Added timeouts to the network event listener code.
Fixed wrong usage of SO_REUSEADDR on Windows.

Alex Fixed Sun compiler warnings

Fixed CORE-2483: Database permanent pool may get corrupted when working with monitoring tables.

Better way to compile utilities/ntrace/os/*/platform.cpp for different platforms

Alex Fixed SYSV semaphores + const correctness + cleanup

Code simplification by robocop (claudio)

This is already a Windows file, no need to check for the WIN_NT macro.

Alex Fixed posix build

Firebird Weekly News #1

This is the firebird related news from 25-31 May Week

News around firebird world:
Firebird Romanian community had an small booth and tequila/beer meeting at eliberatica.ro event
I was in the middle of ubuntu.ro/fedoraproject.ro people also one suseromania.ro guy also I want to mention www.rosedu.org and softwareliber.ro.

Here are the picture with faces and names on it



Music/Book/Movie Label uses Firebird
Preparing for 6th FDD - Firebird Developers Day
Firebird Maestro 9.5 released

FirebirdConfig 0.2.0.34 released
Change Manager from Embarcadero will add Firebird support (at last)
Firebird Python PowerConsole 0.7 is released

Flamerobin will switch from subversion to git
Flamerobin Blob Editor on the way

Nice Requests and Bugs:
Ability to rename a table

Firebird Source Patches and Commits:
Make engine create lock files in /tmp/firebird

Lock files location should not be affected by value of TMP environment variable
Do not overload placement new operator. That is not valid accordingly to C++ standard.
Robocop fixed the VC9 project files.
Feature CORE-2470 - Support for alternate format of strings literals but on Firebird-Architect there was an long thread about it .
Added possibility to user inform external routines body , Made external routines entrypoint optional.
Fixed issue with two-phase procedure store and DDL triggers
HVlad Fixed MSVC8 build
Firebird Use COMMONAPPDATA folder on Windows for shared memory files placement (lock table, even table, etc).
Alex Peshkoff worked on Solaris port, related cleanup
Let's not crash while internally disconnecting a Classic process after a database shutdown.
Fix AV in trace when UNICODE collation is not found - thanks to Alex
Multi Threaded safe floating point exceptions control. Raise error in case of FP overflow according to SQL standard requirements.
Alex Peshkoff fixed warnings in AIX port.
Better error reporting. Also, don't block the requester in the case of error.
More fixes for bug CORE-2444 : make remapping of shared memory work correctly.
Fixed CORE-2482: Monitoring tables data collection is unstable when attaching or detaching database.

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

Firebird issues with ruby on centos - ruby: symbol lookup error

Here is the thread , it looks familar to me

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

firebird driver for ruby updated to 0.6

you can see the latest fixes for ruby 1.9 and version is now at 0.6 in the gem.spec

seems that you can install directly from github with gem (see the gem ruby icon in the right )

http://github.com/wishdev/fb/tree/master

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

databene benerator - added support for firebird

The new freshmeat website is now at version 3.0 and in the new clean interface you can read about this new

tool databene benerator

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

The true story of Blob on reddit

You can read the true story of blob on reddit also an good thing is to vote if you have an account

Jim Starkey showed me the movie that inspired his boss

in requesting the Blob inside the RDBMS

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

Redhat/Fedora port in progress for Firebird

Here is the bug with Firebird Port in progress for Fedora/Redhat

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

Installing Firebird on FreeBSD - FFAP (Firebird Apache Php)

By far the easiest way to install Firebird is via a package, or the ports tree.
When people in the FreeBSD community get a package running on FreeBSD, they often submit how they did it as a 'port', back to FreeBSD.
( This saves you working out what configure scripts to change, which make to use (make, gmake, bmake, aimk, etc) )

So we'll follow the road they've already blazed. Of course, feel free to download the source tarball, and get it building yourself, but it could take a while...


If you can't find a pre-compiled binary package on FreeBSD.org, firebirdsql.org, or ibphoenix.com, sync up your ports tree.
(Building it yourself ensure's it's built using optimisations for the processor you're running, too)


once ports tree is updated, do:


code:

---

cd /usr/ports/databases/firebird2-server
make install

---

Once this is finished, all dependencies are installed, the database is installed, the startup scripts are in place, the firebird user is added, and we're ready to go.

As the comment at the end of the install process suggests, we should change the password of the sysdba user, so lets do that now.

Starting Firebird
This involves running

code:

---

/usr/local/etc/rc.d/000.firebird.sh start
killall -HUP inetd

---

Or, simply reboot

Setting up Firebird's SYSDBA User

code:

---

cd /usr/local/firebird
./bin/gsec -user SYSDBA -pass masterkey
( the ./bin/ is required if you haven't got /usr/local/firebird/bin in your path )
GSEC> modify SYSDBA -pw

( We might add a user while we're here )
GSEC> add testuser -pw testuser

( Now quit out )
GSEC> quit

---

Done. Now we're ready for databases. the Firebird runs as the user firebird, thusly needs read/write permissions to a directory to store the databases.
I usually make one called '/usr/db':

code:

---

mkdir /usr/db
chown firebird /usr/db
chgrp firebird /usr/db
chown 770 /usr/db

---

There we have a nice, secure little home for our databases.
This directory isn't created by the install,as people will always want their databases stored in a different place, on a different HDD controller, etc.

Lets make a database

using your favourite editor, start a file in your home directory called 'fire1.sql', and in it, put the following:

code:

---

CREATE DATABASE "localhost:/usr/db/fire1.gdb".
COMMIT.

CREATE TABLE tbl_test1(
str_name VARCHAR(100) NOT NULL,
str_phone VARCHAR(20),
PRIMARY KEY(str_name)
).

---

Then save, and exit the file

Now, well create the database
( It may pay to put '/usr/local/firebird/bin' in your path, to save using the full path to the binaries every time )

code:

---

isql -u testuser -p testuser <>
Logging in for the very first time
Lets log in, and have a look. Run:

isql -u testuser -p testuser localhost:/usr/db/fire1.gdb

Database: localhost:/usr/db/fire1.gdb, User: testuser
SQL>

You're in! Lets see what's inside:
( Note. Put a semi-colon at the end of every command. It's the terminator at the moment )


SQL> show tables;
TBL_TEST1
SQL>

Let see how that table's made up:
SQL> show table tbl_test1;
STR_NAME VARCHAR(200) Not Null
STR_PHONE VARCHAR(20) Nullable
CONSTRAINT INTEG_2:
Primary key (STR_NAME)
SQL >

Lovely! put some data in
SQL> insert into tbl_test1 (str_name, str_phone)
CON> values ('henry','12345678');
SQL>

( Note the 'CON>' appears while a statement is continuing )

Let's select everything in the table
SQL> select * from tbl_test1;
STR_NAME STR_PHONE
===== ===
henry 12345678

Lets put some more in
SQL> insert into tbl_test1 (str_name, str_phone)
CON> values ('jane','87654321');
SQL>

Select all
SQL> select * from tbl_test1;
STR_NAME STR_PHONE
==== ========
henry 12345678
jane 87654321

Select henry
select * from tbl_test1 where str_name = 'henry';

select people starting with 'h'
select * from tbl_test where str_name like 'h%';

select the first record
select first 1 * from tbl_test1;

select 1 record, but skip 1
select first 1 skip 1 * from tbl_test1;

select any records with the letter 'e' in them
select * from tbl_test1 where str_name containing 'e';

As you can see, the SQL is very similar to other databases.

Next we will instal the apache to FAP (Firebird,Apache, Php)

portsnap fetch
portsnap extract
Installing apache 2.2
cd /usr/ports/www/apache22/
make install clean

Installing php extension
cd /usr/ports/lang/php5
make install clean
cd /usr/ports/lang/php5-extensions
make install clean
cd /usr/ports/database/php5-interbase
make install clean

We need now to enable the Php and firebird extension for it (interbase.so)

Firstly we will edit apache’s config - this lives in /usr/local/etc/apache22/

Open /usr/local/etc/apache22/httpd.conf in your favroute editior (or nano while your learning to love vi)

Look for this line : LoadModule rewrite_module libexec/apache22/mod_rewrite.so
directly underneath this line add the following 3


LoadModule php5_module libexec/apache22/libphp5.so
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

Then find this line : DirectoryIndex index.html and change it to DirectoryIndex index.php index.html

After this is done we need to give php an ini - the easiest way to do this is to copy the dist one into place

cp /usr/local/etc/php.ini-dist /usr/local/etc/php.ini

open /usr/local/etc/php/extensions.ini in your favroute editor and look for this line : extension=interbase.so if it isnt there, add it.

one last change and we are good to go!

open /etc/rc.conf in your text editor of choice and add these lines :


apache2_enable="YES"

once your done reboot and enjoy!



Recomdeded Reading :
1.The Complete FreeBSD Book
2.Free BSD Handbook
I was inspired for the Apache/Php install from this article

Bug of the day fixed :Penguin Semaphores exhausted

From bug of the day category we present you Linux Semaphores exhausted

http://pmakowski.ibphoenix.fr/post/2009/03/05/From-the-support-list

http://tech.groups.yahoo.com/group/firebird-support/message/100649

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

creating an db with isql-fb in firebird classic

If you try to create an db from isql-fb utility and you use firebird classic

then you might need to add the host in the connection string

$ isql-fb -user SYSDBA -password masterkey

Use CONNECT or CREATE DATABASE to specify a database

SQL> create database "/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

Statement failed, SQLCODE = -902

cannot attach to password database

SQL>

Here is the correct way to create the database with classic

$ isql-fb -user SYSDBA -password masterkey

SQL> create database "localhost:/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

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

Even Postgresql developers prefer Firebird over Mysql

Read an interesting interview where one developer when asked

If you should decide between Firebird and MySQL, though it would not be available to PostgreSQL, what with you in a generally won? And why?

I have three years of application development platform for Interbase / Firebird. So it is clear what I have preferences. Firebird is a very nice small compact database that I like and fandím it.

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

News of the Libgda front

New jdbc wrapper and updated firebird drivers 
see the article 


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

convert security.fdb to security2.fdb in firebird

converting sercurity.fdb to security2.fdb (needed during 1.5 to 2.0 migration)
.:(firebird):..:(databases):..:(sql):.

Firebird OdbcJdbc 2.0 driver changes

Interesting changes

• - added Linux x64 support
• - added Windows x64 support, thanks to Alexander Potapchenko.

and others
http://fisheye1.atlassian.com/browse/firebird/OdbcJdbc/changes-v20.log?r=1.1.2.4


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

why firebird is better than mssql

http://www.sinatica.com/blog/en/index.php/2008/09/know-your-server


Thanks to its multi-generational architecture Firebird does not block readers. So it’s natural that this problem may seem strange to us. But each architecture has its pros and cons. This same multi-generational architecture, if not correctly used, can be a problem. It’s the case of long running transactions or "stuck transactions".
Such transactions cause record versions to accumulate in the database. (These versions can also be called generations. It’s multi-generational architecture, remember?) The more versions accumulate more work Firebird has to do to find the correct version of each record. If stuck for long enough Firebird server can get slow to the point of looking like it’s dead. How much time depends of the database load and the server’s hardware. Could be a month, could be an hour.
I’ve seen it happen many times. In some of those occasions I saw managers argue for hours that MS SQL Server or Oracle don’t have such problem. The fact is that they have other architectural details that you must take into account in your application. For example, some databases block readers. Simply switching databases, as some of those managers suggested, is not a solution.

Although having StackOverflow powered by Firebird would not be a bad idea. ;)

OSCON gets under way - clarion is used with firebird

But this is an open source conference, and Clarion is a closed source product. What exactly is ClarionMag doing here?

In my experience there are are plenty of Clarion developers already using open source products and tools. For the most part that means databases such as MySQL, Firebird, PostgreSQL and Ingres, and web tools, of which there are a great many (Apache and PHP are popular choices).

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

On MySQL forks and MySQL’s non-Open Source documentation

One of the things that sets MySQL apart (in, IMHO, a very bad way) from other Open Source database projects/products such as PostgreSQL (license) and Firebird (license) is that the MySQL documentation is NOT Open Source. The MySQL documentation is and always has been copyright MySQL AB, and “… use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of MySQL AB”.

http://jcole.us/blog/archives/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-documentation/

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

Zeos is Now Ready for FB 2.1.1

Here is the full blog post

The first FB 2.1 version has a problem when attempt first connect to the database but the version 2.1.1 seem already fix that bug, as in the Zeos forum "Seawolf" analyze that "(CORE-1868) The server could crash in isc_dsql_free_statement(). fixed by A. Peshkof" is the problem that make Zeos crash at first connection to the DB. Here is the link to the discussion about this problem in Zeos forum. So if you want to use the Firebird 2.1 version with Zeos then move to Firebird version 2.1.1

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

Firebird - Technical Question

Just starting to migrate our application from an Access backend to Firebird. We have created a firebird database and can connect to it through our app however our SQL statements require objects to be quoted, i.e.

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

Firebird Embedded use on linux

Here is the guide for firebird 1.5.x on linux , I will try to use the guide on ubuntu and
later with firebird 2.x

also i will try to use it with both c++ and mono
http://tirania.org/blog/archive/2005/Sep-30-2.html
http://www.firebirdfaq.org/Firebird-Embedded-Linux-HOWTO.html#Final_directory_structure

To use Firebird on Linux without needing to add users or set permissions, you can use the Classic server and get it down to just a few files. I used FirebirdCS-1.5.x on SuSE 9.2 but it should work for any Linux distribution and any recent Firebird release. What you need is:

1. A directory to setup a mini Firebird environment. I used ~/firebird and you need these files in the directory:

libfbembed.so
firebird.conf
security.fdb
intl/fbintl
bin/fb_lock_mgr

2. You need to link with or dynamically load the libfbembed.so library. It will allow direct connection to the database without needing a server process.

3. The firebird.conf file just needs one line with "RootDirectory=?" where ? is the full path of the mini Firebird environment directory.

4. The security.fdb file will be used to validate the username and password when you connect so you can either setup users in it or just set the sysdba password to a known value and login using sysdba. This security file is really a dummy file and will not provide any real security but its an embedded database so you are not looking for the same type of security a networked server would need.

5. The files all need to be owned by the user who will be opening the database so in my case they were all owned by me. Special care needs to be taken with the fb_lock_mgr since the one in /opt/firebird/bin is setup owned by firebird.firebird and with the setuid bit turned on but you will not need any of this for this configuration. In general if you're application is running as user "foo" then that user needs to have read/write access to the database you are trying to open, to the security.fdb file, and to the directory you installed the Firebird mini environment.

In your code you need to set the environment variable FIREBIRD to the location of the mini Firebird environment and then you should be able to use isc_attach_database and just pass a full pathname to the database file you want to use.

Here is the original article , but the site seems to be missing
http://web.archive.org/web/20070611151645/http://fbtalk.net/viewtopic.php?id=194
.:(firebird):..:(databases):..:(sql):.

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):.

wordpress for firebird

i wonder if i can apply pdo patches to the wordpress 2.5
and maybe after that make it work with firebird later
(pdo is suported by other databases too)

ps:why wordpress team ignores the rest of the world ?

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

firebird + genotoo blog post

One blog post with charset issues on gentoo in Russian language




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

LINQ To Dataset DBNull problem

I've got a connection to a Firebird Database.
I've linked DataSources in the IDE. I've got all my 8 tables from which I can retrieve data.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3222905&SiteID=1

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

someone is using firebird on ubuntu

here is his blog where machines are described

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

phpBB 3.0.1 released

phpBB 3.0.1 has just been released, this means some small bug fixes, which were of course necessary in order to ensure the continuous stable release rate of phpBB. The official release topic is posted below.

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

OpenDBX 1.3.7 released

Release focus: Major bugfixes

Changes:
Many improvements and bugfixes are included in this release and it's recommended to all developers to upgrade to the latest version. The existing odbx_result_free() is deprecated in favor of the new odbx_result_finish(). Additionally, the C++ Stmt::bind() method of the API was removed and the Stmt::escape() method was moved to the connection object. It's now also possible to write data into large objects using the Firebird and Oracle backends, but the Oracle LOB implementation doesn't work at the moment.

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

We went with Firebird 2.0 because

Quote from firebird-general

Yes. We were evaluating various embedded engines a few years ago,
including Firebird, MSSQL XP, Oracle XP, DB2 XP, MySQL, SQL Lite, MS
Access and PostgreSQL. In addition to standard SQL capabilities, our
application required us to be able to mimic the behaviour of other
database engines we support fairly closely.

We went with Firebird 2.0 because:

- Smallest footprint.
- File based databases.
- Lack of size restrictions.
- Friendly license terms.
- Extensive set of data types (with domains to handle anything
funky we run into later)
- Extensive set of collations
- Extensibility
- Active and responsive development community
- Easy installation.
- Easy configuration
- Standards compliance

Limitations we ran into:

- Database files must be local
- Collations are all case sensitive ( we may be able to deal with
this in 2.1, but my 2.0 attempts all failed)
- No built in functions to speak of required a third party UDF
library (this has changed in 2.1)
- No session scoped (i.e. local) temporary tables (global temps are
in 2.1 but not local)
- Different instances of the application cannot both access the
same database file.

The limitations were fairly minor and easy to work around. In
general we are extremely happy with our choice!

Incidentally, our reasons for rejecting MS-SQL XP were:

- Forces our users to install .NET (this was the big show stopper)
- Relatively largish footprint (60Mb if memory serves)
- 2GB database size restriction (this made us nervous as we have no
control over the user's data)
- Missing data types (DATE, TIME)

HTH,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html

.:(firebird):..:(databases):..:(sql):..:(mssql):..:(mysql):..:(postgresql):..:(oracle):.

Firebird Project Releases Firebird 2.1 Zeta 2

The Firebird Project today officially releases
the much-anticipated version 2.1 Zeta 2 of its
open source Firebird relational database software
The 2.1 release has many interesting new features that you can play
with, like database triggers, temporary and monitoring tables, common
table expressions, recursive queries and dozens of new inbuilt
functions. We encourage you to see what you can achieve with these new
features and let us know about any deficiency.

Windows ,MacOSX ,Linux kits fir 32-bit and 64-bit
platforms are ready to download now
You are invited to test it furiously
and report your experiences (good or bad) back to the firebird-devel list.
It brings with it a large collection of long-awaited enhancements that significantly improve performance, security and support for international languages and realise some desirable new SQL language features. Under the surface, it also provides a much more robust code platform from which the re-architecting planned for Firebird 2.5/3.0 is proceeding.
The Firebird project roadmap for 2008 is now available.

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

the most stupid standard i have ever seen

The standard says that a BOOLEAN may be one of the following literals:

• TRUE
• FALSE
• UNKNOWN or NULL (unless prohibited by a NOT NULL constraint)

the boolean values in any sane boleean system are True or false , noooh sql should have other values so you should check them for the not NULL values , more work for nothing

http://troels.arvin.dk/db/rdbms/#data_types-boolean


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

berlios page for firebird is updated

here is the page updated

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

icewalkers page is now updated

it should be on main page soon
http://www.icewalkers.com/Linux/Software/524660/Firebird.html

i have updated firebird page on freshmeat

i have added new firebird 2.1 rc2 links and the changelog

http://freshmeat.net/projects/firebird/

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

Firebird hosting

Today i saw this nice firebird hosting company and i want to share it (it's an very good idea to follow and to create an Firebird+LAP hosting company)

There are many Linux hosting companies, many LAMP (Linux/Apache/MySQL/PHP) environments. But we offer MORE! We offer the Firebird SQL database, Perl and Python scriping languages, FTP and direct shell access, and now Mono, a free implementation of Microsoft's .NET framework! Now you can put put your sites together with VB.NET and C#, but still run on the most popular web server platform.

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

building firebird 2.1.x super from source on ubuntu

$sudo apt-get install automake libtool libreadline5-dev make btyacc bison gawk g++



$wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.17755-ReleaseCandidate2.tar.bz2

$tar -jxvf Firebird-2.1.0.17755-ReleaseCandidate2.tar.bz2

$cd Firebird-2.1.0.17755-ReleaseCandidate2

$./configure --enable-super-server --prefix=/opt/firebird2.1

$make

$sudo make install

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

Choice between MySQL and Firebird?

Which one of the two would you choose and why?

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

Debian Bug report logs for firebird project

some bugs are solved like mips, mipsel firebird port and also the security related
Here is the full report
.:(firebird):..:(databases):..:(sql):..:(debian):..:(bugs):.

debian romanian translations

Eddy Petrisor made an good translation for the debian package
Here are the details with the new translation
.:(firebird):..:(databases):..:(sql):.

building firebird 2.1 from debian git repository

apt-get install libicu-dev libedit-dev git-core

you need to check out the firebird 2.1 repository from debian git

http://lists.alioth.debian.org/pipermail/pkg-firebird-general/2007q3/001125.html

git-clone git://git.debian.org/git/pkg-firebird/2.1
cd 2.1
debuild -i
and wait for it to build it for you

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

lulu pr list

I will work to add them to my pr list and use them for spreading the F word

We recommend these free services – www.pr.com and www.prleap.com and two fee-based services: www.prweb.com and www.prnewswire.com.

Instalando o FirebirdSQL 2 « Hamacker’s Palace

Atualmente o FirebirdSQL encontra-se na versão 2.0 e com a versão 2.1 em fase beta, mas há um problema : para sistemas baseados no debian (ubuntu incluso), o Firebird encontra-se nos repositórios como versão 1.5.3, que possui menos recursos do que a versão 2.0.

[Installing Firebird 2.0 on ubuntu , an very long and a good guide for installing firebird/flamerobin]

Instalando o FirebirdSQL 2 « Hamacker’s Palace

Blogged with Flock

Firebird/InterBase - UDF and NULL parameters - DO not USE NULLs

Do not use NULLs

It is quite a frequent mistake to use NULLs for purposes it was not intended to. For example you have column MIDDLE_NAME in your table; if the person does not have middle name, you should fill in empty string (''); but sometimes people use NULL instead - it is wrong, because NULL means unknown value, not missing/not assigned/empty one. Using NULL as middle name means - "this person probably has a middle name, but we do not know what it is" - and not - "this person does not have any middle name".

Firebird/InterBase - UDF and NULL parameters

Blogged with Flock

Firebird Conference 2007 - New Features in Firebird 2.1

New Features in Firebird 2.1

Firebird Conference 2007 - New Features in Firebird 2.1

mnoGoSearch change history - new version released

Changes in 3.3.5 (17 October 2007)

mnoGoSearch change history

Blogged with Flock

Firebird Conference coverege [LWN.net]

Firebird Conference coveragePhotos and Blog entries from the 2007 Firebird DBMS conference have been posted. "The 2007 Firebird Conference convened from October 18-20 in Hamburg, Germany."

Linux in the news [LWN.net]

Blogged with Flock

Firebird Development release on [LWN.net]

Firebird 2.1 Beta 2 releasedVersion 2.1 Beta 2 of the Firebird DBMS has been announced. "This is the second Beta build of the Firebird version 2.1 series. It is for FIELD TESTING ONLY and should not be put into production systems."

Development [LWN.net]

Blogged with Flock

Firebird 2.1 Beta 2 is available in gentoo portage system

http://gentoo-portage.com/dev-db/firebird
.:(firebird):..:(databases):..:(sql):.

Installing DBI driver for Firebird RDBMS server

DBI driver for Firebird and RDBMS server
This was tested on debian stable with firebird 1.5.x version installed (from repository )
also with perl module DBI aready installed
wget http://search.cpan.org/CPAN/authors/id/E/ED/EDPRATOMO/DBD-InterBase-0.47.tar.gz
tar -zxvf DBD-InterBase-0.47.tar.gz
cd DBD-InterBase-0.47
perl Makefile.PL
make
make test (optional step)
make install

Here are the logs for perl Makefile.PL
perl Makefile.PL
InterBase/Firebird bin directory : [/opt/firebird/bin]
InterBase/Firebird include directory : [/opt/firebird/include]
InterBase/Firebird lib directory : [/opt/firebird/lib]

Full path to your test database:   /tmp/foo.fdb
/tmp/foo.fdb does not exist.
Trying to create the test database..
Please enter a username with CREATE DATABASE permission.
Username :  sysdba
Password :  masterkey
Enter full path to isql:  [/opt/firebird/bin/isql]
Use CONNECT or CREATE DATABASE to specify a database
Checking if your kit is complete...
Looks good
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.4/auto/DBI/
Writing Makefile for DBD::InterBase
For make test
make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base..............ok
t/10dsnlist...........ok
t/20createdrop........ok
t/30insertfetch.......ok
t/40alltypes..........ok
t/40bindparam.........ok
t/40blobs.............ok
t/40cursor............ok
t/40cursoron..........ok
t/40datetime..........ok
t/40doparam...........ok
t/40listfields........ok
t/40nulls.............ok
t/40numrows...........ok
t/41numeric...........ok
t/50chopblanks........ok
t/50commit............ok
t/60leaks.............skipped
        all skipped: Long running memory leak test
t/61settx.............ok
t/62timeout...........ok
        12/14 skipped: wait timeout is not available
t/70nestedoff.........ok
t/70nestedon..........ok
t/80event-ithreads....ok
t/81event-fork........ok 1/17# kid gets sighup
t/81event-fork........ok
t/90dbinfo............ok
        10/13 skipped: active_tran_count is not available
t/91txinfo............ok
t/ak-dbd..............ok
t/dbdadmin............ok
All tests successful, 1 test and 22 subtests skipped.
Files=28, Tests=683, 21 wallclock secs ( 3.02 cusr +  0.32 csys =  3.34 CPU)

And for make install
 make install
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.so
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.bs
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/TypeInfo.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/GetInfo.pm
Installing /usr/local/man/man3/DBD::InterBase.3pm
Writing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/.packlist
Appending installation info to /usr/local/lib/perl/5.8.8/perllocal.pod

Edwin Pratomo / DBD-InterBase-0.47 - search.cpan.org

Blogged with Flock

gambas 2 (development version) 1.9.90 [LWN.net]

Homepage: http://gambas.sourceforge.net
More Info: http://www.kde-apps.org/content/show.php?content=20018
Description: Gambas is a free development environment based on a Basic interpreter with object extensions, like Visual Basic (but it is NOT a clone!). With Gambas, you can quickly design your program GUI with QT or GTK+, access MySQL, PostgreSQL, Firebird, ODBC and SQLite databases, pilot KDE applications with DCOP, translate your program into any language, create network applications easily, make 3D OpenGL applications, make CGI web applications, and so on...
Changelog: see http://gambas.sourceforge.net/changelog2.html

gambas 2 (development version) 1.9.90 [LWN.net]

Blogged with Flock

IBPhoenix Open Source ODBC Driver

compiling and installing it on ubuntu
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co OdbcJdbc

cd OdbcJdbc/Builds/Gcc.lin
make -f makefile.linux

Next read the readme.linux

driver seems to be in OdbcJdbc/Builds/Gcc.lin/Release
sudo cp *.so /usr/lib
sudo ln -s /usr/lib/IscDbc.so /usr/lib/IscDbc

sudo ln -s /usr/lib/libIscDbc.so /usr/lib/IscDbc

cat /etc/odbcinst.ini
[Firebird]
Description = InterBase/Firebird ODBC Driver
Driver = /usr/lib/libOdbcJdbc.so
Setup = /usr/lib/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

cat /etc/odbc.ini
[help]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/2.0/system/help.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No


isql -v help
+---------------------------------------+
| Connected!                 |
+---------------------------------------+
SQL> select * from topics;
IBPhoenix Open Source ODBC Driver

Blogged with Flock

firebird compile times on ec2 extra large instance (fedora core 6)

Extra Large Instance 15 GB memory, 64-bit platform 8 EC2 Compute Units (4 virtual cores with 2 EC2 Compute Units each) 1,690 GB instance storage (4 x 420 GB plus 10 GB root partition) Instance Type name: m1.xlarge (used in EC2 APIs)

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2

yum install automake libtool readline-devel libtermcap-devel make btyacc bison gawk gcc-c++ xinetd ncurses-devel
tar -jxf Firebird-2.1.0.15999-Beta1.tar.bz2
./autogen.sh --prefix=/mnt/firebird2.1.x
time make
real    11m49.195s
user    10m11.510s
sys     1m19.200s
cd /mnt/firebird2.1.x/bin

./isql -u sysdba -p **********
connect "/opt/firebird2.1.x/examples/empbuild/employee.fdb"
SQL> SHOW version;
ISQL Version: LI-T2.1.0.15999 Firebird 2.1 Beta 1
Server version:
Firebird/linux AMD64 (access method), version "LI-T2.1.0.15999 Firebird 2.1 Beta 1"
on disk structure version 11.1

Amazon Web Services Developer Connection : Feature Guide: New Instance Types

Blogged with Flock

building times for firebird 2.1 on amazon ec2 (fedora core 6)

Large Instance 7.5 GB memory, 64-bit platform 4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units each) 850 GB instance storage (2 x 420 GB plus 10 GB root partition)
Instance Type name: m1.large (used in EC2 APIs)

Here how can firebird can be build and the time

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2
yum install automake libtool readline-devel libtermcap-devel make btyacc bison gawk gcc-c++ xinetd ncurses-devel
 cd Firebird-2.1.0.15999-Beta1
./autogen.sh --prefix=/opt/firebird2.1.x
time make
real    12m9.498s
user    10m16.980s
sys     1m19.880s
make install


cat /proc/cpuinfo
processor       : 0
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 33
model name      : Dual Core AMD Opteron(tm) Processor 270
stepping        : 2
cpu MHz         : 2004.542
cache size      : 1024 KB
physical id     : 0
siblings        : 1
core id         : 0
cpu cores       : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm cmp_legacy
bogomips        : 4010.62
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor       : 1
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 33
model name      : Dual Core AMD Opteron(tm) Processor 270
stepping        : 2
cpu MHz         : 2004.542
cache size      : 1024 KB
physical id     : 1
siblings        : 1
core id         : 0
cpu cores       : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm cmp_legacy
bogomips        : 4010.62
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

Amazon Web Services Developer Connection : Feature Guide: New Instance Types

Blogged with Flock

Firebird Development: Firebird 3.0 is with 7-10% faster than firebird 2.1.x

The most important of what was done during last months is certainly start of FB3 project. This is B3_0_transition tree. We try to keep it stable at the same time making big code cleanup, including MT stability. This tree is going to become a base for FB3. For today the main result that after cleanup it's stable on linux, at the same time showing 7-10% better performance compared with fb2.1. I do not mention separately later problems, fixed in 3.0 transition.

Firebird Development: Database Engine

Blogged with Flock

Amazon.com: New EC2 Instances - quad core and so on

Large Instance 7.5 GB memory 4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units each) 850 GB instance storage (2 x 420 GB plus 10 GB root partition) 64-bit platform I/O Performance: High Price: $0.40 per instance hour

Soon i will test with bonie++ and databases load

Amazon.com: Instances - Amazon EC2: Help

Blogged with Flock

building firebird 2.1.x classic from source on ubuntu

cd /opt/build

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2

tar -jxvf Firebird-2.1.0.15999-Beta1.tar.bz2

cd Firebird-2.1.0.15999-Beta1

apt-get install automake libtool libreadline5-dev make btyacc bison gawk g++ xinetd

./autogen.sh --prefix=/opt/firebird2.1.x

make

sudo make install

technorati tags:firebird classic, firebird, ubuntu, gutsy, feisty, linux, freebsd, *bsd, unix, ec2, amazon

Blogged with Flock

Firebird clustering - the bad news

The bad news is that it involves coding in firebird core (at least in the lock manager code)

I'm afraid it won't work. The Classic processes should be able to
synchronize the logical I/O operations (page reads/writes) in order to
perform properly. It's done by the integrated lock manager, but it
cannot work between cluster nodes. As soon as the lock manager is
enhanced (or better say fixed) to delegate the calls to the external
distributed lock manager (e.g. RedHat DLM), this would become a workable
solution.

http://tech.groups.yahoo.com/group/firebird-support/message/88130

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

Firebird SQL Clustering questions

Here comes the fire cluster question
I want to build an Load Balanced Active/Passive Firebird SQL Cluster
(two Active/Passive clusters which have access to the same data). So
the set up will be as follows:
1. Two Redhat GFS Clusters
2. One shared storage of 1TB
3. Layer7 Switch

So my idea is to implement GFS on the shared storage (/shared/db) and
then create two quorums one for one cluster, and the other for the
second cluster. After that I would register the following into a
cluster service:
- Shared IP address
- Shared Storage
- Firebird init.d script

So have anyone managed to create such scenario or is this kind of
scenario supported on Firebird 2.0.1 Classic.


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

quote of the day - mysql , HTTP engine

I was explaining the HTTP engine to a group at the bar there. And this one guy is watching, and he talks to me a little bit, and he goes off. We’re sitting around for the bar for like another hour, and he comes back and says, "Look at this." He had been to Google Spreadsheets, and what he had done was written a RESTful URL and placed it into the HTTP engine and then started collecting data off of a Google spreadsheet and displaying inside the database. So every time he did a SELECT on the database, it was actually pulling data from this Google spreadsheet that he had connected to

Interview with Brian Aker - LinuxWorld

technorati tags:firebird, mysql, http, engine, restful, google, spreadsheet, select *

Blogged with Flock

Did you know stored procedures are atomic in Firebird?

that is quote of the day

Did you know stored procedures are atomic? from the presentation

Real World Applications Using Firebird

technorati tags:firebird, flamerobin, sas, java, jdbc

Blogged with Flock

Great Expectations for Jruby 1.0

[Can someone try Firebird with ActiveRecord Jdbc before the Jruby1.0 release??]
Since the release of JRuby 0.9.8 about a month ago, information about JRuby progress has been a little hard to find. But the latest news out of the JRuby camp leaves us no doubt that it is because the team is working harder than ever in order to deliver JRuby 1.0 before JavaOne.

InfoQ: Great Expectations for JRuby 1.0

technorati tags:firebird, jruby, ror, ruby, jdbc, activerecord, activerecordjdbc, infoq, arjdbc

Blogged with Flock

Firebird 2.1 Alpha 1 Ready for Field Testing

The Firebird team is pleased to announce that the first Alpha builds of Firebird V.2.1 are ready for testing. Binary and source kits for Linux and and some Win64 and Win32 kits should start appearing at the Sourceforge mirrors today. For a summary of new features and bug fixes, see HERE.

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

win64 crazyness for labraries

In the same vein, the System32 directory is reserved for 64-bit libraries. 32-bit libraries go into SysWOW64. That's right: 64-bit libraries are in System32, 32-bit libraries in SysWOW64.You should be aware of this, otherwise you may have a hard time locating your 32-bit Firebird components on a 64-bit Windows system.(Incidentally, WOW stands for Windows on Windows. Now you can also work out what LOL means.)

Default disk locations

technorati tags:win64, firebird, system32, win32, LOL, WOW64

Blogged with Flock

firebird (evil mode) - sometimes i'd rather be a Penguin

Ann Harrisonshowing a sample of the Borland InterBase OpenSource 6.0 announcement T-Shirt. 500 of these have been made, so it's kind of a rarity.
Linux - damn! How Often Do You Do That ?!
Firebird - sometimes i'd rather be a Penguin!
 

Firebird Conference 2006 - Ann Harrison

technorati tags:evil, firebird, tux, interbase, borland, linux, t-shirt

Blogged with Flock

Firebird 3.0 Roadmap

Firebird 3.0 Roadmap

Firebird Conference 2006 - Firebird 3.0 Roadmap

technorati tags:firebird, firebird3.0, roadmap, conference, praga

Blogged with Flock

Firebird Development Priorities - screen shot at firebird conference

Firebird Development Priorities I like these

Firebird Conference 2006 - Firebird Development Priorities

technorati tags:firebird, priorities, conference, praga

Blogged with Flock

Merging Vulcan and firebird code

Dmitry Yemanov today posted to the Firebird-devel list his proposals for merging the Firebird 2 code with the Vulcan code. If you are interested in how it will be done and who will be doing it, subscribe to the list and watch the thread entitled "Merge Proposal".

Firebird - Relational Database for the New Millenium

technorati tags:firebird, vulcan, databases, firebird-devel, firebird2.x, firebird3.x

Blogged with Flock