Editorial 
9th Firebird Developers Day in Brazil
The subscriptions for the Firebird Developers Day (FDD) are now open. The 9th edition of the conference will happen in 21/July, at Piracicaba-SP, Brazil. The number of expected attendees is between 450-600 people.
The conference has a huge importance for the Brazilian Firebird community, as a place where Firebird users have the chance of getting in touch with each other, exchange knowledge and experiences, and watch some great talks. Some of the topics covered by the conference this year are Mobile development accessing Firebird, Window functions, Performance tuning, Understanding and avoiding database corruption, New features of FB 3, cases studies, etc.
Brazil has the biggest Firebird user community in the world. It is listed as Top Country in the Firebird download statistics at SourceForge, with 26% of the 11.5 millions of counted downloads.
Attendees also have the chance to donate money for the project. The collected money can be used for sponsoring the development of a new feature, or donated to the Firebird Foundation. People also can buy several components and tools with huge discounts.
If you live in Brazil or are a Portuguese speaker, don't miss the chance to participate.
Subscribe now! Community News Index (
www.firebirdnews.org)
The news below was collected from
FirebirdNews site. You can periodically visit the site or subscribe to its
RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community.
Community News [May 26, 2012] Firebird driver for node.js in pure java script
From
Henri Gourvest wrote on
google plus:
I am working on a firebird driver for node.js, this driver don't need firebird client library and works on all platforms. Anyone interested ?
[May 24, 2012] Firebird 2.1.5 RC is uploaded to Debian testing and Ubuntu Quantal Quetzal
As you might now Firebird 2.1.5 RC is
released, now the
Debian packages are uploaded to testing repository and on the next Ubuntu Quantal Quetzal's
repository.
[May 24, 2012] ADO.NET provider for Firebird 2.7.7 released
The 2.7.7 version of ADO.NET provider for Firebird is ready for download. This version contains some bug fixes as well as new functionality.
More info...
[May 23, 2012] Firebird 2.1.5 Release Candidate is ready for testing
Firebird 2.1.5 will be the maintenance (point) release for Firebird 2.1. The most recent version is 2.5.1.
Please read its
Release Notes and list of
Bug Fixes for details.
[May 23, 2012] Disabling database triggers in FirebirdClient (.Net)
Via Jirí {x2} Cincura blog:
Database triggers are a nice new feature added to
Firebird in version 2.1. And as you can do a lot of stuff with them, sometimes you also might wanna to connect without firing these, especially if you made a mistake there and it’s forcibly closing your connection.
To disable these, standard Firebird utilities have a new switches. But it boils down to the API itself, nothing magical.
And if it’s in API, it could be
FirebirdClient, right? In last few days among working on other bugs and my daily responsibilities I had a time to dig into this. And now also from .NET world we can use
this feature.
[May 21, 2012] 9th Firebird Developers Day
People interested in participating in the Brazilian
Firebird Developers Day can subscribe on-line for the conference, starting from today. Site with all the details is available at
www.FirebirdDevelopersDay.com.br
[May 21, 2012] TurboBird Version 0.9.2 is released with permissions bugfix
You can check
the homepage for download links for all platforms also there is
github page where you can contribute.
Also for changelog please scroll down to the bottom of the project’s home page: Delete permission copy bug fix. Changing creating
new table, generator and it's trigger.
[May 16, 2012] Ruby Firebird Extension Library — Fb bumped to version 0.7.0
подаръциWith following
changes:
Make fb compatibile with Rubinius. Add encoding attribute and force strings from database to that encoding under Ruby 1.9.x.
Revert to old object allocation method to prevent stack overflow.
Satisfy ISO C90.
[May 16, 2012] Firebird 2.5.2 uploaded in repository for the next Ubuntu release 12.10
I have uploaded firebird2.5 2.5.2~svn+54476.ds4-1 in the Quantal
Firebird ppa for testers. It is the
same package from Debian Sid.
[May 16, 2012] Upscene Production, one of the best Firebird tools vendors, celebrates 10 year anniversary and gives 70% discount
News Via Mindthebird
tweet Upscene Production, one of the best Firebird tools vendors, celebrates 10 year anniversary and gives 70% discount:
http://www.upscene.com
[May 15, 2012] Firebird 2.5.2 package is updated in Debian sid (unstable)
New snapshot firebird2.5 (2.5.2~svn+54476) is uploaded to Debian sid repository.
Here is the Full changelog.
[May 12, 2012] An ALPHA Firebird adapter for Rails 3.2+ is up
Firebird ActiveRecord adapter for Rails 3.2+ is up
on Github, this is Alpha quality and is intended only for testers.
[May 10, 2012] AnySQL Maestro 12.5 released
 | SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (MS Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc).
