Firebird php driver status for Firebird Advent 2020 ⛄

 Firebird php driver status for Firebird Advent 2020 ⛄

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


A new version of the Firebird PHP driver was recently released. This version supports booleans values. Precompiled binaries for PHP 7.3 , 7.4 and 8.0 are available at the download section.

The driver is marked as 1.1.0 stable . Please report any problems to the tracker at https://github.com/FirebirdSQL/php-firebird/issues.

See also:
Firebird PHP driver on Github
Firebird PHP driver download

Firebird LibreOffice status

Firebird LibreOffice status for Firebird Advent 2020 ⛄

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

This year Firebird was updated to 3.0.7 in master branch (LibreOffice 7.2),  patches related are in external/firebird , interesting to note is build patch for macOS on arm64.

Firebird driver related changelog with fixes is located in connectivity/source/drivers/firebird

The list of new bugs can be found in bugzilla , usually search the term "NEW firebird".

Firebird Rust driver status

Firebird rust driver status for Firebird Advent 2020 ⛄

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

Last version released is 0.13.0 with a few changes.

Rust firebird github repository is located here 

https://github.com/fernandobatels/rsfbclient

Crates page is here 

https://crates.io/crates/rsfbclient

Docs are located here 

https://docs.rs/rsfbclient/0.13.0/rsfbclient/

More examples in the github repository 

https://github.com/fernandobatels/rsfbclient/tree/master/examples

Cool features : connection to the firebird db can be made in embeeded mode if is on the same machine 

also using the libfbclient to a remote server or using the pure rust implementation 😀 

https://docs.rs/rsfbclient/0.13.0/rsfbclient/builders/struct.NativeConnectionBuilder.html

Another interesting project is  rbfbclient : A new version of Firebird Extension Library for Ruby using Rust instead of C for binding of firebird API.

Firebird SQLAlchemy support

Firebird SQLAlchemy status for Firebird Advent 2020

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

Current SQLAlchemy release 1.3.20 supports firebird out of the box 

https://docs.sqlalchemy.org/en/13/dialects/firebird.html

In the future the driver is moved outside of SQLAlchemy repository in this place 

https://github.com/pauldex/sqlalchemy-firebird

so it will be installed in the future releases with :

pip install sqlalchemy-firebird

After sqlalchemy and driver install you can follow the official tutorial or something similar using the firebird dialect 

https://overiq.com/sqlalchemy-101/installing-sqlalchemy-and-connecting-to-database/

django-firebird driver status

Firebird django-firebird driver status for Firebird Advent 2020 

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

django-firebird pre released 2.2a1 version with support for Firebird 3 and Django 2.2.x LTS (That will be supported until 2022 according to the roadmap) 

Thanks to this pull request #111.

The stable version corresponds with django 2.2 and live into stable/2.2.x branch. The current master branch of this repository is being developed under django 3.0.x.

fbd is the legacy official driver with support for python 2.x and python 3.x , 

We need to switch to new python3/firebird3.x only driver in the future firebird-driver

So the recommended way today is Django 2.2.x and fdb driver (for Firebird 3.x)

Alternate experimental driver : djfirebirdsql

DJFirebirdSQL is a Django firebird database backend using pure python driver pyfirebirdsql (Work in progress)

https://github.com/nakagami/djfirebirdsql

Requirements: Django 3.1 and Firebird 4.0 beta1 (Firebird 3.0 minimum version required)

Firebird python3 driver status

Firebird python3 driver status for Firebird Advent 2020 

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

The firebird-driver package provides driver for Python 3.8+ and Firebird 3+. This driver uses new Firebird OO API provided by fbclient library. You can download it or install directly from Python Package Index.

To use the driver you can start with the Getting Started from documentation area 

A few more examples are in Usage Guide from documentation area

Please note, that his new driver requires Firebird 3+ and Python 3.8+.
This “high” base line was chosen deliberately, to use all new features
available from latest Firebird & Python releases without constraints and
limits that backward compatibility would require. Internally, the driver
uses new client API based on interfaces introduced by Firebird 3. This
new API has many limits raised (like statement sizes, blob sizes etc.)
or completely lifted (like number of databases participating in
distributed transaction), and provides access to new Firebird features
(like scrollable cursors).

The 1.0 release supports all key driver features you know
from FDB (passes all tests for FDB features)

New features in comparison to FDB:
– scrollable cursors
– type hints everywhere
– new FB client API instead old one
– enhanced Enums and Flags classes instead isc_* constants
– better and more rich support for Firebird services

The driver has also much cleaner structure and namespaces, and less core
code than FDB, and although it was not measured yet, it should also
perform better. However, the driver API is not 100% backward compatible
(with FDB).

Please note, that FDB driver is now considered as legacy driver, and its development will be discontinued together with 2.5 once Firebird 4.0 will be released later this year.

The driver uses firebird-base package, which is a collection of modules that have general applicability, like extended configuration, context-driven logging and trace/audit, hooks, work with structured binary buffers, extended data structures etc. The driver uses almost all features provided by "base" package, but specifically the use of hook mechanism and context-driven logging and trace/audit are potentially the most valuable improvements.


The firebird-lib package provides extensions to the firebird-driver.
This package provides modules for:
Work with Firebird database schema.
Work with Firebird monitoring tables.
Processing output from gstat Firebird utility.
Processing Firebird server log.
Processing output from Firebird server trace & audit sessions.

You can download this library from PyPI or or install it using pip.

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

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

https://qiita.com/advent-calendar/2020/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 :

2.1.1 (November, 22, 2020)
driver-native

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

driver

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

2.1.0 (December, 29, 2019)
driver

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

node-firebird status for Firebird Advent 2020

node-firebird status for Firebird Advent 2020 

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

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

Version 0.9.3 Changes : 

Fixes Issue #182 - Parameterize the location of firebird.msg

Version 0.9.4 Changes : 

Fix issues #222, #220, #216, #209, #208
Thanks to @jucapablanca

Version 0.9.5 Changes : 

Minor corrections #226

Version 0.9.6 Changes : 

Corrections for reading empty blobs fields and also for empty varchar fields of type charset none returning undefined #228

Version 0.9.7 Changes : 

Adding ServiceManager typescript definitions; and fixing typos and potential bugs. #229

Version 0.9.8 Changes : 

Adding GDSCodes #231

Version 0.9.9 Changes : 

Supports of BOOLEAN type, bug fix, and intellisense experience improvement. #235
Correct issues and new implementations #238

FirebirdWebAdmin status for Firebird Advent 2020

FirebirdWebAdmin status for Firebird Advent 2020 

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

This year we have seen one release with a few features and small changes in master branch 

Version 3.4.1 (27.02.2020) Changes : 

• [enhancement:] Adjust "Accessories" page UI.
• [enhancement:] Remove Crowdin badge from footer.
• [enhancement:] Update debug_funcs.inc.php
• [bugfix:] Don't warn if "isql" is "isql-fb" on Linux
• [typo:] Correct typo: firebirid -> firebird
• [bugfix] fix sql create database
• [enhancement:] Add Character Sets
• [enhancement:] Quiet PHP7.2 deprecation warning …
• [enhancement:] Further create_function refactor
• [enhancement:] Remove unused/outdated markableFbwaTable.
• [enhancement:] cosmetics

Further informations 

See CHANGELOG.md to get the full changelog.

One option to install 3.4.1 is now using a docker image that will pull the requirements (apache/php)


https://hub.docker.com/r/marianaldenhoevel/firebirdwebadmin