Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

Newsletter
September 11, 2019

This year Firebird Conference  (October 17-19, Berlin) is devoted to the Firebird 4 features (in Day 1) and to the advanced performance and development topics (Day 2-3).
The special focus of the conference is the very big databases.
The speakers are Firebird core and driver developers and industry experts from IBSurgeon, IBExpert, RedSoft, and IBPhoenix.

The detailed schedule is available here: https://firebirdsql.org/en/firebird-conference-2019/

This year Firebird Conference  (October 17-19, Berlin) is devoted to the Firebird 4 features (in Day 1) and to the advanced performance and development topics (Day 2-3).
The special focus of the conference is the very big databases.
The speakers are Firebird core and driver developers and industry experts from IBSurgeon, IBExpert, RedSoft, and IBPhoenix.

The detailed schedule is available here: https://firebirdsql.org/en/firebird-conference-2019/
June 13, 2019
The 16th Firebird Developers Day (FDD) will take place in Piracicaba-SP, Brazil, in August, 3.
Registrations are open at 
www.FirebirdDevelopersDay.com.br.

FDD is the biggest Firebird Conference in the world (in number of attendees). All Portuguese speakers are invited to visit the new conference site, check the topics and register!

Several tools and components will be sold with very special discounts during the conference day, offered by our sponsors and supporters like IBSurgeon, FastReports, IBObjects, IBExpert, ACBr, uniGUI, TeeChart, Woll2Woll and Gnostice.

Among the Brazilians specialists are Carlos Cantu, author of three Firebird books, including the Migration Guide to Firebird 3, and Alexey Kovyazin (IBSurgeon) as a special international speaker.

Here is a list of the (already) confirmed sessions:

 
  • What to do when your customer's database gets bigger (Carlos Cantu)
  • Developing nTier systems accessing Firebird  (Marcelo Daibert)
  • Developing OO software with Firebird  (Marcelo Daibert)
  • Understanding transactions control and deadlocks  (Alexandre B. Smith)
  • FB 4 - Changes in garbage collection and isolations (Alexandre B. Smith)
  • HQBird 2019 - Even more powerful! (Alexey Kovyazin)
  • How to optimize slow queries (Alexey Kovyazin)
  • Creating your first dashboard in the clould (Wagner Ramos)


More sessions will be added soon.

Friday 14, June is the last day to register for the conference before the price grows. Hurry up, save money and guarantee your seat at the conference!


--- IN PORTUGUESE

Sexta-feira, dia 14/Junho, é o último dia para se inscrever para o 16º FDD pelo menor valor, antes que o preço suba! O Firebird Developers Day é o maior evento sobre banco de dados Firebird no mundo (em número de participantes), e será realizado em Piracicaba-SP, no dia 03 de Agosto.

Entre os palestrantes estão Carlos H. Cantu, autor de 3 livros sobre Firebird, além da presença internacional de Alexey Kovyazin, especialista em otimização e recuperação de bases de dados Firebird.

Veja abaixo as palestras que já estão confirmadas:
  • A base cresceu, e agora?! (Carlos Cantu)
  • Sistemas Multicamadas usando o Firebird (Marcelo Daibert)
  • Desenvolvimento de Software OO com o Firebird (Marcelo Daibert)
  • Controle transacional e deadlocks (Alexandre B. Smith)
  • FB 4 - Mudanças na coleta de lixo e isolamento transactional (Alexandre B. Smith)
  • HQBird 2019 - Ainda mais turbinado! (Alexey Kovyazin)
  • Como otimizar queries lentas (Alexey Kovyazin)
  • Criando seu primeiro dashboard na nuvem (Wagner Ramos)
Mais palestras serão adicionadas nos próximos dias...

Vale lembrar que vários softwares da IBSurgeon, FastReports, IBExpert, UniGUI, IBObjects, e componentes da Steema/TeeChart, Woll2Woll e da Gnostice estarão sendo vendidos com descontos super especiais, somente para os participantes do FDD, sendo uma ótima oportunidade pra registra-los ou renovar licenças. Veja a página de 
descontos para saber o quanto você poderá economizar!

Aproveite o preço mais baixo e faça sua inscrição, garantindo sua vaga e economizando!

