Firebird News

Tuesday, August 30, 2005

Daffodil Replicator v2.0 released with support for Firebird data replication

Daffodil Software today released Replicator v2.0 ( beta ) with support for Firebird to Firebird data replication, in addition to significant performance enhancements. With v2.0, all replication operations can be performed faster, when compared to earlier Replicator versions.

The new features introduced in Replicator v2.0 are:
Support for Firebird: Replicator v2.0 can be used with Firebird database. It supports bi-directional data synchronization between Firebird ( Server ) database to multiple Firebird ( Client ) databases. The version does not provide the functionality of Firebird data replication to heterogeneous database servers. This functionality will be introduced in future Replicator versions.

Partial Tables Replication: Partial Table Replication allows a user to ignore specific columns in a publisher database table. It provides the flexibility to disregard data ( residing in publisher database columns ) that is not required on the client side, hence making the replication operation more efficient.

Cyclic Tables Replication: Replicator v2.0 can be used with complex database structures where tables have cyclical dependencies. The previous replication versions could not replicate the tables that hold references to each other.

In regards to performance, with Replicator v2.0, the XML file creation process has been reviewed and optimized. The new process drastically reduces the time taken in capturing the insertion, deletion and updation of records from Replicator Shadow tables and transmitting the same to the target database server. Major bug fixing related to tags issues in XML file, appending the foreign key constraint and creation of transaction log file during Real time Replication has also been done.

For more information on Daffodil Replicator v2.0, drop us a line at info@daffodildb.com. Users can download the new version and revised documents from: http://www.daffodildb.com/replicator/index.html

About Daffodil Software
Daffodil Software develops and markets a lineage of high-performance, affordable database servers and tools. Their mission is 'to offer cost-effective, high-quality, customizable data management tools and solutions that evolve with corresponding technology trends'. The company also deals in open source CRM, open source database and offshore software development.
..::::..

Firebird Conference - Call For Speaker Papers deadline

Just to remind everybody, the Firebird Conference - Call For Speaker Papers
deadline is meant to be tommorrow....

Current Proposals can be found at:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=fb_conf_proposals

If you would like to submit a proposal, and speak at the conference,
can you submit your proposals to me very soon.

Call for Papers:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=fb_conf_call_papers


Regards
Paul Beach


"I'm looking for opinions. The talks I'm considering for me and Jim include:

Firebird ODS and V2 ODS changes
Detecting, correcting, and preventing database corruption
Concurrency control and garbage collection
Vulcan status, features, & goals
Configuring Firebird and Vulcan for your application
First steps in performance tuning

Any suggestions, additions, deletions ... we won't do all the ones
listed but before I commit to specific topics I thought I'd ask."


Regards,
Ann W. Harrison [aharrison at ibphoenix.com]





..::::..

ibWebAdmin 1.0 released after 3 years

This [news/] email is to inform you about the release of version '1.0' of
'ibWebAdmin' through freshmeat.net. All URLs and other useful information
can be found at

http://freshmeat.net/projects/ibwebadmin/

The changes in this release are as follows:
This maintenance release fixes all bugs reported over the last months,
including enhanced error handling and fixes for the references
warnings with PHP 4.4 and 5.1. A Hungarian translation was added.

Release focus:
7 - Major bugfixes

Project added:
Thu, May 23rd 2002 15:02 (3 years, 3 months ago)

Project description:
ibWebAdmin is a web based admin tool for the InterBase and Firebird
database servers. Beside creating, modifying, and deleting of
databases, tables, domains, generators, triggers, indices, and users,
it supports import and export of data in CSV file format. It features
browsing through tables and entering/editing of data, including
BLOBs.


..::::..

Monday, August 08, 2005

Firebird 2 Alpha 3 Linux Builds are now available for download and testing.

I saw this on fbtalk

Linux

* 4th Aug 2005 Classic for Linux 2.0 Alpha (.rpm) (3.9mb)
* 4th Aug 2005 Classic for Linux 2.0 Alpha (.tar.gz) (3.9mb)
* 4th Aug 2005 Classic Debug Build for Linux 2.0 Alpha (.tar.gz) (20.6mb)

Linux NPTL

* 4th Aug 2005 SuperServer for Linux NPTL 2.0 Alpha (.rpm) (4.0mb)
* 4th Aug 2005 SuperServer for Linux NPTL 2.0 Alpha (.tar.gz) (3.9mb)
* 4th Aug 2005 SuperServer Debug Build for Linux NPTL 2.0 Alpha (.tar.gz) (20mb)

..::::..

Saturday, August 06, 2005

Configuring Firebird for Your Application - OSCON session

Ann Harrison, IBPhoenix

Track: Databases
Date: Thursday, August 4th, 2005
Time: 11:35am - 12:20pm
Location: D136

Not all database applications consist of a single database running on a dedicated machine, accessed by remote clients. Some require the throughput of an application linked directly to the database handling code. Others are self-contained and should not affect any system-wide settings. The Firebird database engine has three configurations: a shared server, an embedded server, and a library of access routines. The API is the same, so you can offer different models for ‘personal’ and ‘corporate’ versions of your application.

The traditional model for databases is a single server running on a dedicated system. In Firebird, this model is SuperServer. The server process listens for connection requests, maps transactions to threads, and maintains shared caches of metadata and database pages. In Firebird 2, you can configure a system to support several instances of the SuperServer to manage individual databases, or groups of databases, separately.

The SuperServer code that handles database operations can be built as a library and linked directly to applications. This model is “Classic” Firebird. A shared memory lock table coordinates the activity of separate applications.

Data management is also important for personal applications – applications designed to run on PC’s – not dedicated database servers. For these applications, Firebird has embedded mode. The server and all its configuration information is bound to an application that has exclusive access to the databases it uses.

Firebird’s API is consistent across all models – this talk explains how to choose the model – or models – that fit your application.


Download presentation file


..::::..

Report from OSCON by Ann W. Harrison


I'm returning from two days a O'Reilly's Open Source Conference in
Portland Oregon - lovely city. I met Rob Schuff (sp?) again - after
five years I think - and David Jenks. Interest in Firebird was moderate
(at best) but even the other database sessions were lightly attended and
mostly full of current users. The high points of the conference for me
were the new features talks by Postgres and MySQL. The flagship
features for the new Postgres due out this year are Stored Procedures
(less capable than ours) and Views. Postgres has added an intermediate
bitmap in index retrievals (like ours) and two-phase commit.

Almost made up for the half an hour I spent talking to a potential user
who had been told that he could use Firebird for his application because
he didn't need much of "that relational stuff."

Cheers,



..::::..