Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
You are here: Home Newsletter
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Google+ Twitter Facebook RSS
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
May 27, 2013
More News
Firebird SQL Project Newsletter, Issue 5

Editorial
 10th Firebird Developers Day in Brazil 

 
Firebird Developers Day X
 The 10th edition of the conference will happen in 20/July, at Piracicaba-SP, Brazil. The number of expected attendees is between 450-600 people. Join us to celebrate the 10th anniversary of the biggest Firebird conference in the world! The subscriptions for the Firebird Developers Day (FDD) are now open.

 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 Firebird Optimization and Recovery, Exploring the Numeric datatypes, Exploring the Firebird System Tables, Developing mobile applications accessing Firebird, n-tier Object Oriented programming, Case Studies, and more...
 Brazil has the biggest Firebird user community in the world. It is listed as Top Country in the Firebird download statistics at SourceForge, with 27% of the 12.9 millions of counted downloads so far.
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 and save money!

 

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

[20.05.2013] 10th FDD - Subscriptions are open!

The site of the Firebird Developers Day's 10th edition is now up and running. Interested people can already subscribe on-line to the conference.Spread the news and come to comemorate the 10th anniversary of the biggest Firebird Conference in the world. PS: FDD is a Brazilian conference for the Portuguese speakers community.


[14.05.2013] Firebird Python driver FDB 1.1.1 is released

FDB release 1.1.1 is out: http://pypi.python.org/pypi/fdb Bugs Fixed: - http://tracker.firebirdsql.org/browse/PYFB-34 - http://tracker.firebirdsql.org/browse/PYFB-35

[11.05.2013] Jaybird 2.2.3 (Firebird JDBC) released

The Firebird JDBC team is happy to announce the release of Jaybird 2.2.3. See http://www.firebirdsql.org/en/jdbc-driver/ for the downloadlinks. The release is also available on maven: <groupId>org.firebirdsql.jdbc</groupId> <artifactId>jaybird-jdkXX</artifactId> <version>2.2.3</version> The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16 or jaybird-jdk17. The following has been changed or fixed in Jaybird 2.2.3:
  • Fixed incorrect synchronization in native and embedded protocol (JNI) implementation for iscBlobInfo and iscSeekBlob (JDBC-300)
  • Fixed holdable ResultSet is closed on auto-commit (JDBC-304, JDBC-305)
  • Fixed table names missing or padded with spaces in Database view of IntelliJ IDEA (JDBC-308, IDEA-100786)
  • Fixed incorrect JDBC minor version reported under Java 7; this resulted in an incorrect column name (for Java 7) in the metadata of DatabaseMetaData.getColumns(...) (JDBC-309)
  • Added IOException to cause of GDSException with error 335544721; "Unable to complete network request to host """ for further investigation (JDBC-306)
More details are available in the Jaybird 2.2.3 releasenotes.

[24.04.2013] CopyCat replication engine v. 3.04.0

Ladies and Gentlemen! Microtec Communications is pleased to announce a new release of CopyCat, version 3.04.0! You will find the full list of changes at the end of this email. This release also includes the changes from version 3.03.0, which had not been made publicly available till now. CopyCat is a Delphi / C++Builder component set encapsulating a database replication engine for Interbase, Firebird, MS SQL Server, MySQL and SQLite. Using CopyCat, you can replicate heterogenously between all the above database types, over various transport systems (direct DB connection, XMLRPC, or RTC), on various platforms : Delphi/MS Windows for the client side, server side implemented in Delphi, in Java, in PHP (only for MySQL) and in Objective-C on iOS (only for SQLite). CopyCat is a robust replication engine that has been in production use since 2004. Go to our site at http://www.copycat.fr to find out more! Below is the list of changes in the new release. Best regards, Jonathan Neve Microtec Communications - http://www.microtec.fr CopyCat / CopyTiger replication engine - http://www.copycat.fr

CopyCat v3.04.0 (4th of April 2013)

TCcReplicator
  • Fixed a bug whereby empty string values were sometimes changed
  • into nulls.
  • FIBPlus connector : improved recovery after connection loss : sometimes connection would not resume correctly after network error was fixed.
  • CopyCat now checks the number of rows affected by either the update or insert into the destination database and raises an error if ever neither the update nor the insert was successful.

