Year: 2020

Install Firebird-Server 3.0.7 on a QNAP NAS (Updated)

Leave a comment

You would like to install Firebird Server 3 on your QNAP NAS?

You can download the necessary QPKG file from the following link. You will also find a short updated description of how to install it (for free use).

The installation only works on a QNAP NAS with Intel processor on 64 bit basis!

https://fbm.gksoft.ch/index.php/de/?option=com_phocadownload&view=category&id=2

UPDATE:

We made a update of our qpkg file and “How to install” instructions. Now it is much easier to install and configure the Firebird Server on the NAS.

Firebird 3.0.7 sub-release is available

Leave a comment

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

All users of Firebird v3.0.6 are strongly encouraged to upgrade to v3.0.7 as soon as possible due to several serious bugs found in v3.0.6 and fixed in this point release.

IBProvider v5.21. SQL query parser cache implementation

Leave a comment

In this release of IBProvider v5, we have implemented caching the results of our own SQL query parser.

The SQL query parser is needed to define the type of query and its parameter list as well as to divide the script into separate expressions.

The SQL query cache (SQL Cache) supplements the server query cache (Stmt Cache) implemented way back in the earlier versions of IBProvider v3.

Both SQL Cache and Stmt Cache use separate threads to service their own state.

The SQL query cache works for both user queries and service queries of updatable rowset.

Read more at IBProvider Site

Kind Regards, IBProvider Team.

New version of RedExpert 2020.10 has been released

Leave a comment

New version of RedExpert 2020.10 has been released.

Fixes:

  • A value of a variable is not lost when editing a procedure.
  • Object names are quoted only when necessary.
  • Removed redundancy in variable declarations.
  • Generation of a random date (There was an error that the minimum is greater than the maximum).
  • Comments to variables are not lost when editing a procedure.
  • Roles which were not created by a user have been moved under the system roles branch.
  • Few first characters in the cell are displayed instead of ‘CLOB DATA’.
  • Removed the unreasonable occurrence of the error about the loss of connection with the server.
  • Fixed generation of table DDL statement.
  • Fixed generation of procedure DDL statement.
  • Fixed generation of trigger DDL statement.
  • Fixed display of table constraints.
  • Fixed display of release notes in the application.

Improvements:

  • Added the ability to use autoddl when executing a script.
  • Added the ability to manage update rule and delete rule for foreign keys.
  • Added the ability to use autocomplete without hotkeys.
  • Added the ability to delete user settings when uninstalling the application.
  • Added the ability to work with collates of character sets in datatypes.

Download and install the new version.

firebird_FDW 1.2.0 released

Leave a comment

firebird_fdw, a foreign data wrapper for PostgreSQL providing read and write access to Firebird databases, is now available as version 1.2.0.

This release provides following new features:

  • support for PostgreSQL 13
  • support for generated columns (PostgreSQL 12 and later)
  • support for COPY and partition tuple routing (PostgreSQL 11 and later)
  • improved handling of case folding/identifier quoting
  • support for “implicit booleans”
  • pushdown of boolean tests in WHERE clauses (including implicit booleans)
  • following utility functions have been added:
    • firebird_fdw_server_options(servername TEXT): displays the current settings for the named server
    • firebird_version(): shows Firebird version information for each firebird_fdw foreign server in the current database
  • ERROR log messages will show any relevant Firebird query as a CONTEXT message

Following bugs have been fixed:

  • EXPLAIN for a remote modify now shows the Firebird query used
  • UPDATE statements where a BEFORE ROW UPDATE trigger is present now work correctly
  • CREATE SERVER‘s port option is now recognized
  • foreign tables defined as queries can no longer be set as updatable = 'true'

This release requires Firebird API wrapper libfq version 0.4.0 or later (latest version at the time of writing: 0.4.2)

firebird_fdw 1.2.0 is compatible with PostgreSQL versions 9.3 ~ 13. Note that support for PostgreSQL 9.2 has been removed in this release. It supports Firebird 2.5.x and Firebird 3.0.x.

Source code is available from the GitHub repository: https://github.com/ibarwick/firebird_fdw/

CentOS rpm packages are available via the Fedora Copr build system.

Python 3 Firebird-driver & Firebird-lib 1.0.0 released

Leave a comment

The firebird-driver package provides official Python Database API 2.0-compliant driver. In addition to the minimal feature set of the standard Python DB API, this driver also exposes the new (interface-based) client API introduced in Firebird 3, and number of additional extensions and enhancements for convenient use of Firebird RDBMS. The driver is written as pure-Python package (requires Python 3.8+) on top of Firebird client library (fbclient.so/dll) using ctypes. Driver supports Firebird version 3.0 and higher.

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

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.

1 2 3 4 … 9