postgresql Archives - Firebird News

firebird_FDW 1.2.0 released

October 19, 2020 Ian Barwick 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.

Upscene releases Database Workbench 5.7.0

March 23, 2020 Martijn Tonies Leave a comment

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!

[See remaining text…]

Firebird Foreign Data Wrapper for PostgreSQL Release 0.2.1 is out

January 24, 2014 mariuz Leave a comment

New version 0.2.1 is released in the unstable area and here is the ChangeLog:

Make extension compatible with PostgreSQL 9.2
Fix some regressions
Implement basic connection caching
Fix implicit cast handling

A Foreign Data Wrapper (FDW) for Firebird

January 4, 2014 Cantu Leave a comment

Bert Herngreen pointed me to this page: http://sql-info.de/postgresql/notes/firebird-foreign-data-wrapper-fdw.html. Maybe it can be useful to someone.

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

August 14, 2012 darefiev Leave a comment

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 sale – 25% 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 ?

[See remaining text…]

AnyDAC v 6.0.1 Highlights

Support for iOS Emulator and ARM devices;
Support for FireMonkey, including FM AnyDAC dialogs (more);
New Local SQL to query TDataSet’s. Native xQuery replacement (more);
New Centralized Cached Updates, with master-detail propagation (more);
New DataSnap multi-tier driver.

And more.

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing Windows, Linux, Mac OS, iOS cross-platform applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage, DataSnap and more. For complete list of features and availability, please check:

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database, DataSnap and more. Including latest DBMS versions.
Generic access to any database supported through dbExpress or ODBC data sources.
Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable, TADLocalSQL.
Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support, Local SQL engine.
Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X, iOS.
Perfect integration as back-end driver for DataSnap, TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – dbExpress, ODBC.
Multi-Tier – DataSnap.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

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

April 20, 2012 darefiev Leave a comment

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 ?

[See remaining text…]

AnyDAC v 5.0.7 Highlights

Delphi XE2 and Mac OS X support;
FPC 2.6.0 / Lazarus 0.9.30.4 and Windows x86/x64, Linux x86/x64 and Mac OS X support;
UpdateOptions.UpdateJoinedFields and TADMapRule.NameMask added;
Auto-inc fields improvements;
SQLite v 3.7.11 support;
SQLite native Array DML support;
SQL Server 2012 support;
Advantage DB TADADSUtility service component;
Advantage DB support for aliases;
ReportBuilder DADE;
Nany driver and addon improvements;
Multiple enahncements to the help system.

And more.

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check:

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
Generic access to any database supported through dbExpress or ODBC data sources.
Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – dbExpress, ODBC.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

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

December 25, 2011 darefiev Leave a comment

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 ?

[See remaining text…]

AnyDAC v 5.0.5 Highlights

major TADTable and Live Data Window mode optimization;
Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
Firebird COMPUTED BY support;
PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
Interbase v 6, 7 support;
Advantage v 8, 9 support;
SQL Anywhere v 12 support;
SQLite v 3.7.9 support;
ElevateDB ODBC support;
ReportBuilder DADE;
Multiple enahncements to the help system.

And more.

AnyDAC for Delphi

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
Generic access to any database supported through dbExpress or ODBC data sources.
Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – dbExpress, ODBC.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

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

July 5, 2011 darefiev Leave a comment

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 ?

[See remaining text…]

AnyDAC v 5.0.1 Highlights

New Advantage Database native ACE API driver (More).
New TADTable with live data window mode (More).
Major refactoring of the drivers infrastructure.
Major refactoring of the monitoring and tracing infrastructure.
New FormatOptions.FmtDisplayXxx, FmtEditXxx options.
New ADConnection Before/After StartTransaction, Commit, Rollback events.
Multiple enhancements to the help system.
Multiple enahncements to the help system.

And more.

AnyDAC for Delphi

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, InterBase, MySQL, MS SQL Server, Oracle, PostgreSQL, SQLite, DB2 and more. Including latest DBMS versions.
Optimized for best possible performance (2 times faster than dbGo, 25% faster than dbExpress).
Generic access to any database supported through dbExpress and ODBC data sources.
Reach API, including 50 Delphi VCL components.
Unified API for access to cross-database features.
First-class support for many database-specific features, including DBMS services like backup, validate.
Unique ADO.NET-like data engine for Win32.
Advanced Data Access Options.
Full support for international applications, including full Unicode support in Delphi 2009 and later.
Cross-platform support though Free Pascal (FPC).
Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, MS SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – DbExpress, ODBC.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

Database identifiers, quoting and case sensitivity

December 4, 2008 mariuz Leave a comment

Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.

Article by Lorenzo Alberton

1 2 »