CopyCat V3.03.0 (1st of August 2012)

  • Added support for SQLite / iOS
  • New database adaptor for SQLite
  • XMLRPC server and CopyCat transport server for iOS (written in objective-C, compatible with Delphi CopyCat XMLRPC transports.
  • Added support for Delphi / C++ Builder XE3
  • Transport layer
  • Added AutoCommit property on client transport. Setting autocommit optimizes communication by not explicitly starting nor ending transactions. This implies that the server side must automatically commit after executying every query.
  • Added property EncodeStringsAsBase64 to TCcRtcClientTransport and TCcRtcServerTransport.
  • TCcReplicator
  • Added parameters TableName and Fields to OnRowReplicated event, allowing to access the table name of the row just replicated, as well as the values of the fields transfered.
  • Added parameters ReplicateRow and AbortAndTryLater to the OnRowReplicating event. If ReplicateRow is set to false, the row is not replicated and the row is discarded from RPL$LOG. If AbortAndTryLater is set to true, replication of the row is aborted, and will be tried again next replication cycle (ie, the row is left in RPL$LOG).
  • Renamed OnAbort event OnReplicationAborted. It it called only when replication is explicitly aborted via the AbortReplication method or by setting CanContinue to false in the OnReplicationError event.
  • Added property TrimCharFields. If set to True, TCcReplicator will trim all char, varchar or memo fields that are read from the source database before replicating them to the destination database.
  • TCcConfig
  • Added multi-configuration abilities. This means that multiple replication configurations can be created for the same database, allowing separate lists of tables, replication conditions, and replication nodes to be configured independantly from each other.
  • You can now define replication configuration at design time, using the new Tables property. Double-clicking on this property allows you to define the list of tables to replicate for the current configuration (defined by the ConfigName property), along with the conditions for each, as well as the list of nodes to replicate towards (corresponding to the RPL$USERS table). You can then roll out this configuration at run time by calling the GenerateConfig property. This will create triggers for all the tables defined in your configuration, or recreate them if any of the configuration options has changed. If you want to define several replication configurations, then you need one TCcConfig instance for each configuration.
  • New IncludedFields property in the Tables list allows you to specify the list of fields to include in the replication triggers. This means that the change will only be logged for replication (in RPL$LOG) if at least one of the included fields has changed. Thus empty updates or updates of fields that are of no interest to the replication config can be excluded, thereby lightening the replication load. If no IncludedFields are set, the default is to include all fields, as before.
  • New IncludedFields property in the Tables list allows you to set a list of fields to exclude from the replication triggers. This is just a shortcut for adding all but the fields specified to the IncludedFields list.
  • New procedure RPL$FORCE_REPL allows to force replication of a certain set of rows, within the context of a certain config. This can be useful when the IncludedFields property is used.
  • Added multiple data types in order to handle all the new TDataType values. This fixes a bug that occured with some Firebird dialect 3 datatypes, when replicating over XMLRPC or RTC transports.


[24.04.2013] Database Workbench 4.4.0 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.4.0 Pro " For more information, see here.
This version includes small new features, enhancements and fixes for issues as reported by our users. Changes include:
  • improved SQL Insight
  • improved stored routine debugging
  • improved Unicode support
And much more: click here for the full list of changes in v4.4.0 The free Lite Editions will be released later. 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! If you want to promote and blog about Database Workbench, send us an e-mail for a free license.

[11.04.2013] PHP 5.5 beta3 is released and pdo_firebird.dll is re-added to builds and ready for testers

The PHP development team announces the release of the 3rd beta of PHP 5.5.0. This release fixes some bugs against beta 2. PHP 5.5.0beta3 is shipped with some bug fixes and improvements. Here is an incomplete list:
  • Drop support for bison < 2.4 when building PHP from GIT source.
  • Fixed bug #54567 (DateTimeZone serialize/unserialize)
  • Fixed bug #64555 (foreach no longer copies keys if they are interned)
  • Fixed bug #64578 (debug_backtrace in set_error_handler corrupts zend heap)
You can read the full list of changes in the NEWS file contained in the release archive. For source downloads of PHP 5.5.0beta3 please visit the download page, Windows binaries can be found on windows.php.net/qa/. Our next beta is expected for April 25th. RC should follow. Thank you for supporting PHP

[10.04.2013] isql documentation update

The manual for isql has been hugely updated, tidied up and is now online at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql.html for the html and at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-isql.pdf for the pdf version. If you get an older version that document 0.5 then the cache needs to be flushed. It's still not fully complete, but it's a lot further down the line than before. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd
Thank you Norman, for the excellent work!

[10.04.2013] Firebird Python driver FDB release 1.1 is out

FDB release 1.1 is out: http://pypi.python.org/pypi/fdb New Features: - Context Manager for transactions. Bugs Fixed: - http://tracker.firebirdsql.org/browse/PYFB-30

[07.04.2013] Database .NET 8.2 released with many new features

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. You're welcome to download the Database .NET v4 right now at: http://fishcodelib.com/Database.htm It is Free, Portable, All-In-One, Easy to Use and Multlanguage. Supported Platforms: Windows XP/2003/Vista/2008/7/8/2012 (x86/x64)

[07.04.2013] New version of FenixSQL 0.92 is released

Alessandro Batisti announced new version of FenixSQL (simple multiplatform admin tool for Firebird developed with Firebird Library and released under GPL License and produced with Lazarus ide) Code and download page is located on google code and main page is here http://fblib.altervista.org

[07.04.2013] FBLib (Firebird Pascal Library) repository has moved to Github

For years the FBLib (Firebird database library for Free Pascal, Delphi and Kylix) has lived in the 3rdParty directory tree of tiOPF. We are cleaning up the tiOPF repository, and so I have now moved the FBLib project out to Github, into its own repository. The repository history is intact. I still need to add a few more patches I have locally, and some Lazarus based support apps. All future development of FBLib will now happen on Github. To get a copy of the code: git clone git://github.com/graemeg/firebird-lib.git News via lazarus forum

[07.04.2013] Django1.5.x Firebird driver with Python 3.x support ready for testing

Maximiliano Robaina wrote about Python3 fixes for the Firebird Django driver : I just pushed up a new commit into django-firebird github repository [1] with several python 3 fixes. If anybody can test it with python 3 and report any issue, it will be appreciated. Take into account that this improvements are available into github repository, not on PyPI yet. Pull requests are welcome ;) [1] https://github.com/maxirobaina/django-firebird