Visite agora mesmo o site 
www.FirebirdDevelopersDay.com.br para saber todas as informações sobre a conferência.
The 16th Firebird Developers Day (FDD) will take place in Piracicaba-SP, Brazil, in August, 3.
Registrations are open at 
www.FirebirdDevelopersDay.com.br.

FDD is the biggest Firebird Conference in the world (in number of attendees). All Portuguese speakers are invited to visit the new conference site, check the topics and register!

Several tools and components will be sold with very special discounts during the conference day, offered by our sponsors and supporters like IBSurgeon, FastReports, IBObjects, IBExpert, ACBr, uniGUI, TeeChart, Woll2Woll and Gnostice.

Among the Brazilians specialists are Carlos Cantu, author of three Firebird books, including the Migration Guide to Firebird 3, and Alexey Kovyazin (IBSurgeon) as a special international speaker.

Here is a list of the (already) confirmed sessions:

 
  • What to do when your customer's database gets bigger (Carlos Cantu)
  • Developing nTier systems accessing Firebird  (Marcelo Daibert)
  • Developing OO software with Firebird  (Marcelo Daibert)
  • Understanding transactions control and deadlocks  (Alexandre B. Smith)
  • FB 4 - Changes in garbage collection and isolations (Alexandre B. Smith)
  • HQBird 2019 - Even more powerful! (Alexey Kovyazin)
  • How to optimize slow queries (Alexey Kovyazin)
  • Creating your first dashboard in the clould (Wagner Ramos)


More sessions will be added soon.

Friday 14, June is the last day to register for the conference before the price grows. Hurry up, save money and guarantee your seat at the conference!


--- IN PORTUGUESE

Sexta-feira, dia 14/Junho, é o último dia para se inscrever para o 16º FDD pelo menor valor, antes que o preço suba! O Firebird Developers Day é o maior evento sobre banco de dados Firebird no mundo (em número de participantes), e será realizado em Piracicaba-SP, no dia 03 de Agosto.

Entre os palestrantes estão Carlos H. Cantu, autor de 3 livros sobre Firebird, além da presença internacional de Alexey Kovyazin, especialista em otimização e recuperação de bases de dados Firebird.

Veja abaixo as palestras que já estão confirmadas:
  • A base cresceu, e agora?! (Carlos Cantu)
  • Sistemas Multicamadas usando o Firebird (Marcelo Daibert)
  • Desenvolvimento de Software OO com o Firebird (Marcelo Daibert)
  • Controle transacional e deadlocks (Alexandre B. Smith)
  • FB 4 - Mudanças na coleta de lixo e isolamento transactional (Alexandre B. Smith)
  • HQBird 2019 - Ainda mais turbinado! (Alexey Kovyazin)
  • Como otimizar queries lentas (Alexey Kovyazin)
  • Criando seu primeiro dashboard na nuvem (Wagner Ramos)
Mais palestras serão adicionadas nos próximos dias...

Vale lembrar que vários softwares da IBSurgeon, FastReports, IBExpert, UniGUI, IBObjects, e componentes da Steema/TeeChart, Woll2Woll e da Gnostice estarão sendo vendidos com descontos super especiais, somente para os participantes do FDD, sendo uma ótima oportunidade pra registra-los ou renovar licenças. Veja a página de 
descontos para saber o quanto você poderá economizar!

Aproveite o preço mais baixo e faça sua inscrição, garantindo sua vaga e economizando!

Visite agora mesmo o site 
www.FirebirdDevelopersDay.com.br para saber todas as informações sobre a conferência.
May 02, 2017
During 2015-2016 the Moscow Exchange and IBSurgeon sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format.  The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x).  The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year.

The Firebird Project's 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project's documentation library.  For this project, as ever, we need funding.  This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign.

Please visit crowdfunding page and donate: https://www.firebirdsql.org/en/doc-funding-2017/

 
 
     
 

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

[02.05.2017] Move to Firebird 3, easily and with no headaches

Firebird 3 is the fastest and more secure version of Firebird up to date. Anyone using older versions of Firebird should migrate to Firebird 3 to benefit from its new features, like full SMP support, improved network protocol, improved security, encrypted wire protocol, local user management, etc. Moving to Firebird 3 will require more attention than usual, due to the inumerous changes introduced in this version, but instead of spending hours reading documentation and trying to figure things out by yourself, you can save a lot of time buying the Migration Guide to Firebird 3, available in PDF and printed formats, in English and Portuguese.

