Firebird-driver 1.9.0 released

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 install it using pip.

This version intruduces initial support for Firebird 5.0 new API and features.

See the Changelog for full details.

New features in Firebird 5, Annual General Meeting, elections, and a bit of Firebird history

In this video we discuss the new features of Firebird 5 with Dmitry Yemanov (core developer, RedSoft), Jason Wharton (IBObjects, Temporary Secretary of Firebird Foundation) and Alexey Kovyazin (IBSurgeon, Firebird Foundation Comittee member), then we announce elections during the Annual General Meeting.

In the end of the video Jason, as one of the founders of Firebird Foundation, remembers how everything started.

Firebird External Table Generator (ext-table-gen) 1.0 released

I am happy to announce the release of “Firebird External Table Generator” (ext-table-gen for short).

“Firebird External Table Generator” is a commandline tool to transform RFC 4180 CSV files to Firebird external table files (a binary format for external table data).

External tables are a good way for bulk-loading data into Firebird. Unfortunately, external tables use a fixed-width binary format, and not (more) standard formats like CSV. It is not always easy to create an appropriate external table file, and this is where ext-table-gen can be used.

At a high level, ext-table-gen provides the following features:

  • Derive a CHAR-based external table definition (i.e. a CREATE TABLE statement and a configuration for ext-table-gen) from a CSV file
  • Transform a CSV file to an external table file (either based on the CSV file itself, or based on a configuration file)

The current version only supports CHAR columns, which makes the generated file essentially a fixed-width text format. Future versions may introduce support for additional column types.

You can find the 1.0 release at ext-table-gen v1.0.

Documentation and release notes can be found on https://mrotteveel.github.io/ext-table-gen/.

The project itself is hosted on https://github.com/mrotteveel/ext-table-gen.

IBProvider v5.29. The initial support of FB4

Hello All 🙂

The implementation of FB4 support requires time. That is why we decided to split this process into parts and make intermediate releases. It will allow you to begin using IBProvider with FB4 right now.

https://www.ibprovider.com/eng/news/n_230522__fb4_step1.html

The current support of FB4

  • You can work with FB4 through fbclient.dll
  • You can work with FB4 through a built-in client (dbclient_type=fb.direct). The 13th protocol will be used
  • The long name of database objects are supported
  • All the FB4 datatypes (including new datatypes: INT128, DECFLOAT, time/date with a time zone) are supported at the metadata layer
  • The full support of INT128 and NUMERIC on base INT128 was implemented
  • New initialization properties were added — int128_rulesnumeric_i16_rules

Lots of functional and load tests were made with using FB v4.0.3.2937.

For mission-critical, multi-threaded and 24/7 applications, we highly recommend using the built-in client.

IBProvider Free does not support FB4.

Additional changes

  • The support of DBTYPE_TIMESTAMPOFFSET was added
  • The transformation between {DBTIME, DBTIME2} and {DATE, DBDATE, DBTIMESTAMP, FILETIME} was deleted
  • The transformation of NUMERIC into VARIANT was improved
  • The procession of charset names was corrected

With best regards, IBProvider Team.

Database Workbench 6.2.0 released

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 6.2.0″

This release brings support for the latest PostgreSQL versions, recognizes Firebird 5 beta, and brings new features in general.

One of the major changes is the new object selection box in the Object Editors: much faster on a large number of objects and it now includes a filter for easier usage.

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

Saturnin (a Firebird Butler Platform for Python) version 0.8.0 has been released, along with packages with core services and SDK.

Saturnin (a Firebird Butler Platform for Python) version 0.8.0 has been released, along with packages with core services and SDK.

Saturnin can now be considered as early beta. There will be more additions, extensions and improvements before the 1.0 release, but the platform is almost feature-complete, and the functionality provided is considered stable and ready for testing. However, some backwards incompatible changes in future releases are still possible.

1 4 5 6 7 8 200