Firebird Project announces the first Beta release of Firebird 5.0

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

This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with many bugfixes. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release

Firebird 5 compiling on Oracle Linux 8 Ampere V1 (arm64)

You can compile just fine Firebird 4/5 on Oracle Linux 8 Ampere V1 (arm64) all you need is GCC Toolset 12 enabled as described here .

Also same steps work for Oracle Linux 8.x on x86-64. 

sudo dnf group install "Development Tools"
sudo dnf install libicu-devel cmake git 
sudo dnf install gcc-toolset-12
scl enable gcc-toolset-12 bash

git clone https://github.com/FirebirdSQL/firebird.git
cd firebird
./configure --with-builtin-tommath --with-builtin-tomcrypt
make

Rust Firebird Client updated to v0.23.0 with a few features

Rust Firebird Client updated to v0.23.0 with a few features :

Firebird events support added on native client #133 #142

Crates.io link is here .

Sponsoring Link for Fernando Batels is here .

Firebird high-level native client for Node.js / TypeScript status status for Firebird Advent 2022

 Firebird high-level native client for Node.js / TypeScript status status for Firebird / Typescript Advent 2022

https://qiita.com/advent-calendar/2022/firebird

To use the driver you can start with the readme from npm/github

https://www.npmjs.com/package/node-firebird-driver-native

A few more examples are in the packages/node-firebird-driver/src/test directory

We have seen several releases with a few features and changes :

January, 26, 2022

driver, driver-native - 2.4.0

• Feature #115 - Add method Statement.getExecPathText.
• Feature #119 - Implementation of isValid property.
• Feature #121 - Deprecate methods executeReturning* replacing by executeSingleton*.

native-api

• Feature #114 - Add support for Visual Studio 2022 build.

July, 20, 2021

driver, driver-native - 2.3.0

• Feature #101 - Add property Statement.hasResultSet.
• Feature #102 - Add method Statement.setCursorName.

June, 07, 2021

driver-native - 2.2.0

• Feature #87 - Support Firebird 4 INT128 data type.
• Feature #88 - Support Firebird 4 DECFLOAT(16) and DECFLOAT(34) data types.
• Feature #89 - Support Firebird 4 TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE data types.
• Fix #94 - Wrong year in date/timestamp when year < 100.

May, 07, 2021

native-api - 2.1.2

• Fix #86 - Race condition in events processing.

node-firebird driver status for Firebird Advent 2022

node-firebird status for Firebird Advent 2022 

https://qiita.com/advent-calendar/2022/firebird 

also for  Javascript Advent 

https://qiita.com/advent-calendar/2022/javascript

This year we have seen several releases with a few features and changes :

Version 1.1.0 Changes : 

• Srp implementation by @maratth in #242
• Add optional callback for pool destroy by @Tomas2D in #244
• Set protocolVersion as optional in escape function (TypeScript) by @Rafatcb in #248
• Bump glob-parent from 5.1.0 to 5.1.2 by @dependabot in #252
• Fix tsc build issues by @777777miSSU7777777 in #255
• Automatically reconnect to database by @Tomas2D in #259
• Fix attaching to database if database does not exists by @Tomas2D in #260
• Add definitions to transaction isolation modes by @Rafatcb in #262
• Added configurable character set for connections. by @thekevinbrown in #272
• feat(blob): add support value text for blob subtype 1 by @jesusvilla in #274
• feat(blob): add support unique transaction for get blob by @jesusvilla in #275

Version 1.1.2 Changes : 

• perf: add more solutions by @jesusvilla in #280

Version 1.1.3 Changes : 

• fix(blobAsText): add compatibility with wire protocol version >= 13 by @jesusvilla in #282

Version 1.1.4 Changes : 

• Fix Typo : Replace ISOLATION_READ_COMMITED with ISOLATION_READ_COMMITTED mentioned here #262

Npm trends for node-firebird package 

https://npmtrends.com/node-firebird

LibreOffice Base can connect to an external Firebird server

LibreOffice Base can connect to an external Firebird server , here is an example with employee.fdb from Firebird 3 examples folder copied to c:\tmp

Tested with LibreOffice 7.4.x and Firebird 3 default install on Windows 11 (all 64 bits versions)