[06.04.2013] IBObjects 4.9.14 Build 55 is released

Jason announced the new release :
I neglected to report that I put a new release in the download area for those still using IBO 4.9.14. I back ported a number of the recent fixes that have gone into IBO 5.0.2.
Here is the pertinent portion of the release notes. As always you can download new version from ibobjects.com site

[03.04.2013] Updated Jaybird - JDBC driver Roadmap

Mark Rotteveel wrote on Firebird-Java group : I updated the Jaybird roadmap to outline the basic plans for Jaybird 2.3. You can find it on http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=info:roadmap I will probably add more detail in the future. Mark

[01.04.2013] The Firebird Book (Second Edition) released : printed and ebooks

The Firebird Book (Second Edition) is now available as a print on demand book (at createspace) in three parts, Volume 1: Firebird Fundamentals https://www.createspace.com/4203352 Volume 2: Developing with Firebird Data https://www.createspace.com/4206843 Volume 3: Administering Firebird Servers and Databases https://www.createspace.com/4206991 Also and also in electronic format (e-book) on the Developer DVD or as an immediate download. It covers Firebird upto Firebird V2.5.x. Anybody purchasing the DVD gets a download link immediately, and the DVD is sent later as a backup hard copy, along with a lot of other useful stuff.

[29.03.2013] Avanced Data Generator 3, beta 3 released

adg3_64x64 Upscene Productions announces a new release of:
"Advanced Data Generator 3, beta 3"
This beta release includes a beta for the Firebird, MySQL and InterBase Edition.

A fast test-data generator tool that comes with a library of real-life data, can generate data into your database, XML Data Files, SQL script, CSV files, has many filling options, templates and much more.

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!