AnySQL Maestro comes in both Freeware and Professional editions (more information). New version features a powerful and easy to use data reporting tool, recognizing of auto increment columns, improved SQL editors and viewers and a lot of other useful things (full press release). |
AnySQL Maestro 12.5 has been successfully tested with the latest
Firebird ODBC drivers and all the latest Firebird database server versions up to 2.5.1.
[May 10, 2012] Database Workbench 4.2.4 released
 | Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.2.4 Pro". For more information, see here. |
Click here for the full list of changes in v4.2.4
We are celebrating our Ten Year anniversary, spread the word: 70% discount on all our products until the end of May! The free Lite Editions will be released later this month.
Database Workbench supports:
- Borland InterBase (6.x-XE)
- Firebird (1.x, 2.x)
- MS SQL Server/MSDE (7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express)
- MySQL 4.x, 5.x
- Oracle Database (8i, 9i, 10g, 11g)
- Sybase SQL Anywhere (9, 10, 11 and 12)
- NexusDB (3.0 and up)
You like this news? Twitter it! Share it! Blog about it!
[May 09, 2012] Firebird 2.0.x branch with four months changes in review
Alex Peshkoff
backported fix for
CORE-3736: WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table.
Dimitr
backported CORE-3730: isc_dsql_exec_immed2() loses input parameter value with RETURNING clause. And then he updated
the docs for 2.0.7 release.
Horsun Vlad
backported fix for bug
CORE-2977 that was in Firebird 2.1.x incorrectly works with indexed fields of type DATE in OLD ODS (9.1).
Paul Beach
made modifications in 2.0.7 so it can be compiled and build on OSX.
Paul Reeves
synced 2.0.7 branch with B2_0_Release.
In the end Paul Beach made
in the conf. parameter DummyPacketInterval more accurate.
[May 09, 2012] "Hopper for Firebird", version 1 released
 | Upscene Productions announces the first release of: "Hopper — a Stored Code Debugger".
