JEDI VCS 2.41 client release

The JVCS team is happy to announce the JEDI VCS 2.41 client release,
which is intended as a maintenance release for 2.40 but also includes
some new features.

Red-Soft to provide official support for UIB!!!

Nikolay Samofatov asked what is the process to submit patches and is it possible to obtain commit rights for the project:

Read more here

UIB 2.1 released

New features:
- New FB2 Database properties:
.InfoActiveTransactionsCount
.InfoCreationDate
- Support for quoted parametters (:"my param").
- Metadata explorer now read roles (Pierre Yager).
- New Lazarus sample to explore metadatas.

bug fixes:
- TJvUIBEvent bug when destroying component is fixed.
- ExecSQL now call Execute when query is prepared;
- When a query don't return fields, a call to next don't raise exception anymore.
- TJvUIBDataSet: a bug was fixed when the query return only one record.
- RowsAffected now support stored procedures.
- Parsing error corrected with stored procedure.
- Removed Fastcode unit because of bug in asm code.
- bug with "isc_reset_fpe" function that don't exist on unix plateforms is corrected.
- Some bug fixes with Appserver samples.

Firebird PHP Generator

SQL Maestro Group is announcing the release of Firebird PHP Generator. It is a freeware but powerful Firebird GUI front-end that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.

Key features:

• Data management: adding, editing and deleting records
• Customization of the HTML appearance
• Filtering and sorting abilities
• Data protection with a lot of security settings
• Lookup options for master-detail relations
• Integrated script navigation
• Ability to create multilingual web apps.

CopyCat version 2.00.0

> After a long delay, Microtec is pleased to announce the release of the
> long-awaited CopyCat version 2.0!
>
> CopyCat is a set of Interbase/Firebird replication components for
> Delphi and
> C++Builder. Using CopyCat, you can easily build applications
> comprising advanced
> database replication capabilities, which can be deployed royalty-free.
>
> Version 2 introduces a number of major improvements, featuring most
> notably:
>
> - Multi-database replication capabilities (support for MS SQL
> Server, and other databases soon)
> - Transport-layer abstraction (support for replicating over XML-RPC).
> - Conditional table filtering.
> - New per-table options, allowing to specify which operations
> (Insert / Update / Delete) should be logged.
> - Added a TCcReplicator.SyncronizeRows method for manually provoking
> replication of a specified set of records.
> - No more special replication users!
> - Redesigned website, with the addition of a new web forum for
> support and updates (http://www.microtec.fr/copycat/forums).
> - A new flash tutorial to get get to grips quickly with the basics
> of CopyCat, available here:
> http://www.microtec.fr/copycat/GettingStarted.htm
> - Probably much, much more than I can remember ! ;)
>
> For more information about this new release, click here :
> http://microtec.fr/copycat/forums/showthread.php?t=1
>
> General information about CopyCat : http://www.microtec.fr/copycat
>
> Demonstration application :
> http://www.microtec.fr/copycat/download.php?type=demo
>
> Evaluation version :
> http://www.microtec.fr/copycat/download.php?type=eval
>
> Note: For users of previous versions who purchased over a year ago, a
> 30% discount will be granted on upgrade. For those who purchased less
> than a year ago, this update is free.
>
> --
> Best regards,
> Jonathan Neve
> _______________
> CopyCat - advanced Delphi components for database replication,
> supporting CodeGear Interbase, FirebirdSQL and MS SQL Server!
> _______________
> CopyTiger - the ultimate database replication solution for CodeGear
> Interbase, FirebirdSQL and MS SQL Server!

IBUndelete V2.0 for Firebird and InterBase

IBUndelete V2.0 for Firebird and InterBase is available. This version now supports Firebird 2.0.x and InterBase 2007 database structures and improved undelete algorithms.

Delphi For PHP Released

From Slashdot: http://it.slashdot.org/article.pl?sid=07/03/28/0314222

