Wednesday, November 30, 2005
FBHook is a simple utility which will hook and report the following events
from any Firebird Client Application:
~ Database connect/disconnect
~ SQL Statements
~ Transaction Start/Commit/Rollback
FBHook can be downloaded from (http://sourceforge.net/projects/fbutils).
Download information can be found here:
· Beta 1( 2005-11-30 ) ·
(Please read the Changelog for details)
- New GDS implementation for the Firebird/Fyracle External Proceudre
* Added a new namespace FirebirdSql.Data.StoredProcedureEngine
with two new classes:
- Updated to build using .NET 2.0 RTM.
- Improved connection pooling implementation.
- Changes on FbConnectionStringBuilder class to use the new
Carlos Guzmán Álvarez
EMS announces a new version of SQL Query 2005 - a utility for visually building SQL queries for MySQL, PostgreSQL, MS SQL, Interbase/Firebird and DB2 databases! Its user-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more.
You can download the latest version from http://www.sqlmanager.net/downloads
The article continues at http://www.sqlmanager.net/news/751
"I'm doing some experiments with Firebird 2.0 beta 1 embedded and I found out some "interesting "features:
1. You can connect to an embedded Firebird database through ODBC
2. You can also connect to an embedded Firebird database through JDBC"
Read the rest on it's own blog
"For years I have used a program called GBACKSCHED on my Win32 servers
to backup firebird db's using a method that provided daily and weekly
archiving. I am now moving servers to Linux and need a utility that
will do the same and was thinking a shell script run by crontab would
do the trick."
Response From: "Ian A. Newby"
It creates a backup directory named for the day of the week (except
for sunday, when it names it with the week number). It then Symlinks a
Current directory to point to the current backup directory. This is
used by a different script which fetches the backups to a different
Monday, November 28, 2005
Saturday, November 26, 2005
KInterbasDB is a Python extension package that implements Python
Database API 2.0-compliant support for the open source relational
database Firebird and some versions of its proprietary cousin Borland
Interbase. In addition to the minimal feature set of the standard
Python DB API, KInterbasDB also exposes nearly the entire native
client API of the database engine.
KInterbasDB is free--covered by a permissive BSD-style license that
both commercial and noncommercial users should find agreeable.
What's new in release 3.1.3?
KInterbasDB 3.1.3, a maintenance release of the stable 3.1 branch,
fixes two bugs. This will probably be the last release in the 3.1
series. A changelog is available here:
Where can I learn more about and download KinterbasDB?
Friday, November 25, 2005
via Kevin Dangoor
redesigned database structure using Firebird SQL, though invisible to most users, will improve program performance and reduce server loads.
Wednesday, November 23, 2005
and Firebird Developer Magazine” is available for ordering.
It was redesigned to 8.5x11 portrait format with professional 300 dpi
It will be printed in full color on high-quality paper with very nice cover.
You can buy it at here:
Price is USD$14.99 without shipping.
Don’t miss an opportunity to have a hard copy of “all times greatest
The InterBase and Firebird Developer Magazine
"I bet Lewis Cunnigham that within 10 years of this post, open source software will dominate the database market. Particularly, I'll bet that by November 19th, 2015:
1. At least 60% of all revenue in the database market will come from support, services, and bundled applications attached to open source, shared source, freeware or hybrid databases;
2. At least one major proprietary database vendor among the current top four (Oracle, Sybase, MS and IBM) will go out of business, open-source their main database system, or convert entirely to bundled freeware licensing;
3. At least two-thirds (measured financially) of applications vendors, integrators and hardware vendors will offer official support for one or more open source database systems, and at least one in ten will support open source databases exclusively.
4. At least one company whose primary emphasis is an open source database or related services, or one division of a larger company devoted to an open source database, will report more than $200 million in revenue (or the inflated equivalent) for the year."
Tuesday, November 22, 2005
- Firebird 2.0 support - IBUtils can now work with FB 2.0 Beta 1. I do not use FB 2.0 regularly (still working with FB 1.5), but it seems that everything works fine. In case of troubles with FB 2.0, do not hesitate to contact me. [ED: author Ales Kahanek]
Article By Charles Babcock
Monday, November 21, 2005
|New component TFBLParamDsql (thanks to Uwe Willmann) it's a direct TFBLDSQL descendant supporting named parameters instead of "?" placeholders, like IBX and IBObjects. lazarus package (fblib.lpk) now works with version 0.9.10 of lazarus ide.|
Tuesday, November 15, 2005
Its been a while but version 0.4.0 of the FireRuby library has been released. The two big highlights for this release are some changes to aid in the development of the Firebird ActiveRecord adapter and the addition of functionality to obtain type information for database fields. Consult the documentation accompanying the release for more information.
Monday, November 14, 2005
released. You can download it from the SourceForge.net site, the links on
the Wiki will be updated in two days (currently I'm on Firebird Conference
2005 in Prague).
"Please find a new build of fyracle.dll in the /dowloads area.
Let us know how it works for you.
We're all at the FB conference in Prague, so if it works okay we can announce Delphi support at the conference. "
[ED: seems to be working with ibexpress (based on delphi)]
- incremental hot backup
- derived tables (subqueries in FROM clause)
- storing databases on raw devices
- new EXECUTE BLOCK allows the client to call an "unnamed stored procedure" which is sent as a command
- IIF(condition, value1, value2) added as a shortcut to CASE WHEN condition THEN value1 ELSE value2 END
- CROSS JOIN is supported ("a CROSS JOIN b" equals "a INNER JOIN b ON 1 = 1")
- ROWS introduced to replace FIRST/SKIP
- SEQUENCE introduced as a shortcut to GENERATOR
- "NEXT VALUE FOR sequence" introduced as a shortcut to "GEN_ID(sequence, 1)"
- Default values for stored procedure arguments
- Index length limit (252 bytes) is removed
- Expression indexes introduced
- Optimizer improvements
- New string functions: LOWER() and TRIM()
- Security improvements (better password encryption, active protection agains brute-force attacks, users can change their own passwords...)
- and many others...
Ps: article source dotnetfirebird
Sunday, November 13, 2005
Watch the links, as they may wrap.
Official Windows Setup and Installer For Classic and SuperServer Beta 1.0 (.exe) (4.1mb)
Embedded Server for Windows Beta 1.0 (.zip) (2.5mb)
Classic for Linux Beta 1.0 (.rpm) (4.4mb)
Classic for Linux Beta 1.0 (.tar.gz) (4.3mb)
SuperServer for Linux NPTL Beta 1.0 (.rpm) (4.5mb)
SuperServer for Linux NPTL Beta 1.0 (.tar.gz) (4.4mb)
Thursday, November 10, 2005
- Added support for stored functions & procedures
in other languages than PL/SQL
- Added plugin for Java stored functions & procedures
- Added support for external C stored functions
Support for external stored procedures has been
contributed by Eugeney Putilin, Vlad Horsun and
The installers are available through the Janus
Software website and ftp servers. See:
for the free runtime & developer demo
for the full developer version.
The recommended upgrade procedure is to first
uninstall any previous versions of Fyracle and only
then to install the new 0.8.9 release. Remember
to save your configuration files (firebird.conf
and aliases.conf) if you changed them!
The uninstaller has a start menu entry on Windows
and can be found at the top of the install
directory on Linux and Windows.
If you want to use the new Java stored procedures,
please review your java configuration file (jvm.conf)
after installation. The first non-comment line should
contain a path to your java virtual machine (jvm.so).
On Linux, getting to a working JVM install is not so
easy: several shared libraries much be reachable via
the library search path.
An updated version of Compiere will be available soon.
A dotnet/mono plugin is actively being developed.
I spoted the news on Josh Berkus's blog
It's pretty exciting to have all of these open source database developers in one place. So far: HSQLDB, Derby, SQLite, Firebird, Ingres, us (PostgreSQL) and of course a huge MySQL contingent (they're one of the conference sponsors). It's definitely a cool alternative to the database track at OSCON, because here we can do technical talks liable to be comprehended only by other database geeks.
Saturday, November 05, 2005
a www.ebay.com.au but you can reach it with that search from the others as
Happy bidding! :-)) Please feel free to blog it!
Thursday, November 03, 2005
Full story at zdnetwork