Year: 2023

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

Leave a comment

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 to CSV

Leave a comment

Firebird to CSV converter is a free program to export Firebird or Interbase databases into comma separated values (CSV) files. The program has high performance due to direct reading of the source database and writing into CSV files. Firebird to CSV converter does not use ODBC or any other middleware. Command line support allows to script, automate and schedule the conversion process.

Features:

  • All versions of Firebird and Interbase are supported
  • Fast conversion engine (100MB database – in less than 5 minutes on average modern system)
  • Option to convert individual tables
  • Option to select separator: tab, comma or semicolon
  • Option to store conversion settings into profile
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • Freeware

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

Leave a comment

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.30. DECFLOAT and improved connection pool [FB4]

Leave a comment

Hello Everyone.

In the current release, we have continued expanding the support of Firebird v4.

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

New features

  • The full support of DECFLOAT(16) and DECFLOAT(34) has been implemented
  • The new version of IBProvider supports the ICU v63 from FB4 kit
  • Using «ALTER SESSION RESET» for resetting a connection before reusing (see this new example)

Kind Regards and Good Luck! IBProvider Team.

Jaybird 5.0.2 released

Leave a comment

We are happy to announce the release of Jaybird 5.0.2.

The following has been fixed since Jaybird 5.0.1:

  • Fixed: Reconnect transaction with a transaction id exceeding 0x7FFF_FFFF did not work (jaybird#734)
  • New feature: add connection property parallelWorkers to set Firebird 5.0 isc_dpb_parallel_workers (jaybird#737)
  • New feature: add MaintenanceManager.upgradeOds() for the Firebird 5.0 gfix/service repair action to perform a minor ODS upgrade of a database (jaybird#738)
  • New feature: add parallel workers support for BackupManager (jaybird#739)
  • New feature: add parallel workers support for sweep in MaintenanceManager (jaybird#740)
  • Fixed: DatabaseConnectionProperties.setServerBatchBufferSize(int) ignored provided value and always set default (0, or “use server-side maximum”) (jaybird#741)
  • New feature: add MaintenanceManager.fixIcu() for the Firebird 3.0 gfix/service repair action “ICU” to update or rebuild collations and indexes when the ICU version changed (jaybird#744)
  • Fixed: The first call to getTableStatistics() of a FBTableStatisticsManager instance returned only a few or even no tables; if no tables were returned, subsequent calls would also return no tables (jaybird#747)

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17 and 20 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

IBProvider v5.29. The initial support of FB4

Leave a comment

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_rules, numeric_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.

1 2 3 4 5 6 7