[28.03.2013] SOCI 3.2.0 released with many Firebird changes

Mateusz Loskot wrote : On behalf of the whole SOCI team I extremely pleased to announce this new release of SOCI 3.2.0 version.

[26.03.2013] Security Updates for Firebird 2.5.2 and Firebird 2.1.5 are released

The Firebird Project releases important security updates addressing a remote stack buffer overflow discovered in the Firebird Server during March, 2013. This vulnerability allows an unauthenticated user to crash the server and opens a gate for remote code execution, so it's highly recommended to upgrade your server installations. Security updates are available for Firebird 2.5.2 and Firebird 2.1.5 versions. They don't include any changes other than the bugfix for the aforementioned buffer overrun. http://www.firebirdsql.org/en/firebird-2-5/

[21.03.2013] The Lazarus team is glad to announce the release of Lazarus 1.0.8.

The Lazarus team is glad to announce the release of Lazarus 1.0.8. This is a bug fix release, built with the current fpc 2.6.2. The previous release 1.0.6 was built with 2.6.0. Here is the list of changes for Lazarus and Free Pascal: http://wiki.lazarus.freepascal.org/Lazarus_1.0_fixes_branch#Fixes_for_1.0.8 http://wiki.lazarus.freepascal.org/User_Changes_2.6.2 The release is available for download at SourceForge: http://sourceforge.net/projects/lazarus/files/ Choose your CPU, OS, distro and then the "Lazarus 1.0.8" directory. Minimum requirements: Windows: 98, 2k, XP, Vista, 7, 32 or 64bit FreeBSD/Linux: gtk 2.8 or qt4.5, 32 or 64bit Mac OS X: 10.5, LCL only 32bit, non LCL apps can be 64bit

[18.03.2013] Important #debian security fix is uploaded to sid related to CVE-2013-2492

Important Debian security fix is uploaded to sid http://packages.qa.debian.org/f/firebird2.5/news/20130318T154817Z.html You can check Firebird 2.5/2.1 packages security status for this bug CVE-2013-2492 on this page https://security-tracker.debian.org/tracker/CVE-2013-2492

[17.03.2013] German court case confirms validity of the LGPL on Firebird related project FreeadhocUDF

Buhl Data Service GmbH, the developer of the WISO Mein BüroGerman language link2009 software has agreed to pay €15,000 (approximately £13,000) to adhoc dataservice GmbH for using its LGPL-licensed FreeadhocUDF open source library in his business software without observing the LGPL's licensing terms. The GNU Lesser Public Licence allows software to be used free of charge, but it stipulates that developers must give prominent notice to where the licensed code was used, point out that the code is under the LGPL, include a copy of the LGPL, and make the library's source code available. The payment was negotiated as a settlement between the involved parties and concludes a court case. Back in January 2011, the regional court in Bochum, Germany, had ruledGerman language linkthat the use of the FreeadhocUDF library in WISO Mein Büro 2009 was not legitimate because it violated the LGPL's licensing terms. The court ruled that adhoc dataservice GmbH was, therefore, entitled to know in which products the library was used, what product quantities were released, and how much revenue was generated.   News via TheH

[15.03.2013] YiiFirebird 1.0 is marked as stable we need more volunteers for writing and doing tests

It seems that now the YiiFirebird extension is stable enough (please let me know it is not so) for merge in YiiFramework master repo. Now, the next step is to create the automated tests for this extension. Volunteers? Ideas? We need to add a "tests" directory for that purpose in our local repo before committing Yii master repo. Example: https://github.com/yiisoft/yii/blob/master/tests/framework/db/schema/CPostgresTest.php Comment on this issue  

[15.03.2013] ANN: FB TraceManager V3.0 has been released!

FBTM_V3_48x48 Upscene Productions is excited to officially release a new major version of FB TraceManager: FB TraceManager V3.0 is available!


New on-the-fly aggregated analysis capabilities on trace events (so-called "Hotspots"), improved throughput and stability, trace configuration templates and more is included in V3. For more information, check out the news item here: http://www.upscene.com/displaynews.php?item=20130315b A high-level overview on the new features is available here: http://www.upscene.com/documentation/fbtm3/index.html?whats_new_in_v3_0.htm 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