[02.05.2017] FirstAID 5.0: Firebird 3.0 and InterBase XE7 and support of 100+Gb databases

We are proud to present IBSurgeon FirstAID 5.0 - the new version of the recovery software with the highest rate of successful repairs. FirstAID 5.0 is a major improvement: now it supports Firebird 3.0, InterBase XE7, and big databases (100Gb+). Download IBSurgeon FirstAID 5.0 If you are a user of FirstAID version 3.x or 4.x, you can log into IBSurgeon Deploy Center and see that you were automatically upgraded to version 5.0. All your licenses were transferred to 5.0. IBSurgeon FirstAID 5.0 -50% upgrade offer till May 15 If you have the license for FirstAID version 1.x or 2.x (including Pack 3.x), or if you have used all licenses for 3.x/4.x, we would like to offer you 50% discount to upgrade to FirstAID 5.0 Tech Support (for 50 databases) for the special price: USD$99. This is a limited offer till May 15 only! Upgrade Now!

[29.04.2017] FB Documentation Crowdfunding campaign

Goal: Translate & Publish Firebird Developer Guide During 2015-2016 IBSurgeon and the Moscow Exchange sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format. The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x). The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year. The Firebird Project's 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project's documentation library. For this project, as ever, we need funding. This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign. To donate, go to here and click the donate button.

[26.04.2017] Railsconf 2017 Phoenix - you can contact Brent Rowland (Firebird ActiveRecord driver maintainer)

If you are at the Railsconf 2017 you can contact Brent Rowland (Firebird ActiveRecord driver maintainer).

If you're at #railsconf and use @firebirdsql, look me up!

— Brent Rowland (@brentrowland) April 25, 2017
 

[25.04.2017] django-firebird 1.8.2 is released

This release fixes a few bugs :
  • Delete ForeignKey field fails (-607) if column is referenced in index #70
  • Database Introspection doesn't return correctly field_length value from get_table_description #71
https://pypi.python.org/pypi/django-firebird/1.8.2

[19.04.2017] Database Workbench 5.3 released

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool: " Database Workbench 5.3.0 " This release includes a custom report writer, increased PostgreSQL support and a renewed stored routine debugger including full support for Firebird 3 Stored Functions and Packages. [gallery ids="10474,10475,10476"] The change logs for version 5.3.0 is available.
"There is so much new in Database Workbench 5, and the latest version includes the long awaited PostgreSQL support", says Martijn Tonies, founder of Upscene Productions. "There's a custom report writer, new code editor features, diagramming improvements, multiple editions, fully HiDPI awareness, data compare tool, more complete visual query builder and much more."
New features in version 5 include:
  • Support for PostgreSQL
  • Support for the latest versions of database engines including Firebird 3, SQL Anywhere 17, SQL Azure and MariaDB support
  • Custom report writer
  • New and improved user interface
  • Code editor features like block staples, code folding, object linking and dynamic highlighting
  • "Diagram Navigator" for easier diagramming navigation
  • MySQL/MariaDB tunneling support
  • New tools, including a Data Compare tool
  • Basic and Pro Edition to suit your needs
  • and much more...
For more information, see What's new in Database Workbench 5? Database Workbench supports MySQL, MariaDB, PostgreSQL, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

[18.04.2017] Generating a script for FirebirdSQL from MySQLWorkbench

MySQLWorkbench allows to design database model easily and also provides an option to generate the SQL script. By default script is generated for MySQL, but, what if you need to generate a SQL script for FirebirdSQL? Here is the solution via python plugin

[16.04.2017] Database .NET 21.5 and dbMigration .NET 5.3 released!

Database .NET 21.5 is an innovative, powerful and intuitive multiple database management tool. (Full support for Firebird 1.5~3.0+) http://fishcodelib.com/Database.htm (Change Log 2017/04/17)
dbMigration .NET 5.3 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa. http://fishcodelib.com/DBMigration.htm (Change Log 2017/04/17)
  • Updated to FirebirdSql.Data.FirebirdClient.dll 5.8.1.0
  • 30~50% performance improvement for Data Import, Export and Migration
  • Better support for windows display scaling
  • Added support for PSQL Stored Functions (FB3)
  • Fixed support for Firebird Embedded
  • Fixed CHECK Constraints for Firebird
  • Compatible with Microsoft Windows 10 RedStone 2 (1703)
 

