FirebirdNews.org wishes every Firebird lover a Merry Christmas! Site will be online 24×7, but you can notice some delayed posts, since some authors should be out for Christmas vacations, etc 😉
A special thanks goes for Marius Popa for his help posting news in the site!
From Dmitry Yemanov: As you might know, Firebird 2.0 no longer allows to alter/drop procedures that are used by active statements. However, we’ve got many requests from customers to restore the previous behaviour, because now it’s impossible to upgrade metadata under load. While we don’t consider this practice safe, I’d like to report that the new limitation is removed in the v2.0.1 release, thus rolling back to the prior logic. All potentially confusing situations (when two different versions of the procedure may coexist in memory simultaneously) are reported in firebird.log.
Curious about what you can expect from Firebird team in 2007? Check out the new official roadmap!
For those who are using Firefox, there is an interesting plugin that may help formatting your posts to FirebirdNews site using a “rich editor” direct in your browser. Take a look at the Performancing plugin.
You can write and post to FirebirdNews direct from the plugin.
A problem that I noticed is that you can’t choose in what category the post should be included 🙁
Surfing some Delphi blogs, I found this post about what is needed to do to be able to run InterBase on Windows Vista. In a recent talk with Dmitry Yemanov, he told me that Firebird runs OK on Windows Vista, but to get the local protocol working, you need to do a small change in firebird.conf “IpcName” parameter, changing the default value to Global\FIREBIRD. You can find more information about this reading the firebird.conf file.
Codice Software, authors of Plastic SCM (Source Control System) uses Firebird to store all the projects information data.
So then we decided Firebird would be an important part of the product. And I can tell you this is one of the decissions we never regret. BTW we wanted to have a full portable data layer (in terms of DB independency), so we also tried with Postgres (specially on Linux and Solaris) and later on with SQL Server. Results? Firebird is the easiest to deploy and has a very good performance ratio (and we always find ways to tune it even further), Postgres is a bit faster in some operations but extremely slow dealing with BLOB data and SQL Server is faster but much harder to deploy. So we are proud to tell that Firebird is a center piece of Plastic SCM.
Read full story here.
CodeGear, the Borland Developers Tool divison, now has its own site up and running. CodeGear will be responsable to continue the development of Borland IDEs (Delphi, JBuilder, etc) and InterBase database.
Query cancelation
Implementation of the statement cancellation feature has been committed into the version 2.1. It works via the monitoring tables – you just need to issue the DELETE command against the MON$STATEMENTS table (there’s no API implementation yet). It could be done by the application itself (using a secondary attachment) or by a server administrator. Examples:
DELETE FROM MON$STATEMENTS
WHERE MON$STATEMENT_ID = ?
or
DELETE FROM MON$STATEMENTS
WHERE MON$ATTACHMENT_ID = ? AND MON$STATEMENT_STATE = 1 -- active
The feature works for both SS and CS engines. The client application receives the GDS error code isc_cancelled.
Trusted authentication on Windows
Ability to authenticate Firebird users through a Windows domain is now available in the source tree and will be included into the v2.1 release. An up-to-date client library is required in order to use this feature. CURRENT_USER represents a logged in Windows domain user in this case. It’s expected that firebird.conf will introduce an option allowing you to choose between native-only, trusted-only and mixed authentication modes.
65% discount from the full price!
SR UDF Library version (2.0.2.0) – a user defined function library (161 UDFs) for InterBase and Firebird on the Windows platform. This version of SR UDF Library supports the following standard routins: Math, File,DateTime, String, Regional, Hash in addition to Conversion routins for converting different measurement units!
We believe in IBProvider v3 quality and robustness. And we want to make a gift for all Interbase and Firebird Community users. New IBProvider v3 Free Edition is absolutely free of charge and most powerful version based on the commercial core of IBProvider v3. We are sure the community will appreciate our gift, since previous free IBProvider v1.5 (Dec 2001) still counts about a thousand downloads a month.
IBProvider Professional Edition
Professional developer kit for Interbase and Firebird. Allows to creare powerful software in differents IDE’s and programming languages which support OLE DB, ADO or ADO .Net technology. Can be using as MS SQL Linked Server, in the OLAP cubes and in the reporting engines like Crystal Reports.
Read more about differences between IBProvider editions: http://www.ibprovider.com/eng/documentation/differences_between_versions.html
Download latest version here: http://www.ibprovider.com/eng/trial.html
Merkulov Andrew.