Codegear (now a subsidiary of Borland) has just released version 1.0 of Delphi for PHP, a RAD development environment (running on Windows) that produces standard PHP code. It features a large set of built-in components, including ones that use AJAX for database access; and Codegear is encouraging users to develop their own components. The framework, VCL for PHP, is open source, and documentation follows the PHP model. Initial database connectivity is for MySQL and Interbase (Codegear’s commercial database that spawned the open-source Firebird), but more are promised.

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.

Delphi for PHP - First impressions

Myles Wakeham wrote about Delphi for PHP and firebird issues:

Well I received my downloadable Delphi for PHP today. I haven’t had a huge amount of time to play with it, but there are some very impressive features, but a couple of ‘critical’ missing features for me.

Delphi on Rails?

The developers who brought us Delphi, that Ferrari of Integrated Development Environments, are entering the dynamic language tools race, and this time they are sporting Ruby red.

Firebird 2.0.1 Accepted in Debian unstable

Firebird 2.0.1 package is accepted in Debian unstable

Morfik 07 released

Morfik 07 was released a few days ago.
It uses Firebird as the default database.
Check it out, it is a great tool for generating AJAX web applications.

Optimization of network traffic

Devrace have published a new article “Devrace FIBPlus: Optimization of network traffic in Delphi and C++ Builder applications”. From it you will get to know:
Caching metadata.
Using poRefreshAfterPost option in TpFIBDataSet Options.
Recurrent use of queries.
Client BLOB-filters. «Transparent» packing of BLOB-fields, etc.

Firebird point-release 2.0.1

This is the first sub-release since the 2.0 release in November, 2006. It adds no new features (those are coming in v.2.1) but provides a large number of bug-fixes and a few improvements. It is highly recommended that v.2.0 installations be upgraded to get the benefits of these.

Important Change
In Firebird 2.0, a deliberate restriction was imposed to prevent anyone from dropping, altering or recreating a PSQL module if it had been used since the database was opened. An attempt to prepare the DDL statement would result in an "Object in Use" exception.
Many people complained that the restriction was unacceptable because they depended on performing these metadata changes "on the fly". The restriction has therefore been removed. However, the reversion in no way implies that performing DDL on active PSQL modules is "safer" in Firebird 2.0.1 than it was in V.1.5.

Read/download release notes (789 Kb, right-click to save to disk)
Go to the Firebird 2.0.1 Downloads page

Delphi 2007 for Win32 is GOLD!

There are several reports that Delphi 2007 for Win32 gone RTM, and in some countries you can already download it. For more information check http://blogs.codegear.com/.
First impressions are that this easily can be THE best Delphi release to date!

Backup remote DB locally

By default, Firebird stores backup files on local disk, but using GBak you can use something like the following to backup a remote database, locally.

gbak -b -z 192.168.0.1:MyDBAlias "C:\DatabasesBackup\localbackup.fbk" -verbose -user SYSDBA -password masterkey

Approximate Record Count in Firebird

The following solution was originally posted to the Firebird Support Mail List by Ivan Prenosil.This solution only returns an approximate record count*, and will include records that have been deleted (and not yet garbage collected) as well as records that have been inserted but not yet committed.

Code:
/* first update the statistics */
UPDATE RDB$INDICES SET RDB$STATISTICS = -1;
COMMIT;

/* Display table names and record counts */
SELECT RDB$RELATIONS.RDB$RELATION_NAME,CASE WHEN RDB$INDICES.RDB$STATISTICS = 0 THEN 0 ELSE CAST(1 / RDB$INDICES.RDB$STATISTICS AS INTEGER) END FROM RDB$RELATIONS LEFT JOIN RDB$RELATION_CONSTRAINTS ON RDB$RELATIONS.RDB$RELATION_NAME = RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME AND RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'LEFT JOIN RDB$INDICES ONRDB$RELATION_CONSTRAINTS.RDB$INDEX_NAME = RDB$INDICES.RDB$INDEX_NAME WHERE RDB$VIEW_BLR IS NULL ANDRDB$RELATION_ID >= 128 ORDER BY 1;


* This will only work on tables that have a primary key.