SQLite in the Firedac (i.)

Windows client SOFTWARE,FIREDAC supports both SQLite library linking modes:

• Static linking: The x86 sqlite3_x86.obj or x64 Sqlite3_x64.obj client library is statically linked into Applicati Mnl FireDAC provides Sqlite3_xxx.obj v 3.7.15. that's default mode, no additional files or actions is required. Note, SQLite database encryption is supported only for static linking.
• Dynamic linking: The x86 or x64 SQLITE3. DLL client library must is available to open a SQLite database. The recommended SQLITE3. DLL versions is 3.7.7.1 or higher. That's default mode for non-windows platforms.

From FIREDAC's help we see that in the Windows Platform programming environment, the default is static linking mode (statically linked). In this way, in the development of local programs, green programs will be very convenient, data management is also very comfortable.

With FireDAC, we can discard other third-party sqlite solutions, such as the DISQLite3 controls that were introduced earlier, are certainly not FireDAC easy to use, and are self-contained in the XE6 version without installation. Next, we take into account the teacher's "FireDAC under the Sqlite" blog to study and research.

XE6 version:embarcadero.delphi.xe6.rtm.inc.update1.v20.0.16277.1276.lite.v9.1.exe (file size: 369, 070, Byte), Remember to check the FIREDAC component when installing.

There is a "FireDAC Explorer" under the Tools menu in the XE6 IDE, and we open it for browsing, where Fddemo.sdb is officially available.

Remember to set the path to the Fddemo.sdb file and set pooled to True, and if set to False, each time you browse you will be prompted with the following dialog box:

So far, we have entered the door of FIREDAC ...

SQLite in the Firedac (i.)