Speaking of SGDB Firebird , when using GDS32.dll library, out of compatibility with banks created by Interbase , are there other differences when using fbclient.dll ?
Is there a difference between creating banks with the .fdb extension instead of using .GDB ?
Firebird is an open source DBMS that came into being when version 6.0 of Interbase had its code open to the community under the IPL license Interbase Public License. However the new versions of Interbase remained with their source code closed and from then on Firebird and Interbase happened to be distinct things, that is, Firebird was a fork of Interbase 6.0.
For this reason most things are compatible between them, however I always recommend using fbclient.dll , as you may be surprised in some situation that the BDs ended up differing.
As for the extension, it does not affect what depends on the DBMS, it is good to use .fdb to make it clear that the database you are using is Firebird, not Interbase. In what depends on the operating system there is an inconvenience when working with Windows, since from Windows XP and its recovery system the .gdb extension is part of a list of extensions that are copied every time the file is changed. Because Firebird modifies the file for every transaction if the database is very large, performance can be greatly impaired.
Sources: ClubeDelphi and Firebird FAQ
When installing firebird it offers the dll copy as GDS32.ddl only for compatibility purposes, both are the same and therefore there is no difference.
As for length, it also makes no difference. In each company I worked with they used a different extension for the bank and rarely the default.
