onthegodaa.blogg.se - Firebird constraint limit

the new file of the nf configuration, with new parameters.

the name of base of security (security.fdb) and other modules - the client, the message file is changed.

SQL - CASE, COALESCE, NULLIF is expanded.

The architecture of Classic for Windows is recovered.

ib_udf expansions (SUBSTR, SUBSTRLEN, ASCII_CHAR)Ģ009 1.5 (1.5.6 of October, 2009, the last release of a branch of 1.5 (End of series))įirebird 1.5 is released based on Firebird 1.0, with the translation of the code with C on C ++.

possibility of grouping on UDF (group by).

CURRENT_USER and CURRENT_ROLE variables.

the record counter for gbak (at the indication of an option - v).

Possibility of the indication of port number in a line of connection.

The CPU_Affinity (Superserver) parameter is added.

The external file is closed if the foreign table is removed.

The number of the external files opened at the same time is increased.

Configuration setting for a task of arrangement of external files.

ForcedWrites now ON by default during creation of a DB.

Support of page size DB the 16th kilobyte.

Problems with file size DB more than 4 gigabytes are removed (except FAT16 and FAT32 where the file cannot be more than 2-4 gigabytes).

Expanded checks of dependences (udf and generators).

Therefore generally the release contains a large number of error corrections of IB 6.0.

The release of Firebird 1.0 is the first version (November, 2001) which is based on open source texts of InterBase 6.0. Not supported versions 1.0 (the last release 1.0.3 of April, 2003)

The history Interbase begins in 1984, thus, the product is a successor more than 20letnego experience with relational databases.

It is commercially independent C and C project ++ programmers, technical advisers and developers of multiplatform database management systems, based on the source code issued by Borland corporation on Jin the form of the free version of Interbase 6.0.Īmong shortcomings: lack of a cache of results of requests, full-text indexes.įirebird is based on the source code InterBase 6.0 which was issued as Open Source by Borland company in August, 2000. Firebird (FirebirdSQL) is the compact, cross-platform, free database management system (DMS) working at Linux, Microsoft Windows and various as Unix platforms.Īs advantages of Firebird it is possible to note the mnogoversionny architecture providing parallel processing of operational and analytical requests (it is possible because the reading users do not block writing), compactness (distribution kit 5Mb), high efficiency and strong language support for stored procedures and triggers.įirebird is used in the different industrial systems (warehouse and economic, financial and state sectors) since 2001.