The preface of Sqlite (a) under Delphi FIREDAC

For a long time did not calm down to write a blog, and now come back, is the Delphi continuous progress let me moved, excited.

Delphi XE5 merged into the FIREDAC, the first impression is very good, I am afraid dbexpress and so on to step aside.

Let me be most happy is FIREDAC to Sqlite support!

Excellent Sqlite already have a lot of Delphi packaging (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers, from https://code.google.com/and so on can also search more).

There are static references to obj, dynamic link DLLs, and the DLL embedded in the resource file, and even rewrite (just see a set of source code rewritten in C #).

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/Programming/Delphi/

Delphi first introduced Sqlite, should be in XE3 (provided the System.sqlite unit), it seems just to support DBX, also need Sqlite.dll support.

Well now, with the FIREDAC, with FIREDAC's more complete support for Sqlite (it's not using System.Sqlite.pas), it's particularly necessary to note that Windwos or sqlite3_x86.obj are used by default under the Sqli platform Te3_x64.obj (FireDAC.Phys.SQLiteCli.pas), not DLLs, plus the fact that Sqlite did not need other deployments, was too convenient.

From then on, whether write local program, mobile program (Sqlite is andriod system database), network program I will use Sqlite, I am afraid in need of memory table, INI file, even the definition of a file format, I will think of it.

So, be sure to learn the essence of it!

Estimated to learn it will at least write down 20 blog posts, if you also want to learn with me, quickly install XE6 bar (XE5 I have not installed, Lsuper embarcadero.delphi.xe6.lite.v9.x should be more convenient to install, here thanks!).

I hope to learn this as soon as possible, and then learn intraweb (it should be mature) and mobile development, when it comes to mobile development to everyone to help " upgrade the Andriod system ", I bought a few years ago the Samsung GALAXY Big Tablet Phone (Hong Kong), the system is Andri OD 2.1, just enough; Who has done, please teach me under; It is better if there are methods that can be used to test without upgrading.

After installing XE6, first use FIREDAC Explorer to browse the official Fddemo.sdb Bar (actual path: C:\Users\Public\Documents\Embarcadero\Studio\14.0\Samples\ DATA\FDDEMO.SDB):

Author:cnblogs in case