[15.04.2017] Release of IBProvider v3.40

Hello everyone! We are pleased to announce the new update of IBProvider – v3.40. There are not a lot of changes in this release. However, it was very well tested. Including with a our new connection pool, which we will present in a month. Full news text: http://www.ibprovider.com/eng/news/n_170415.html

[10.04.2017] FB 3 for Android is out!

Finally the Firebird 3 version for Android was made available for download in the official site. Please note that since this version wasn't widely tested, you must consider it as experimental. If you find any problems, please report it to the developers mailing list.

[07.04.2017] django-firebird 1.8.1 is released

This release fixes a regression bug in django-firebird 1.8 : DecimalField value is not converted correctly #69 https://pypi.python.org/pypi/django-firebird/1.8.1

[07.04.2017] LibreOffice 5.3.2 is now available

LibreOffice 5.3.2 is now available, and includes over 50 fixes and improvements since the previous release

[05.04.2017] Firebird high-level native client for Node.js / TypeScript updated

Firebird high-level native client for Node.js / TypeScript updated to v0.0.1-alpha.2 with a few changes : Remove debug module incompatible with Windows build. (Now it can be builded on Windows) Update TypeScript compiler.

[05.04.2017] ADO.NET provider 5.8.1.0 for Firebird is ready

More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/

[31.03.2017] Debian bug fixed : CVE-2017-6369: authenticated remote execution in firebird 2.5 before version 3.0.2

We believe that the bug you reported is fixed in the latest version of firebird3.0, which is due to be installed in the Debian FTP archive.
 * Apply commit 56e9a73c168 from upstream B3_0_Release branch
    fixing authenticated remote execution vulnerability (CVE-2017-6369,
    CORE-5474)
    Closes: #858644
Forwarded: http://tracker.firebirdsql.org/browse/CORE-5474 Authenticated Firebird users are allowed to declare UDFs (user-defined functions). The default config allows using all entry points from the standard UDF library, which is dynamically linked with libc, with its symbols re-exported, including system(). Relevant upstream commits for 3.0: - https://github.com/FirebirdSQL/firebird/commit/8b2a9cb44bf6055e15f016d70a6842b8ada60375

[29.03.2017] Firebird 3 high-level native client for Node.js / TypeScript

Adriano dos Santos Fernandes created and announced a new Firebird 3 high-level native client for Node.js / TypeScript

[27.03.2017] Real-time Firebird - Monitor for Firebird - Server 2.5 / 3.0

A new version is available V1.3.7.86 Visit our Homepage and download the Trialversion: http://www.gksoft.ch/fbmonitor

[27.03.2017] Update Available: Android Firebird JDBC Driver Jaybird 2.2.12

Android Firebird JDBC Driver Jaybird 2.2.12 is updated for Android Studio Christian Mayer wrote on Android Jaybird discussion forum
Hi Toni, i have updated the example in the download area. Basically you have to go to File -> Project Structure and klick the green add sign in the upper left. Then choose "Import .JAR/.AAR Package" and select the aar file. After that in the group area select app and go to Dependencies. Here klick the green add sign in the upper right a choose "Module Dependencies" If that doesn't work please use the provided example.
Ps: It's compiled as Android-Library : AAR . You can use it like this: https://developer.android.com/studio/projects/android-library.html#AddDependency or this: http://docs.onemobilesdk.aol.com/android-ad-sdk/adding-aar-files.html

[23.03.2017] Firebird 3.x Build instructions on MacOS

Paul Beach added a few notes on building Firebird 3.x on MacOS

[22.03.2017] Firebird 3.02 is out!

Firebird Project is happy to announce general availability of Firebird 3.0.2 — the second point release in the Firebird 3.0 series. This sub-release offers many bug fixes (including fix for a recently reported security vulnerability) and also adds a few minor features and improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows and Linux on both 32-bit and 64-bit platforms are immediately available for download.
Not using Firebird 3 yet? Get the Migration Guide to Firebird 3 and save you a lot of time in the migration process!

[16.03.2017] Release of IBProvider v3.39

