FireDAC is Embarcadero’s library for universal data access – connection to just about any database protocol you can find. It abstracts the protocol-level details and presents a common interface so developers can build their applications to be database agnostic and flexible in the event of future design changes.
My work this week focused on FireDAC and local databases. SQLite is…
TheMacrossample shows you how to use theMacrosproperty ofTFDQueryin order to parameterize parts of the SQL query. The sample allows you to modify the macro values at run time.
Location
You can find theMacrossample project…
Optimize Database Population Performance With Array DML In Delphi
October 25, 2020
This sample demonstrates how to use Array DML in FireDAC and compares its performance for different array sizes.
Location
You can find theArrayDMLsample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samplesand then navigate…
The FireDAC.TFDLocalSQL MegaFMX sample is divided in three tabs where each tab demonstrates single Local SQL usage case.
Each tab has dedicated SQLite in-memory connection established using theTFDConnectionwith only single parameterDriverID=SQLite. When noDatabaseparameter value is specified then FireDAC SQLite driver opens an in-memory connection. It will be used…
Building a C++ VCL Customer/Sales Master/Detail/Charting Application with 1 Line of Code
October 22, 2020
You may have read or heard about No Code and Low Code application development using systems, languages and run times. Atanas Popov, GM of Embarcadero Technology, recently blogged about low code development. “These days low-code development is en vogue. Various research…
TheBatchsample shows you how to useArray DMLto execute multiple SQL INSERT commands in a single step to optimize database population performance. In this demo the “batch” and “Array DML” terms are…
This sample uses theConnectionDefNameproperty of theTFDConnectionto specify the name of the connection definition to use.
Location
You can find theTFDConnection\InfoReportsample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:Object Pascal\DataBase\FireDAC\Samples\Comp Layer\TFDConnection\InfoReport.GitHub…
Build High Performance REST Services With This Server-Client EMS FireDAC Demo In Delphi
October 21, 2020
This sample demonstrates how to use an EMS package to extend the EMS Server to connect to an SQLite database using FireDAC components.
he sample accesses an SQLite database. The connection parameters are defined in the TFDConnection component. If you experience problems…
Learn How To Use The Oracle Continuous Query Notification (CQN) Feature With Delphi FireDAC On Windows
October 16, 2020
TheOracle_CQNsample shows you how to useContinuous Query Notificationwith Oracle databases using FireDAC.
Location
You can find theOracle_CQNproject at:
Start | Programs | Embarcadero RAD Studio Sydney | Samplesand then…
The FireDAC is a universal data access library for developing applications for multiple devices, connected to enterprise databases. With its powerful universal architecture, FireDAC enables native high-speed direct access from Delphi and C++Builder to InterBase, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Firebird, Access, Informix, DataSnap, and more, including…
