postgresql Archives - Firebird News

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

(6 votes, average: 5.00 out of 5)

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.

(1 votes, average: 5.00 out of 5)

#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

(1 votes, average: 5.00 out of 5)

#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

(2 votes, average: 5.00 out of 5)

#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

(1 votes, average: 5.00 out of 5)

#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

(1 votes, average: 5.00 out of 5)

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

(No Ratings Yet)

Sun to Begin Close Sourcing MySQL – time for alternatives like firebird

April 17, 2008 mariuz Leave a comment

“From the MySQL User’s Conference, Sun has announced, and former CEO Marten Mickos has confirmed, that Sun will be close sourcing sections of the MySQL code base.”

Read the rest of the article on slashdot

There are many posts about firebird too

Also another interesting blog about this community split

(No Ratings Yet)

1 2 »