Hello everyone! A new version of IBProvider (native OLE DB provider for Firebird and InterBase) has been released. Short list of changes
  1. Added binaries compiled in Visual Studio 2017
  2. Fixed bug in SRP-authentication (FB3, connection type — fb.direct)
  3. Improved error handling.
Full news text: http://www.ibprovider.com/eng/news/n_170316.html

[10.03.2017] dbMigration .NET v5 released

dbMigration .NET 5.0 is a simple, easy and intuitive multiple database migration and data synchronization tool. With it you can easily migrate schema and data to Firebird and vice versa without complicated procedures. Please refer to the release notes for the full list of changes. http://fishcodelib.com/DBMigration.htm

[09.03.2017] Release of IBProvider v3.38 [Native OLE DB for IB/FB]

Hello everyone! We follow to rule "sequence of small improvements is prefered" and glad to announce the third update of IBProvider in current year - v3.38. Main In new release we resolved the problems with notifications of asynchronous loader of data, which were detected under stress-test. Full news text: http://www.ibprovider.com/eng/news/n_170309.html Regards, IBProvider Team.

[06.03.2017] Firebird Pascal Client API 1.0.2 is now available for both FPC and Delphi

MWA Software's Firebird Pascal Client API package (fbintf) release 1.0.2 is now available for download. The package has been updated to support Delphi Win32 (from Delphi 2010 onwards) in addition to the Free Pascal Compiler (3.0.0 onwards). The package is otherwise functionally identical to release 1.0.1. The Firebird Pascal Client API package provides common Pascal language bindings to the Firebird API that are independent of the Firebird API version. Both legacy and Firebird 3 APIs are supported. The fbintf package provides the Firebird API in a format where all data types for SQL data, interface parameters and results are native Pascal types, including all parameter blocks and database information. The Pascal API is pitched at a similar level and purpose to the IBPP Firebird API provided to the C++ world. It is a required dependency for version 2 onwards of IBX for Lazarus, and is provided as both a standalone package and as part of IBX2. The Firebird Pascal API is intended to be simple to use and to place the minimum burden on the API user when it comes to managing the Firebird client library and the various Pascal objects that are created to provide the API. It is implemented as reference counted COM interfaces which, for the API user, are as easy to use as other managed types such as AnsiStrings and dynamic arrays. The user only needs to worry about accessing and using the interface; disposing of interfaces is performed automatically whenever an interface goes out of scope. It is intended to be a full implementation of the Firebird API, including events, services, blobs and arrays. It is distributed under the IDP Licence. The package may be downloaded from https://www.mwasoftware.co.uk/fb-pascal-api A comprehensive user manual fully describing the API is available from https://www.mwasoftware.co.uk/documentation

[06.03.2017] Jaybird 3.0.0-beta-3 is available for download and testing.

Jaybird 3.0.0-beta-3 is available for download and testing. More in formation can be found in the full release notes.

Jaybird 3.0.0-beta-3 is expected to be the last test release before the final Jaybird 3.0.0 release.

— Mark Rotteveel (@Avalanche1979) March 5, 2017
 

[01.03.2017] FirebirdNews site revamped

Hello! I'm pleased to announce that FirebirdNews site now uses a modern adaptive theme, meaning that it will display correctly in several screen sizes, including mobile devices like smartphones and tablets. Enjoy! Carlos H. Cantu

[01.03.2017] Firebird encryption plugin and sources of client application

IBSurgeon has released the complete trial kit for Firebird encryption, which includes fully functional time-limited AES256 encryption plugin and demo application (in Delphi) to demonstrate how to connect to the encrypted database. The trial kit is designed for the following: 1) Easy performance testing of the existing databases with the encryption: you can encrypt database on the server and test your existing applications without changing them. 2) Implement client-side security: there is a simple example of Delphi application (sources included) which demonstrates how to send the key from the client to the server. Download Firebird encryption plugin and example of a client application.
 
     
 
During 2015-2016 the Moscow Exchange and IBSurgeon sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format.  The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x).  The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year.

The Firebird Project's 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project's documentation library.  For this project, as ever, we need funding.  This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign.

Please visit crowdfunding page and donate: https://www.firebirdsql.org/en/doc-funding-2017/

 
 
     
 

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

[02.05.2017] Move to Firebird 3, easily and with no headaches