Hopper is a Stored Routine and Trigger Debugger, currently available for Firebird only, an InterBase and MySQL version will follow soon.
|
For more information and a trial download,
see the news @ Upscene Productions,
pricing information is available.
You like this news? Twitter it! Share it! If you'd like to blog about it,
contact us!
[May 06, 2012] Libgda 5.1.0 released with Firebird support and many improvements
As
we announced Libgda is now improves Firebird support in the
latest version: 5.1.0
[May 05, 2012] Database .NET 6.4.4508 released
Hi! I am happy to announce the new major release of Database .NET 6.4.4508 Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface. A standalone tool that does not require installation.
You're welcome to download the Database .NET v4 right now at:
http://fishcodelib.com/Database.htm
What's New (2012/05/05) Features: Supports: - Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
- SQL Server 2000/2005/2008/2008R2/2012
- SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
- SQL Server Express and LocalDB
- SQL Azure
- SQLite (*.db;*.db3;*.sqlite;*.*)
- MySQL
- PostgreSQL
- Oracle
- IBM DB2
- IBM Informix
- Sybase ASE
- MS Access 97-2003 (*.mdb;*.*)
- MS Access 2007-2010 (*.accdb;*.*)
- MS Excel 97-2003 (*.xls;*.*)
- MS Excel 2007-2010 (*.xlsx;*.xlsm;*.xlsb;*.*)
- dBase IV (*.dbf)
- FoxPro (*.dbc)
- Data Sources (OLE DB) (*.udl;*.*)
- ODBC DSN (Data Source Name) (*.dsn;*.*)
- OData (Open Data Protocol)
All-In-One, Free, Simple and Standalone (no install).
Supported Platforms: Windows All (x86/x64)
Requires: .NET Framework 4.0 or higher Direct Download:
DatabaseNet4.zip (7.08MB)
[May 04, 2012] Firebird database that does not burn your data
[May 02, 2012] Libgda 4.2.13 released with Firebird support (work is in progress)
Libgda is a (relatively small) database access library: it is a wrapper like ODBC but with more features to access several database engines * features a meta data extractor (to know all about database objects in a common way) comes with an SQL console application.
Work is in progress for Firebird (Check the
git tree). There is also a special feature which allows one to connect to a database hidden behing a web server (through specific PHP scripts) * LGPL licensed for the libraries and GPL licensed for the tools.
See
http://www.gnome-db.org for more information.
ps: I like the
Gda Browser Relation Diagram tool
[May 01, 2012] Firebird Hosting on Windows & Linux
Having offered
Firebird hosting on our Linux servers for over two years, InspiroHost is happy to announce that we now also offer Windows web hosting with full support for Firebird, PHP, MySQL, ASP and all the tools you need to get your website up and running. Cpanel/Plesk control panels are included, as is 24/7 technical support and server monitoring.
Please visit us at
http://www.inspirohost.com/firebird-sql-hosting/
[April 30, 2012] Doxygenated source code for Firebird 2.5.x
It might be useful for people browsing and studying firebird 2.5.x source code
http://fossies.org/dox/Firebird-2.5.1.26351-0/dir_88a51956a2144fcc1c2646c7da10c1f4.html
[April 27, 2012] DSQL/BLR compilers internals
Posted In:
firebird by Adriano dos Santos Fernandes:
This post is some raw notes and is not very understandable by people who never worked with this code. In fact, the old implementation was so ugly that it was not simple even for me (who is constantly working in this area) to achieve this result. It needed many tries and reverts, but IMNSHO ended very well. Also, this was a large work that took many time, and I'm just writing some records
here.
[April 26, 2012] #ubuntu 12.04 LTS released with Firebird 2.5.1
Ubuntu LTS is released and includes the
latest firebird stable release 2.5.1
[April 26, 2012] Massive code changes: Getting rid of legacy code dsql_nod
Adriano Fernandes
finished a massive code drop and rewrite:
Getting rid of dsql_nod
[April 24, 2012] Firebird in AppWave store
Embarcadero just released the
AppWave Store, with plenty of free apps available. And our loved bird is listed in the mainpage, in the "popular apps" listing.
http://www.appwavestore.com/firebird.html
[April 21, 2012] Testing Codeigniter with Firebird
This was written on albringas.com:
I’ve been using Codeigniter as my development platform and framework of choice since last year. Being a ten year PHP developer, Codeigner was a refreshing way of coding web apps with PHP.
The first ones developments I did with Codeigniter were using MySQL, a very used database. But since I’ve also been using Firebird SQL Database from ten or more years ago, I decided to give a try to the Codeigniter-Firebird duo.
Read
the rest of the adventure
[April 20, 2012] "Hopper for Firebird", beta 4 released
| Upscene Productions announces the 4th public beta of: "Hopper — a Stored Code Debugger". This release fixes several issues as reported by you, our users, and adds a Help file.
For more information and a trial download, see the news @ Upscene Productions, pricing information is available. |
You like this news? Twitter it! Share it! If you'd like to blog about it,
contact us!
[April 20, 2012] #AnyDAC Spring 2012 v 5.0.7 — #Delphi Components for Firebird, Interbase and more
 | DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2012 release v 5.0.7.2333 — high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications. |
AnyDAC for Delphi can be immediately
downloaded from the
download page.
What is new in v5.0.7 and what is AnyDAC?
AnyDAC v 5.0.7 Highlights - Delphi XE2 and Mac OS X support;
- FPC 2.6.0 / Lazarus 0.9.30.4 and Windows x86/x64, Linux x86/x64 and Mac OS X support;
- UpdateOptions.UpdateJoinedFields and TADMapRule.NameMask added;
- Auto-inc fields improvements;
- SQLite v 3.7.11 support;
- SQLite native Array DML support;
- SQL Server 2012 support;
- Advantage DB TADADSUtility service component;
- Advantage DB support for aliases;
- ReportBuilder DADE;
- Nany driver and addon improvements;
- Multiple enahncements to the help system.
And
more.
AnyDAC for Delphi AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check:
AnyDAC Core Features - Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
- Generic access to any database supported through dbExpress or ODBC data sources.
- Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
- Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
- Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
- First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
- Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
- Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
- Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.
AnyDAC Natively Supported Databases - Enterprise — Oracle, SQL Server, IBM DB2, Informix.
- Workgroup — Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
- Database in clouds — Microsoft SQL Azure.
- Desktop — SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
- Embedded — SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
- Bridges — dbExpress, ODBC.
With best regards,
DA-SOFT Technologies Team
[April 19, 2012] ANN: FB TraceManager V2.5.2 available
 | Upscene Productions is proud to announce FB TraceManager V2.5.2, a professional environment to monitor, profile, trace and optimize Firebird databases. |
