Release of IBProvider v5.31

Hello Everyone!

We have completed the third step in the process of implementing FB4 support in our OLE DB provider.

This release adds support for TIMESTAMP WITH TIME ZONE, improves support for INT128 and improves support for NUMERIC data types.

Please review the changes carefully.

At the end of the news we have prepared a special offer for you.

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

Kind Regards, IBProvider Team.

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.

1 2 3 4 5 198