Firebird 3 is the fastest and more secure version of Firebird up to date. Anyone using older versions of Firebird should migrate to Firebird 3 to benefit from its new features, like full SMP support, improved network protocol, improved security, encrypted wire protocol, local user management, etc. Moving to Firebird 3 will require more attention than usual, due to the inumerous changes introduced in this version, but instead of spending hours reading documentation and trying to figure things out by yourself, you can save a lot of time buying the Migration Guide to Firebird 3, available in PDF and printed formats, in English and Portuguese.

[02.05.2017] FirstAID 5.0: Firebird 3.0 and InterBase XE7 and support of 100+Gb databases

We are proud to present IBSurgeon FirstAID 5.0 - the new version of the recovery software with the highest rate of successful repairs. FirstAID 5.0 is a major improvement: now it supports Firebird 3.0, InterBase XE7, and big databases (100Gb+). Download IBSurgeon FirstAID 5.0 If you are a user of FirstAID version 3.x or 4.x, you can log into IBSurgeon Deploy Center and see that you were automatically upgraded to version 5.0. All your licenses were transferred to 5.0. IBSurgeon FirstAID 5.0 -50% upgrade offer till May 15 If you have the license for FirstAID version 1.x or 2.x (including Pack 3.x), or if you have used all licenses for 3.x/4.x, we would like to offer you 50% discount to upgrade to FirstAID 5.0 Tech Support (for 50 databases) for the special price: USD$99. This is a limited offer till May 15 only! Upgrade Now!

[29.04.2017] FB Documentation Crowdfunding campaign

Goal: Translate & Publish Firebird Developer Guide During 2015-2016 IBSurgeon and the Moscow Exchange sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format. The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x). The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year. The Firebird Project's 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project's documentation library. For this project, as ever, we need funding. This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign. To donate, go to here and click the donate button.

[26.04.2017] Railsconf 2017 Phoenix - you can contact Brent Rowland (Firebird ActiveRecord driver maintainer)

If you are at the Railsconf 2017 you can contact Brent Rowland (Firebird ActiveRecord driver maintainer).

If you're at #railsconf and use @firebirdsql, look me up!

— Brent Rowland (@brentrowland) April 25, 2017
 

[25.04.2017] django-firebird 1.8.2 is released

This release fixes a few bugs :
  • Delete ForeignKey field fails (-607) if column is referenced in index #70
  • Database Introspection doesn't return correctly field_length value from get_table_description #71
https://pypi.python.org/pypi/django-firebird/1.8.2

[19.04.2017] Database Workbench 5.3 released

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool: " Database Workbench 5.3.0 " This release includes a custom report writer, increased PostgreSQL support and a renewed stored routine debugger including full support for Firebird 3 Stored Functions and Packages. [gallery ids="10474,10475,10476"] The change logs for version 5.3.0 is available.
"There is so much new in Database Workbench 5, and the latest version includes the long awaited PostgreSQL support", says Martijn Tonies, founder of Upscene Productions. "There's a custom report writer, new code editor features, diagramming improvements, multiple editions, fully HiDPI awareness, data compare tool, more complete visual query builder and much more."
New features in version 5 include:
  • Support for PostgreSQL
  • Support for the latest versions of database engines including Firebird 3, SQL Anywhere 17, SQL Azure and MariaDB support
  • Custom report writer
  • New and improved user interface
  • Code editor features like block staples, code folding, object linking and dynamic highlighting
  • "Diagram Navigator" for easier diagramming navigation
  • MySQL/MariaDB tunneling support
  • New tools, including a Data Compare tool
  • Basic and Pro Edition to suit your needs
  • and much more...
For more information, see What's new in Database Workbench 5? Database Workbench supports MySQL, MariaDB, PostgreSQL, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

[18.04.2017] Generating a script for FirebirdSQL from MySQLWorkbench

MySQLWorkbench allows to design database model easily and also provides an option to generate the SQL script. By default script is generated for MySQL, but, what if you need to generate a SQL script for FirebirdSQL? Here is the solution via python plugin

[16.04.2017] Database .NET 21.5 and dbMigration .NET 5.3 released!