[15.03.2013] Firebird Foundation will have Annual General Meeting at March 20, 13. Join FF now

Firebird Foundation, the non-profit organization which finances Firebird development, will have Annual General Meeting (AGM) at March 20, 2013. The AGM addresses the issues that are required to continue functioning from year to year: review the finances, hear what the committee(s) have been doing, elect a new committee. This is a good moment to join Firebird Foundation as voting ($300) or associate ($50) member.

[15.03.2013] Hopper v1.2.0 - stored procedure/trigger debugger - released

Upscene Productions announces a new release of:
"Hopper - a Stored Code Debugger"
Hopper is a Stored Routine and Trigger Debugger, available for Firebird, InterBase and MySQL.

For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

Bugfixes include, but not limited to:
  • SQL errors with certain regional settings
  • some Unicode data not properly displayed
  • InterBase EXECUTE PROCEDURE always returns NULL

You like this news? Twitter it! Share it! If you'd like to blog about it, contact us!

[12.03.2013] Custom conventions in Entity Framework 6 helping Firebird – part 2

Few days ago I wrote a post “Custom conventions in Entity Framework 6 helping Firebird“.Arthur Vickers from Entity Framework team had a good question whether it works also for columns and tables that are generated by Entity Framework (like join tables for M:N, FK columns (if not in model), etc.). And it actually does not. :) For this you have to dig a little bit deeper and use model-based convention.

[12.03.2013] Security Updates available for Mageia 2 and Cauldron

New Firebird packages that fix security bug #9322 in Mageia are available for Mageia 2 and Cauldron

[12.03.2013] Firebird security fixes pushed to Fedora and EPEL 5,6

An important security fix for Firebird is pushed to Fedora and EPEL Please update your servers. Here is how the patch looks if you want to apply to other Linux distros    

[12.03.2013] Daily Firebird builds and tests results

You can watch the for Daily Firebird builds and tests suite results created on a Ubuntu 12.04 LTS http://ci.ibphoenix.fr/ There are results for G++ compiler warnings Also the console output can be consulted for the running and finished QA tests

[08.03.2013] Firebird RDBMS bindings for Python FDB 1.0 is released

FDB release 1.0 is out: http://pypi.python.org/pypi/fdb Improvements: - Removed dependency on presence of fbclient library at import time. This caused some confusion to new users when fdb install failed when Firebird was not (yet) installed. Bugs Fixed: - http://tracker.firebirdsql.org/browse/PYFB-25

[05.03.2013] And, in case you wonder, IB Objects works great in Lazarus

Here is the comment from Jason Wharton on FreePascal 2.6.2 release news
And, in case you wonder, IB Objects works great in Lazarus.


[02.03.2013] Jaybird wiki content is updated

Mark Rotteveel mentioned he is updating the content for the JDBC Driver wiki
I started updating the #Jaybird wiki on http://jaybirdwiki.firebirdsql.org/ #firebird


[28.02.2013] New implementation for wire protocol in Jaybird and all drivers need a faster wire protocol

Mark Rotteveel wrote on twitter about the Jaybird improvement:
Writing a new implementation of the wire protocol in Jaybird. I fear it is going to cascade into a total rewrite of the driver
Jiri chatted later:
IMO the whole "communication layer" needs redesign. It's (way) too legacy.
And later on the twitter channel Brent Rowland wrote:
Contemplating creating a new wire protocol. Stop me now... I have a replication system for Firebird I need to extend across a WAN. Firebird has no built-in replication and the protocol is chatty.
Editor:All these conversations are around Firebird 2.5.x protocol , there is work conducted by Dmitry Yemanov on improving the Firebird 3.x protocol

[27.02.2013] FreePascal 2.6.2 is released

FPC 2.6.2 has landed. FPC 2.6.2 is an update to 2.6.0 that contains most library progress over the 2.6.0 and some crucial compiler fixes. Building is still in progress and some formats (deb,rpm) and targets might not be available yet. Changes that may break backwards compatibility are documented at: http://wiki.freepascal.org/User_Changes_2.6.2 For Downloads, please use sourceforge https://sourceforge.net/projects/freepascal/files/ Enjoy! The Free Pascal Compiler Team News via Lazarus Forum

