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).