and here is the Relation Design in LibreOffice Base 

Linux 0.0.1 compiling on Ubuntu 64

You might need some packages first

$ sudo apt-get install bin86 kvm qemu gcc build-essential qemu-system-x86 gcc-multilib

clone the github repo with 64 build fixes https://github.com/mariuz/linux-0.01

$ gh repo clone mariuz/linux-0.01

$ unzip hd_oldlinux.img.zip

$ make

$ make run 

or 

$ make run-curses 

SeaBIOS (version 1.13.0-1ubuntu1.1)
iPXE (http://ipxe.org) 00:03.0 CA00 PCI2.10 PnP PMM+0078EBD0+006CEBD0 CA00
Booting from Floppy...
Loading system ...
Partition table ok.
31278/40950 free blocks
13544/13664 free inodes
1494 buffers = 1529856 bytes buffer space
Ok.
#

Flamerobin 0.9.3.12 Snapshot released with a few Firebird 4 fixes

  Flamerobin 0.9.3.12 Snapshot released with a few Firebird 4 fixes , here is the changelog 

• Implement Int128 by @andy-123 in #230
• Implement firebird 4 types: decimal(16) and decimal(34) by @andy-123 in #244
• Some fixes by @Jdochoa in #254
• Some Fixes by @Jdochoa in #255
• FB Library Search by @Jdochoa in #261

Full Changelog: 0.9.3.11...0.9.3.12

Firebird 3.0.10 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.10 — the latest point release in the Firebird 3.0 series.This sub-release offers a few important bugfixes, 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, packages for Mac OS will follow shortly.

Firebird 4.0.1 and 3.0.9 Docker images are released

 Firebird 4.0.1 and 3.0.9 Docker images are released and the following tags can be used :  v4.0 , v4.0.1 , latest or 3.0, v3.0, v3.0.9 .

Firebird 3.0.9 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.9 — the latest point release in the Firebird 3.0 series.
This sub-release offers a few important bugfixes, 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, packages for Mac OS will follow shortly.

Node-firebird-driver-native version 2.4.0 has been released with a few features added.

Node-firebird-driver-native version 2.4.0 has been released with a few features added.

Firebird Grammar railroad diagram

Railroad diagram for the Firebird database you can see/get it here (following the instructions)

https://github.com/FirebirdSQL/firebird/issues/6898

Zip file with self contained images is here (generated with the above instructions).

Short overview of Firebird events in 2021

From all of us at Firebird Project, we'd like to wish you a safe and happy holiday season and a peaceful and prosperous new year!

And here is a short overview of Firebird events in 2021.

Firebird Project is happy to announce general availability of Firebird 4.0.1

Firebird Project is happy to announce general availability of Firebird 4.0.1 — the first point release in the Firebird 4.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.

Flamerobin 0.9.3.11 Snapshot released with new Firebird 4 features and fixes

 Flamerobin 0.9.3.11 Snapshot released with new firebird 4 features and fixes :

• Fixed timestamp problem with Fb4 : PR #224
• Fixed problems with numeric types
• Fix encoding at blob editor
• Fix UDF property loading at Fb<=2.5
• Implementing Fb4 datatypes by @andy-123( in progress) : PR #223 Implement time zone support for firebird 4

Leaving MySQL - blog post by long-term MySQL team member Steinar H. Gunderson

Leaving MySQL - blog post by long-term MySQL team member Steinar H. Gunderson

with discussions on Hacker News :
https://news.ycombinator.com/item?id=29455852

and on reddit : https://www.reddit.com/r/programming/comments/ra81ki/leaving_mysql/

Firebird 3.0.8 Docker image is released

Firebird 3.0.8 Docker image is released and the following tags can be used : 3.0, v3.0, v3.0.8 .

Firebird 3.0.8 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.8 — the latest 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, Mac OS and Android platforms are immediately available for download.

Rust Firebird Client updated to v0.17.0 with a few features and enhancements.

 Rust Firebird Client updated to v0.17.0 with a few features and enhancements.

New Features: 

- create_database() added CreateDatabase with embedded client #112 

- Add support for create_database() method, aka isc_create_database #115

Bug Fixes:

- rsfbclient always recompiled #113 , #114