More information on the new release is available here: http://www.upscene.com/displaynews.php?item=20120416
This release fixes a critical stability issue and includes various minor bugfixes and adds experimental Firebird 3 trace support. There are also the following new screencasts available:
More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.: http://www.upscene.com/go/?go=fbtm
[April 18, 2012] Searching for Firebird programmer
I got this in my email box, maybe some of you would be interested:
Dear Carlos,
I came across your name asking developers to send details of large companies who use firebird databases. I am actually an end-user who has the open mind to want a firebird database but cannot find anyone who does this programming. I am based in the UK and am told to 'steer away' from firebird as it is not proven, etc. etc.
It really is quite disappointing and seems that there are many others like myself who would like to have an alternative but cannot find a developer. So I am the horse looking for water to drink — but there is no water...not like you describe leading the client to the water but not getting them to drink.
Any suggestions?
PS: It is weird that in the actual days, with so many great case studies published, there are still people who thinks FB is a "toy".
[April 18, 2012] MVC 4 / Firebird / EF 4.1 and Database First
Recently viewed a great presentation by of Steve Sanderson (
blog.stevensanderson.com) on using SPA with MVC4. I tired with FB 2.5 and it works great. I've written my
first blog This shows how to change the default behavior from Code First to Database First with these new technologies. I just wanted to contribute
the list.
Thanks,
John R. Tomaselli
[April 13, 2012] Firebird V2.0.7 has been released — likely to be the last for the 2.0-series
Firebird V2.0.7 has been
released.
This sub-release 2.0.7, likely to be the last for the 2.0-series, does not add any new functionality to the database engine. It incorporates a number of
bug fixes that did not make it into the v.2.0.6 sub-release in June 2010 or have been backported from subsequent 2.1.x and 2.5.x releases.
This release 2.0.x contains a large number of new features compared with 1.5.x, including derived tables, support for Execute Block, increased table sizes, new improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimiser improvements, enhanced security features, support for on-line incremental backups along with numerous other improvements and bug fixes.
[April 12, 2012] Firebird Download stats for April
Here are the Sourceforge stats from the beginning of the poject until now (The number of downloads passed 11,3 Millions).
I excluded the year 2000 (there were no file releases on sf then).
Also the sf
logo impressions look interesting (Maybe it should be put back on the front page).
[April 08, 2012] Beta version of Jaybird 2.2 released with support for jdbc 4.1
The Firebird JDBC team is happy to announce the release of
Jaybird 2.2.0 beta-1.
This release contains the following changes:
- Enhanced support for JDBC 4.0 (Java 6),
- Support for JDBC 4.1 (Java 7) — including try-with-resources support,
- Implementation of getGeneratedKeys(),
- Enhanced support for the services API,
- Support for 64 bit native libraries for Type 2 / Embedded,
- A number of bug fixes.
The beta release is also available on Maven (*):
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.0-beta-1</version> The
artifactId depends on your target Java version:
jaybird-jdk15,
jaybird-jdk16 or
jaybird-jdk17.
*) As this is the first release to Maven and we need manual authorization from Sonatype, it can take several days before the artifacts are really available on Maven.
Mark Rotteveel
[April 07, 2012] Jaybird 2.2 beta hopefully will be released this weekend with jdbc 3.0 and open/libre office support
News via
Mark Rotteveel on
twitter:
Finishing touches to Jaybird 2.2 beta releasenotes, hopefully I will be able to finally release it this weekend
ps: Jaybird 2.2 is the next
Firebird jdbc driver release with
many fixes which will include improved support of the
JTA specification (XADataSource and XAResource interfaces). Additionally it already has improved support for OpenOffice.org/LibreOffice Base component, which deviates in some places from the
JDBC 3.0 specification.
[April 06, 2012] TurboBird for 0.9.1 is released with minor bugfix (64 bit build)
You can check
the homepage for download links for all platforms also there is
github page where you can contribute.
Also for changelog please scroll down to the bottom of the project's home page: Minor bug fix, producing 64 bit version, because 32 bit cann't start in Linux Mint DE 64 bit.
[April 06, 2012] Differences between recreate procedure and create or alter procedure
I was recently in a talk related to
Firebird and I found, that people are not aware of these two constructs. Either they don’t know both or don’t know they differ. These statements are doing similar stuff, but the evil is in
details.
[April 04, 2012] Perl driver DBD-Firebird 1.00 is released
Here is the full
Changelog and you can use your
Cpan mirror near you
You can contact the developers on
dbd-firebird-devel mailing list.
[April 02, 2012] RAD Studio survey
There is a new RAD Studio (Delphi,etc)
survey on-line, from Embarcadero.
Firebird is mentioned so, go ahead and participate if you use Delphi, CBuilder, etc.
[April 02, 2012] Firebird 2.5.2 package updated in Debian testing and sid (svn snapshot)
New Debian package is
uploaded to debian testing and
unstable releases, and
here is the list of changes.
About the Newsletter
You can
unsubscribe from the newsletter at any time.
Firebird database that does not burn your data — a short lecture to display some key features of Firebird SQL.