firebird_FDW 1.2.0 released

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.

Upscene releases Database Workbench 5.7.0

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

” Database Workbench 5.7.0″

This new release brings you PostgreSQL 12 support and fixes to the Firebird and MySQL modules.

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

#AnyDAC Summer 2012 v 6.0.1 – #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of major new version AnyDAC for Delphi Summer 2012 release v 6.0.1 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

Do not miss the Summer sale25% discount on all AnyDAC orders in August !

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v6.0.1 and what is AnyDAC ?

#AnyDAC Spring 2012 v 5.0.7 – #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2012 release v 5.0.7.2333 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.7 and what is AnyDAC ?

#AnyDAC Winter 2012 v 5.0.5 – #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Winter 2012 release v 5.0.5.2073 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.5 and what is AnyDAC ?

#AnyDAC Summer 2011 v 5.0.1 – #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Summer 2011 release v 5.0.1.1845 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, DbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.1 and what is AnyDAC ?

Why I find MySQL to be so bad compared to Firebird

MySQL is the most used Open Source database engine. I have personally used it for almost 10 years. I worked with versions 3.x, 4.x and 5.x of MySQL, but I also used other database engines, some of them handling the same “data-set size” as MySQL, while others have been smaller databases (mostly Desktop based databases such as SQLite, MS-Access and Paradox).

This is the first part of my complaint about MySQL and why I dislike it.

1 2