Firebird 1.5 SQL Temporary Reference Update

This guide documents the changes made in Firebird 1.0 and 1.5 SQL since the fork from the open-sourced InterBase 6.0 codebase.

Here is the Pual Vinkenoog’s announcement on firebird-docs list

Just uploaded a Firebird 1.5 SQL Update Reference to this temporary location:

This is NOT ready for publication yet, but all the entries are there and (AFIACT) correct, except maybe in one or two places where I have to contact the developers for clarification.

I’ll commit the DocBook sources to the repository and build a version for publication. After that, I’ll start working on update refs for 2.0 and 2.1. After that, I guess we must take the 2.1 ref and start expanding it to a complete Firebird SQL reference. This last step may take some time ๐Ÿ˜‰

Running program from trigger, SP

This article was originally created for Databazovy Svet (in Czech) and covers a little bit more about this topic. This shortened version is focused only on solutions for Firebird, without any other stuff.

Firebird 2.1 to be included in the top of most popular distributions

Firebird 2.1.x will be included in the top most popular linux distributions

Firebird and Suse

Since I helped Mandriva to do their packages for Firebird, I jumped and with Michal, we made things happen
Users of Opensuse 10.0,10.1,10.3 and future 11.0 but also SLE 10 can now just use the server:database repository ย and get Firebird 2.0.4
As soon as the Firebird Project will publish Firebird 2.1.1, packages will be there too.

Testing needed for Firebird 2.0.4 and Firebird 2.1.0 packages for debian

As you may have noticed, debian experimental got firebird2.0 (2.0.4) and
firebird2.1 (2.1.0).

I would really appreciate if you give these some testing.

Firebird 2.1 CTE are supported by Active Query Builder

Active Query Builder logo

Active Database Software announced release of the new minor version of Active Query Builder, a true two-way visual SQL query builder component that allows end-users to build complex SQL queries via the intuitive visual interface. The component is available as VCL and ActiveX control, as well as .NET WinForms component.

Recent improvements include:

  • Support of Common Table Expressions (CTE) for Firebird 2.1 and higher,

Performance improvement by using firebird client from cvs head

He doubled his performance by just switching the firebird client :

We’ve just built and tested ‘libfbclient.so’ from the head branch and tested
it against the release version 2.0.3. In other words, we only switched out
the client library, and left the database server itself intact at version
2.0.3.

Firebird Data Wizard 8.4 released

SQL Maestro Group announces the release of Firebird Data Wizard 8.4, a powerful Windows GUI utility for Firebird data management.

New version features:

  • Now it is possible to create a system scheduled task or convert a task created in Data wizard to system one.
  • Command line options have been implemented.
  • Since this version each task is displayed as a separated icon in the system tray when executing.
  • PHP Generator: a lot of new features. See full press-release for details.
  • Data Pump: now you can execute custom SQL scripts after connecting, before data importing and after pumping.
  • ASP.NET generator: since this version it is possible to specify a custom connection string.
  • All the wizards: a lot of minor improvements and corrections were made.

There are also versions for other DBMS (MySQL, Oracle, SQL Server, DB2, PostgreSQL, etc). Read full press release.

1 38 39 40 41 42 57