Sqlite under FireDAC [1]-Preface

Source: Internet
Author: User


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

Delphi XE5 merged into the FireDAC, first impression is very good, I'm afraid dbexpress and so on have to step aside.



Let me most happily is FireDAC to the support of Sqlite!
Excellent Sqlite has long been a lot of Delphi packaging (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers, from https://code.google.com/, etc. can also search more).
There are static references to obj, there are dynamic link DLLs, there is a DLL embedded in the resource file, and even rewritten (just seen a set of C # rewrite code).

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

Now, with the FireDAC, with FireDAC more perfect support for Sqlite (it does not use System.Sqlite.pas), in particular, it is necessary to note that the Windwos platform under the default use of Sqlite3_x86.obj or sqli Te3_x64.obj (FireDAC.Phys.SQLiteCli.pas), not DLLs, plus Sqlite would not need other deployments, too convenient.

Since then, whether it is writing local programs, mobile programs (SQLite is andriod system database), network programs I will use Sqlite, I am afraid that in the need for memory tables, INI files, and even the definition of a file format, I would think of it.
So, we must learn the essence of it thoroughly!

It is estimated that at least it will write down 20 blog posts, if you want to study with me, quickly install XE6 bar (XE5 I have not installed, Lsuper make the embarcadero.delphi.xe6.lite.v9.x should be more convenient installation, here together thanked!).

Hope to finish this as soon as possible, and then learn to learn intraweb (it should be mature) and mobile development, talk about mobile development to everyone for help " ways to upgrade the Andriod system"I bought a few years ago the Samsung GALAXY Big Tablet Phone (Hong Kong), the system is andriod 2.1, just enough to not; Who has done, please teach me under; It is better if there are methods that can be used for testing without upgrading.
After installing the 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):




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.