Package detail

node-firebird-driver-native

asfernandes3.3kMIT3.2.2

Firebird Native Driver for Node.js

firebird

readme

Firebird drivers for Node.js / TypeScript

This project is the root project of a monorepo with Firebird drivers for Node.js / TypeScript (or JavaScript).

The sub projects are there:

node-firebird-driver-native - High-level Firebird client using native fbclient library
node-firebird-native-api - Low-level Firebird client directly mapped from fbclient interfaces
node-firebird-driver - Interface files for the high-level driver(s)

Contributing

Clone this repo then run:

yarn
yarn bootstrap
yarn test

Testing

yarn run test (default user and password will be used during tests)

As of now tests require Firebird 4 server and will fail when executed using Firebird 3.

You can put test configuration in .env file in the project root directory, like the following example:

ISC_USER=sysdba
ISC_PASSWORD=masterkey
NODE_FB_TEST_HOST=localhost
NODE_FB_TEST_PORT=3050
NODE_FB_TEST_TMP_DIR=/tmp/node-fb-tmp

You can also set environment variables externally. For node-firebird-native-api, ISC_USER and ISC_PASSWORD could not be set in the .env file currently. It should be set externally.

If NODE_FB_TEST_HOST is ommited, embedded server will be used.

NODE_FB_TEST_PORT defaults to 3050.

For remote server make sure to specify NODE_FB_TEST_TMP_DIR.

For local server or embedded, if NODE_FB_TEST_TMP_DIR is ommited a temporary directory will be created.

Donation

If this project help you reduce time to develop, you can show your appreciation with a donation.

GitHub Sponsor: https://github.com/sponsors/asfernandes
Pix (Brazil): 278dd4e5-8226-494d-93a9-f3fb8a027a99
BTC: 1Q1W3tLD1xbk81kTeFqobiyrEXcKN1GfHG

changelog

June, 6, 2024

Fix #147 - Build problems.

March, 1, 2023

driver, driver-native - 3.1.0

Feature #136 - Add method for query cancellation.

December, 15, 2022

driver, driver-native, native-api - 3.0.0

Feature #130 - Add options to Attachment.createBlob for stream blob creation.
Feature #131 - Add method BlobStream.seek.
Feature #133 - Update target code to ES2020 (node.js 14 compatible).

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 - 2.1.4

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.

November, 22, 2020

driver-native - 2.1.1

Feature #62 - Change value of getDefaultLibraryFilename in MacOS.
Feature #63 - Make getMaster return OS error when failing to load the client library.

driver - 2.1.1

Fix #69 - Subsequent use of Statement::execute* methods may send incorrect value of input parameters.

December, 29, 2019

driver - 2.1.0

Feature #30 - Add methods executeReturningAsObject and fetchAsObject to return records as objects instead of arrays.
Feature #43 - Add Statement.columnLabels property.

December, 06, 2019

driver - 2.0.0

Feature #34 - Support for Firebird events.
Feature #42 - SQL role name in connection options.

native-api - 2.0.0

Minimal node version is 10.6.0.
Fix #41 - Error: pointer argument must be an instance of Pointer class or null with node v13.