Database .NET 21.5 is an innovative, powerful and intuitive multiple database management tool. (Full support for Firebird 1.5~3.0+) http://fishcodelib.com/Database.htm (Change Log 2017/04/17)
dbMigration .NET 5.3 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa. http://fishcodelib.com/DBMigration.htm (Change Log 2017/04/17)
  • Updated to FirebirdSql.Data.FirebirdClient.dll 5.8.1.0
  • 30~50% performance improvement for Data Import, Export and Migration
  • Better support for windows display scaling
  • Added support for PSQL Stored Functions (FB3)
  • Fixed support for Firebird Embedded
  • Fixed CHECK Constraints for Firebird
  • Compatible with Microsoft Windows 10 RedStone 2 (1703)
 

[15.04.2017] Release of IBProvider v3.40

Hello everyone! We are pleased to announce the new update of IBProvider – v3.40. There are not a lot of changes in this release. However, it was very well tested. Including with a our new connection pool, which we will present in a month. Full news text: http://www.ibprovider.com/eng/news/n_170415.html

[10.04.2017] FB 3 for Android is out!

Finally the Firebird 3 version for Android was made available for download in the official site. Please note that since this version wasn't widely tested, you must consider it as experimental. If you find any problems, please report it to the developers mailing list.

[07.04.2017] django-firebird 1.8.1 is released

This release fixes a regression bug in django-firebird 1.8 : DecimalField value is not converted correctly #69 https://pypi.python.org/pypi/django-firebird/1.8.1

[07.04.2017] LibreOffice 5.3.2 is now available

LibreOffice 5.3.2 is now available, and includes over 50 fixes and improvements since the previous release

[05.04.2017] Firebird high-level native client for Node.js / TypeScript updated

Firebird high-level native client for Node.js / TypeScript updated to v0.0.1-alpha.2 with a few changes : Remove debug module incompatible with Windows build. (Now it can be builded on Windows) Update TypeScript compiler.

[05.04.2017] ADO.NET provider 5.8.1.0 for Firebird is ready

More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/

[31.03.2017] Debian bug fixed : CVE-2017-6369: authenticated remote execution in firebird 2.5 before version 3.0.2

We believe that the bug you reported is fixed in the latest version of firebird3.0, which is due to be installed in the Debian FTP archive.
 * Apply commit 56e9a73c168 from upstream B3_0_Release branch
    fixing authenticated remote execution vulnerability (CVE-2017-6369,
    CORE-5474)
    Closes: #858644
Forwarded: http://tracker.firebirdsql.org/browse/CORE-5474 Authenticated Firebird users are allowed to declare UDFs (user-defined functions). The default config allows using all entry points from the standard UDF library, which is dynamically linked with libc, with its symbols re-exported, including system(). Relevant upstream commits for 3.0: - https://github.com/FirebirdSQL/firebird/commit/8b2a9cb44bf6055e15f016d70a6842b8ada60375

[29.03.2017] Firebird 3 high-level native client for Node.js / TypeScript

Adriano dos Santos Fernandes created and announced a new Firebird 3 high-level native client for Node.js / TypeScript

[27.03.2017] Real-time Firebird - Monitor for Firebird - Server 2.5 / 3.0

A new version is available V1.3.7.86 Visit our Homepage and download the Trialversion: http://www.gksoft.ch/fbmonitor

[27.03.2017] Update Available: Android Firebird JDBC Driver Jaybird 2.2.12

Android Firebird JDBC Driver Jaybird 2.2.12 is updated for Android Studio Christian Mayer wrote on Android Jaybird discussion forum
Hi Toni, i have updated the example in the download area. Basically you have to go to File -> Project Structure and klick the green add sign in the upper left. Then choose "Import .JAR/.AAR Package" and select the aar file. After that in the group area select app and go to Dependencies. Here klick the green add sign in the upper right a choose "Module Dependencies" If that doesn't work please use the provided example.
Ps: It's compiled as Android-Library : AAR . You can use it like this: https://developer.android.com/studio/projects/android-library.html#AddDependency or this: http://docs.onemobilesdk.aol.com/android-ad-sdk/adding-aar-files.html

[23.03.2017] Firebird 3.x Build instructions on MacOS

Paul Beach added a few notes on building Firebird 3.x on MacOS

[22.03.2017] Firebird 3.02 is out!

