Database selection and Firebird use

Recently, a small project was created, and the development tool was Delphi. The database selection was compared, and the Firebird Database was finally used. The advantages and disadvantages of various databases were analyzed as follows:

I,Firbird

Advantages

1,Firebird is an open-source free database that has been around for many years and is relatively stable.

2,Supports standalone embedded development and standalone edition supports stored procedures and triggers.

3,The single-host and server database files are in the same format. It is easy to upgrade to the network version.

4,Cross-platform support for Windows and Linux

Disadvantages:

1,The oledb driver is charged, so you cannot use ADO to connect to the database.

2,SQL syntax differs from Microsoft's T-SQL syntax, especially for stored procedures.

3,Several DLL files need to be published.

It doesn't matter if you have 1st disadvantages. You can use dbexpress. Anyway, the database access technology currently promoted by Delphi is dbexpress. It's okay to get familiar with it.

It doesn't matter if there are 3rd. Just package and copy it.

II,Access Database

Advantages

1,You can use ADO for access, not to say that ADO is good, but rather familiar. It has been used for many years.

2,The release is simple, and no driver files need to be attached. Who makes it Microsoft? The oledb driver has been integrated into the operating system.

3,An Office Access Manager is available, which makes it easier to create and modify tables.

Disadvantages:

1,Library files are vulnerable to corruption. In my experience, the power is cut off when data is turned on, which is very easy to damage and very troublesome. Firebird has no experience. It is estimated that this problem will be better.

2,Stored Procedures and triggers are not supported.

3,The network version is not supported. This is the most terrible thing. In the future, it will take a lot of effort to upgrade to the online version to change to sqlserver.

Iii. MSDE Database

Advantages

1,Powerful functions, familiar with T-SQL syntax, available for enterprise managers, powerful functions, and copyright issues for enterprise managers.

2,Supports ADO access, which is also the best access method.

3,Seamless upgrade from standalone to online.

Disadvantages

1,The size is too large, with 40 MB.

2,Installation is required. This is the most troublesome problem. Due to viruses and piracy, customers' machines often reload the system and reload the system each time. Although the installation package provided by Microsoft can be installed successfully, there is still a gap with zero configuration.

The comparison and analysis above are related to my personal development experience and familiar technologies. I think the first choice for development on Windows is MSDE database, which is powerful, stable, and complete with documents, however, due to installation problems, you have to give up and the installation is not complicated. It is troublesome for you to reinstall the system every time (this is often the case, after the reinstallation, you also need to restore the database and other operations, which is not conducive to the use of ordinary users. Considering the computer level of most users in China and the operating system environment of a large number of pirated software, which is full of virus, Trojan, and rogue software, frequent system reinstallation is inevitable. Therefore, I prefer green software, especially product-based management software. Zero Configuration is particularly important.

Although Firebird database does not necessarily have the powerful functions of sqlserver, it can meet general application requirements and facilitate network release. Zero Configuration can minimize the amount of after-sales service. It is said that there are a lot of software abroad that uses the Firebird Database, and there must be some truth.

Use dbexpress to connect to the Firebird Database

Connecting to the Firebird Database in Delphi has many solutions, such as ibx, Ibo, and oledb. There are also many other components, including commercial components and free components. In the long run, I think it's safer to use Delphi's native dbexpress without special reasons.

Embedded Version (embedded) Connection

Rename fbembed. DLL to gds32.dll and directly use the Interbase dbexpress driver to connect smoothly. You can also change the vendorlib attribute of tsqlconnection to fbembed. dll.

It should be noted that the embedded version cannot connect to the database during design, but can only be connected at runtime, and dll library files such as fbembed. dll must be used in the ApplicationProgramIn the same directory. It may be possible to connect at design time, but I did not solve the connection at design time. I think the connection at design time is not necessary.

Some comrades suggested using the server version during development, while using the embedded version during release. I think it is a very good idea, because the embedded version has another problem: only one application can connect to the database file, which makes it difficult to modify the database structure during design. Therefore, it is very important to use the server version during development, by the way, the connection problem during design is solved.

The Firebird embedded version does not support database passwords. Some comrades suggest creating dedicated users even if they do not support database passwords, rather than using sysdba, so that sysdba users can be protected when they are upgraded to the server in the future, this also makes sense.

Download Firebird Database and management tools

1. flamerobin 0.9 is a free and open-source Firebird Management tool.

:Http://www.flamerobin.org/

2,IB expert's professional Firebird tool is similar to sqlserver's Enterprise Manager and commercial software.

:Http://www.ibexpert.com

3. Firebird Official Website:Http://www.firebirdsql.org/

4. Firebird ChineseCommunity:Http://www.firebird.net.cnIt brings together many Firebird experts.