[22.02.2013] Firebird mentioned on Evans Data survey

A new survey from EvansData about Software Development Tools mentions Firebird among the preferred Database choices. You can participate in the survey (and win points to trade for prizes later) accessing http://surveys.evansdata.com/20130220.php

[21.02.2013] Django Firebird driver now available for install from pypi. Just run: pip install django-firebird #django

Django Firebird driver is now available from pypi https://pypi.python.org/pypi/django-firebird This was announced on twitter by Maximiliano Robaina django unchained

[21.02.2013] New maintainer for the SOCI Firebird SQL project (The C++ Database Access Library)

Here is the tweet with announcement: Just added Viacheslav Naydenov to SOCI team as new maintainer of FirebirdSQL backend to be (re)released with SOCI 3.2.0 and 4.0.0 Originally, SOCI was developed by Maciej Sobczak at CERN as abstraction layer for Oracle, a Simple Oracle Call Interface. Later, several database backends have been developed for SOCI, thus the long name has lost its practicality. Currently, if you like, SOCI may stand for Simple Open (Database) Call Interface or something similar. GitHub hosts SOCI source code repository, issues tracker and wiki: https://github.com/SOCI Project website at http://soci.sourceforge.net Release downloads and mailing lists at http://sourceforge.net/projects/soci/ Travis CI service at https://travis-ci.org/SOCI/soci Build Status  

[21.02.2013] LuaSQL Firebird is a simple interface from Lua to Firebird RDBMS

LuaSQL is a simple interface from Lua to a RDBMS , Here is the Github page for Firebird driver

[20.02.2013] Database .NET 7.9 released

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. It is Free, Portable, All-In-One, Easy to Use and Multlanguage. A lot of new features and improvements since 7.6.4741. You're welcome to download the Database .NET v4 right now at: http://fishcodelib.com/Database.htm Supported Platforms: Windows XP/2003/Vista/2008/7/8/2012 (x86/x64)

[19.02.2013] I'ved created an RSS aggregation site for Object Pascal related blogs

Mosh Choen wrote on Google Plus Lazarus Community page : I have created an RSS aggregation site for Object Pascal related blogs: http://planet.objpas.org/ This is a test run, and the look and feel will be changed in the feature. If you have a blog or can provide RSS for FPC/Lazarus news please send me a message with the feed details and I'll add you. ps:FirebirdNews.org is agregated to the planet

[19.02.2013] New Firebird / IB Expert Version 2013.02.18 available

New Firebird/IB Expert Version 2013.02.18 available New features include:
 
  1. Database Statistics: you can now get statistics for specified tables only.
  2. Code Editors: format selected text using the Editor’s context menu.
  3. Database Login Form/Database Backup/Restore: new Prevent database/transaction triggers from firing option.
  4. IBEBlock: NoDBTriggers option implemented.
  5. A few minor bug fixes and small improvements.


[17.02.2013] New version of gbak scheduler

Hi, If anyone is interested ... new version of Gbak Scheduler has been uploaded to the site https://sites.google.com/site/gbakscheduler/ What is new in version 1.0.11:
  • Added per-task option to use Service Manager when performing backup.
  • Added per-task option to run actions (custom programs or scripts) before and after execution of backup.
  • Adden per-task option for sending an email with error details when there is an error in executing backup task.
About Gbak Scheduler: GBAK Scheduler is an Interbase / Firebird backup utility that performs regular database backups with a user defined strategy. It is Windows service application. It has been in use since 1997. Best regards, Simon


[16.02.2013] SplendidCRM 7 on FirebirdSQL demo pages and changes

The new version for SplendidCRM 7 is out , The official announcemend is visible here: More than 880 changes in the structure of MSSQL database have been made ​​on the version of SplendidCRM 7 on Firebird . The debug version of Firebird SplendidCRM 7 is visible at: http://zeos7.tetrasys.eu Always with the user name "user" and the password "user" The original article is here

[15.02.2013] Android port of the Firebird Jdbc driver (Jaybird) 2.2.2 is released

New version for Android Jaybird is released This is a port of the Firebird Jdbc driver (Jaybird) You can check what is new in Jaybird 2.2.2 from the official announcement page

