Firebird 3.0.4 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.

This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.

Firebird Visual Studio 2017 builds are added to AppVeyor

Firebird Visual Studio 2017 builds are added to AppVeyor for x64 and x86 Platforms

Firebird has now automatic Windows builds with AppVeyor

Firebird has now AppVeyor CI builds, like we have them with travis, but

AppVeyor is for Windows related compilers (Visual Studio)


https://ci.appveyor.com/project/FirebirdSQL/firebird

Firebird 4.0: Time Zone feature documentation

Via Firebird-devel : Here is the first README version for the Time Zone feature in Firebird 4.0

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md

LibreOffice is now available for Haiku

LibreOffice is working and already can be installed via HaikuDepot.

Here is the full announcement

https://discuss.haiku-os.org/t/libreoffice-is-now-available-for-haiku/6917

C++ the Newest Old Language : presentation by Matt Godbolt (GOTO Chicago 2018)

This presentation was recorded at GOTO Chicago 2018 C++ is an old language only used by the unfortunate few that absolutely have to, right? Wrong! C++ is not the language it used to be: clunky, error-prone and lacking in tooling. A lot has changed in the last decade: three new language revisions, new compilers and all-new: [...] Download slides and read the full abstract here: https://gotochgo.com/2018/sessions/359

Vote for Firebird as Sourceforge Project of the month (May 2018)

Sourceforge is running a poll to elect its May’s Project of the Month, and Firebird is among the candidates.


To vote, you need to have an account (it is free to register) at sourceforge.net and go to this URL, and comment with the following line:

VOTE: firebird

Some of the few advantages of using Firebird 3.0.x is that performance was greatly improved vs 2.5.x

Here are a few related performance/tunning articles

In the first article Vlad does quite a few benchmarks between Firebird 2.5/3.0.0/3.0.2 releases . It's very nice that minor releases brings free speedups. He also shows Firebird 3.0.3 performance related changes and fixes and the future ones that are already in Firebird 4
 
 Firebird Performance, by Vlad Khorsun, Firebird Project
 Tuning Linux, Windows, and Firebird for heavy workload by Alex Kovyazin, IBSurgeon.
 Firebird 3: New in Database Statistics and New SQL execution plans, by Dmitry Kuzmenko, IBSurgeon
 Advanced Firebird Trace API, by Vlad Horsun, Firebird Project

Firebird 3.0.3 Binary kits for macOS on both 32-bit and 64-bit platforms are immediately available for download

Firebird 3.0.3 Binary kits for macOS on both 32-bit and 64-bit platforms are immediately available for download

Firebird 3.0.3 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.3 — the third 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.

ps: Mac OS builds are coming soon

In 2017, The Document Foundation (TDF) launched four tenders aimed at improving LibreOffice. Tender four is of interest to the Firebird community

In 2017, The Document Foundation (TDF) launched four tenders aimed at improving LibreOffice. Tender four is of interest to the Firebird community:

(4) Tender to implement HSQLDB binary format import in LibreOffice

(https://blog.documentfoundation.org/blog/2017/05/04/tender-implement-hsqldb-binary-format-import-libreoffice-201705-03/)


Collabora will develop a mechanism to import database files with high fidelity from the HSQLDB binary file format, which has been used inside many existing ODB files, by reading the Java serialization code, and writing a filter to import all data into LibreOffice Base. The objective is to remove the legacy Java/HSQLDB database and move to Firebird.


TDF will invest € 29,750.00

LibreOffice Firebird driver related changes

There were quite a few bugs fixed in the last two months related to Firebird driver in LibreOffice also interesting commits

Tamas Bunth commited : Add HSQLDB schema import.
He also fixed Bug 104734 - FIREBIRD: Add those field types that are not available with FB while they are available with Hsqldb.
Lionel Elie Mamane fixed Bug 104986 - Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY, MILLISECOND.

Tor Lillqvist fixed Bug 71007 - EDITING: Embedded Firebird - Impossible to set milliseconds in a timefield with GUI

Tamas Bunth fixed Bug 70425 - EDITING: Embedded Firebird - Copying integer values from Calc to Base impossible

Ubuntu 17.10 comes with Firebird 3.0.2

Ubuntu 17.10 is released and it comes with Firebird 3.0.2 (Latest stable version)

Thanks to Damyan  Ivanov and Debian project contributors to Firebird packages

Visual Studio 2017 Version 15.4 Released

You can now use CMake for Linux C++ development in Visual Studio

That could be interesting in cross compiling Firebird from Windows side to Linux/WSL

https://blogs.msdn.microsoft.com/visualstudio/2017/10/10/visual-studio-2017-version-15-4-released/

Firebird 3 on Apple IOS

One side effect of new Firebird 3.0.3 builds for Apple Macosx is that now there is a Mach-O dynamically linked shared library for arm_v7 that can be used on IOS.
You can ask for details on Firebird-devel 
ps: For Firebird 2.5.x there is a build on Paul's blog also Egor Pugin created Cmake files for IOS Builds (I didn't tested that route yet)

Firebird 4.0 Alpha 1 release is available for testing

Firebird Project announces the first Alpha release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing.

ADO.NET provider 5.11.0.0 for Firebird is ready (with .NET Standard 2.0 support)

New version 5.11.0.0 of ADO.NET provider for Firebird is ready for download. This release is about .NET Standard 2.0. Now the .NET Standard 2.0, with all the new APIs supported, version is available. Another new feature is support for passing key over the wire for encrypted databases (you need to have server side plugin for this feature, i.e. this from IBPhoenix). New connection string property crypt key is available for that. The value is base64 encoded data representing the key.

Jaybird 3 with Firebird 3 embedded example

Mark Rotteveel published a guide and example program using Firebird 3 Embedded with Jaybird 3. The sample you can find it on https://github.com/mrotteveel/jaybird-embedded-example.

Firebird inside Firebird in DotNet External Engine (FbNetExternalEngine)

You can load any .NET code in FbNetExternalEngine also as Proof Of Concept you can also load Firebird Embedded inside that in server (Firebird inside Firebird in DotNet External Engine).

Firebird 3.0.3 for MacOSX (Beta)

A beta version of a 64bit Firebird 3.0.3 for MacOSX is now available as a download for those of you who might be interested in trying it. http://www.ibphoenix.com/download/firebird/30