Firebird Project is happy to announce general availability of Firebird 3.0.2 — the second point release in the Firebird 3.0 series. This sub-release offers many bug fixes (including fix for a recently reported security vulnerability) and also adds a few minor features and improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows and Linux on both 32-bit and 64-bit platforms are immediately available for download.
Not using Firebird 3 yet? Get the Migration Guide to Firebird 3 and save you a lot of time in the migration process!

[16.03.2017] Release of IBProvider v3.39

Hello everyone! A new version of IBProvider (native OLE DB provider for Firebird and InterBase) has been released. Short list of changes
  1. Added binaries compiled in Visual Studio 2017
  2. Fixed bug in SRP-authentication (FB3, connection type — fb.direct)
  3. Improved error handling.
Full news text: http://www.ibprovider.com/eng/news/n_170316.html

[10.03.2017] dbMigration .NET v5 released

dbMigration .NET 5.0 is a simple, easy and intuitive multiple database migration and data synchronization tool. With it you can easily migrate schema and data to Firebird and vice versa without complicated procedures. Please refer to the release notes for the full list of changes. http://fishcodelib.com/DBMigration.htm

[09.03.2017] Release of IBProvider v3.38 [Native OLE DB for IB/FB]

Hello everyone! We follow to rule "sequence of small improvements is prefered" and glad to announce the third update of IBProvider in current year - v3.38. Main In new release we resolved the problems with notifications of asynchronous loader of data, which were detected under stress-test. Full news text: http://www.ibprovider.com/eng/news/n_170309.html Regards, IBProvider Team.

[06.03.2017] Firebird Pascal Client API 1.0.2 is now available for both FPC and Delphi

MWA Software's Firebird Pascal Client API package (fbintf) release 1.0.2 is now available for download. The package has been updated to support Delphi Win32 (from Delphi 2010 onwards) in addition to the Free Pascal Compiler (3.0.0 onwards). The package is otherwise functionally identical to release 1.0.1. The Firebird Pascal Client API package provides common Pascal language bindings to the Firebird API that are independent of the Firebird API version. Both legacy and Firebird 3 APIs are supported. The fbintf package provides the Firebird API in a format where all data types for SQL data, interface parameters and results are native Pascal types, including all parameter blocks and database information. The Pascal API is pitched at a similar level and purpose to the IBPP Firebird API provided to the C++ world. It is a required dependency for version 2 onwards of IBX for Lazarus, and is provided as both a standalone package and as part of IBX2. The Firebird Pascal API is intended to be simple to use and to place the minimum burden on the API user when it comes to managing the Firebird client library and the various Pascal objects that are created to provide the API. It is implemented as reference counted COM interfaces which, for the API user, are as easy to use as other managed types such as AnsiStrings and dynamic arrays. The user only needs to worry about accessing and using the interface; disposing of interfaces is performed automatically whenever an interface goes out of scope. It is intended to be a full implementation of the Firebird API, including events, services, blobs and arrays. It is distributed under the IDP Licence. The package may be downloaded from https://www.mwasoftware.co.uk/fb-pascal-api A comprehensive user manual fully describing the API is available from https://www.mwasoftware.co.uk/documentation

[06.03.2017] Jaybird 3.0.0-beta-3 is available for download and testing.

Jaybird 3.0.0-beta-3 is available for download and testing. More in formation can be found in the full release notes.

Jaybird 3.0.0-beta-3 is expected to be the last test release before the final Jaybird 3.0.0 release.

— Mark Rotteveel (@Avalanche1979) March 5, 2017
 

[01.03.2017] FirebirdNews site revamped

Hello! I'm pleased to announce that FirebirdNews site now uses a modern adaptive theme, meaning that it will display correctly in several screen sizes, including mobile devices like smartphones and tablets. Enjoy! Carlos H. Cantu

[01.03.2017] Firebird encryption plugin and sources of client application

IBSurgeon has released the complete trial kit for Firebird encryption, which includes fully functional time-limited AES256 encryption plugin and demo application (in Delphi) to demonstrate how to connect to the encrypted database. The trial kit is designed for the following: 1) Easy performance testing of the existing databases with the encryption: you can encrypt database on the server and test your existing applications without changing them. 2) Implement client-side security: there is a simple example of Delphi application (sources included) which demonstrates how to send the key from the client to the server. Download Firebird encryption plugin and example of a client application.