[13.02.2013] ANN: AnySQL Maestro 13.2 released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro 13.2, 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 introduces enhanced data management abilities, advanced SQL Dump wizard, updated SQL Editor and other new features (full press release).

[11.02.2013] ActiveRecord Firebird Adapter 0.7.5 for Rails 3.x is released

Here is the gem url https://rubygems.org/gems/activerecord-fb-adapter And here is the full commits changelog : Fix inserting boolean values. Bring gem tasks up to date.  

[09.02.2013] SplendidCRM on FirebirdSQL demo page and Database structure

SplendidCRM (version C# of SugarCRM) is ported from MSSQL over to FirebirdSQL 2.5.2 It is in a “testable” debug version on this url http://zeos.tetrasys.eu username : user password : user This changes from the usual will/will :-) It is the “community” version and I would like to have your feedback on their added value in a CRM, before carrying over the enterprise modules. Two precision/information points: 1) One is on a small DSL in Finland, so your GSM has more disponibility and bandwidth 2) the data structure is available for viewing here http://blog.tetrasys.eu/zeos-firebirdsql-structure.aspx Your comments are welcome :-) http://www.linkedin.com/groups/SplendidCRM-on-FirebirdSQL-2078215.S.212283698 I will add one more comment from the Firebird porter : Thanks to Firebird, the memory and processing space has been reduced with two thirds when migrated from MSSQL to FirebirdSQL. Why don’t everybody switch over to Firebird? :-)  

[08.02.2013] ZeosLib 7.0.3 stable for Delphi/Lazarus is released

Stable version of zeoslib 7 is released. The most important improvement you'll find in this version is support for the compilers Delphi2009 and newer, with their unicode strings. Other changes in this release are - Some new components for grouping connections (alpha status) - Postgres event alerter component comparable with the existing Interbase/Firebird event alerter (alpha status) - Pooled connections (alpha status) - Real prepared statement support (always for firebird, on demand for mysql and postgres), allowing to prepare queries once and execute them multipe times with different input variables. - New FreeTDS driver for connections to Mssql and Sybase that can replace the old dblib protocol. - TZStoredproc got a full makeover. Now Stored procedures should work for postgres, firebird, mysql, mssql and oracle (alpha status) - A load of bugs have been fixed. Downloads of the new beta release can be found on sourceforge or our mirror download directory http://zeosdownloads.firmos.at/downloads/

[08.02.2013] New IBExpertBenchmark tool: Compare your db server performance on different hardware, OS's and Firebird server version

Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs? Is SuperClassic really better than Superserver? We’ve created a new tool which offers a reproducible speed index for your computer working as a Firebird Server: IBExpertBenchmark

[07.02.2013] IBX for Lazarus (Firebird Express) Release 1.0.3 is now available for Download with minor changes

Here is the IBX Change Log for version 1.0.3: 1. Conditional compilation used to limit registration of TIntegerField to Lazarus versions less than 1.1 2. When a database connection is created, character set is now by default set to UTF8 (Unix) or to the current Windows code page (Windows) if in the range 1250 to 1254.

[06.02.2013] My First Firebird and Python application

Ido Kanner (ik_5) wrote on his blog about his First Firebird and Python application : It's that time of the year again – I'm required to learn new technology due to a project requirement. The requirement is to write something using django, but I do not know django or Python. So I've started my first project using the Python language, just to have a feel for it.

[06.02.2013] Firebird Adapter for Yii will be added to the main Framework repository

Firebird Adapter for Yii will be merged to the main Framework repository after it will reach version 1.0 Final You can check the various changes from previous versions in the Extension master branch

[06.02.2013] Idiorm and Paris 1.3.0 released - the minimalist ORM and fluent query builder for PHP

This version does include Firebird support as we mentioned before

[05.02.2013] Do we have a little firebird community here on /r/node? (Reddit node.js subreddit)

If so, I'm sure the rest of us would love to hear about you guys and what you're building with Node.js and Firebird Maybe is time to start a google+ community/group , I know we have a great delphi/pascal community maybe is time to grow a Server Side JavaScript community in the Old Delphi Jedi spirit

[04.02.2013] Jaybird 2.2.2 Released

The Firebird JDBC team is happy to announce the release of Jaybird 2.2.2. See http://www.firebirdsql.org/en/jdbc-driver/ for the downloadlinks. The release is also available on maven: <groupId>org.firebirdsql.jdbc</groupId> <artifactId>jaybird-jdkXX</artifactId> <version>2.2.2</version> The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16 or jaybird-jdk17 The following has been changed or fixed in Jaybird 2.2.2:
  • Fixed: FBMaintenanceManager.listLimboTransactions() reports incorrect transaction id when the result contains multi-site transactions in limbo (JDBC-266)
  • Fixed: Calling PreparedStatement.setClob(int, Clob) with a non-Firebird Clob (eg like Hibernate does) or calling PreparedStatement.setClob(int, Reader) throws FBSQLException: “You can't start before the beginning of the blob” (JDBC-281)
  • Fixed: Connection property types not properly processed from isc_dpb_types.properties (JDBC-284)
  • Fixed: JNI implementation of parameter buffer writes incorrect integers (JDBC-285, JDBC-286)
  • Changed: Throw SQLException when calling execute, executeQuery, executeUpdate and addBatch methods accepting a query string on a PreparedStatement or CallableStatement as required by JDBC 4.0 (JDBC-288) NOTE: Be aware that this change can break existing code if you depended on the old, non-standard behavior! With addBatch(String) the old behavior lead to a memory leak and unexpected results.
  • Fixed: LIKE escape character JDBC escape ({escape '<char>'}) doesn't work (JDBC-290)
  • Added: Support for a connect timeout using connection property connectTimeout. This property can be specified in the JDBC URL or Properties object or on the DataSource. If the connectTimeout property is not specified, the general DriverManager property loginTimeout is used. The value is the timeout in seconds. (JDBC-295) For the Java wire protocol the connect timeout will detect unreachable hosts. In the JNI implementation (native protocol) the connect timeout works as the DPB item isc_dpb_connect_timeout which only works after connecting to the server for the op_accept phase of the protocol. This means that – for the native protocol – the connect timeout will not detect unreachable hosts within the timeout. As that might be unexpected, an SQLWarning is added to the connection if the property is specified with the native protocol.
  • As part of the connect timeout change, hostname handling (if the hostname is an IP-address) in the Java wire protocol was changed. This should not have an impact in recent Java versions, but on older Java versions (Java 5 up to update 5) this might result in a delay in connecting using an IP-address, if that address can't be reverse-resolved to a hostname. Workaround is to add an entry for that IP-address to the /etc/hosts or %WINDIR%\System32\Drivers\etc\hosts file.


[04.02.2013] Lazarus 1.0.6 release available for download

The Lazarus team is glad to announce the release of Lazarus 1.0.6.

[04.02.2013] Database Workbench 4.3.2 free Lite Editions released

Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.3.2 Lite " For more information, see here.
Database Workbench Pro 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 ) The Lite Editions are available for: - InterBase - Firebird - MySQL You like this news? Twitter it! Share it! Blog about it!

[04.02.2013] Jaybird 2.2.2 Firebird JDBC driver is released

News via Mark Rotteveel tweet I just released Jaybird 2.2.2 newsitem and maven artifacts should appear in a day or so Update: NewsItem apeared on the main site also on FirebirdNews

[01.02.2013] Announcement : AsGUID deprecated in UIB Delphi / Lazarus components replaced by AsUIID

Pierre Yager announced : Hey, Firebird and UIB users : I will deprecate AsGUID[] cause it's buggy. I will replace it by AsUUID[] conform to FB2.5 and UUID specs. Here is the change in SVN.

[01.02.2013] Reminder : Vote for Firebird as Database of the Year 2012 at LinuxQuestions

Vote for Firebird as Database of the Year 2012 at LinuxQuestions (must be registered user with at least one post) http://www.linuxquestions.org/questions/2012-linuxquestions-org-members-choice-awards-104/database-of-the-year-4175441847/ Only 2 days left before the polls close. Please cast your vote if you haven't done so already. Paul Vinkenoog on Firebird Generals list

Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2013, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.