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 the NoSQL Database MongoDB.
FireDAC is a powerful, yet easy-to-use access layer that supports, abstracts, and simplifies data access, providing all the features needed to build real-world high-load applications. FireDAC provides a common API for accessing different database back-ends, without giving up access to unique database-specific features and without compromising on performance. Use FireDAC in Android, iOS, Windows, and Mac OS X applications you are developing for PCs, tablets and smartphones.
Here are our Top 10 How-To‘s to help you get things done with FireDAC.
Table of Contents
1. How to Deploy The New FireDAC Driver for SQLite SEE
Embarcadero has made available a new FireDAC driver for the SQLite Encryption Extension (SEE) database. The download is in GetIt and here are some details behind this decision.
RAD Studio 11 Alexandria, like previous versions, ships with a FireDAC driver for the SQLite database offering two different approaches for delivery. One option is static linking, that is, to compile SQLite into your application binary, by linking the compiled code. The second option is dynamic linking, that is, to use an external SQLite DLL.
Read More >>>
2. Learn How Easy It Is To Connect To Microsoft SQL Server Using FireDAC In RAD Studio
Connecting to Multiple Enterprise Databases is no more a time consuming task in making connections and login to databases. 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 the NoSQL Database MongoDB.
Read More >>>
3. Secrets Of FireDAC: Last Inserted Auto Generated Id And Enterprise Connectors
A common pattern when inserting data into a database table which has an auto increment field set on it is to use an SQL query to select the last inserted ID of the newly created record. Once you use your TFDQuery to run your INSERT query you can run this second query to get the newly inserted auto increment ID. Different databases have different SQL queries to accomplish this. MySQL for example has a SELECT query function that you can run called LAST_INSERT_ID() (example: SELECT LAST_INSERT_ID() ). You can run this select directly or use the built in FireDAC feature.
Read More >>>
4. Quickly Learn How To Connect And Manage A SQLite Database For Delphi/C++ Builder With SQLite Sample App
SQLite becomes popular for working with light weight embedded, mobile, IoT, and desktop applications. Do you want your Delphi and C++ Builder Applications to connect with SQLite Database? How to start? Don’t worry, FireDAC offers robust components to connect with MySQL Database.
FireDAC.SQLLite Sample app demonstrates how to use FireDAC to work with SQLite Database. You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Read More >>>
5. This Is How To Easily Process CSV Data Using FireDAC
CSV is an abbreviation for a Comma-Separated Value file that enables data to be saved in a loosely-structured text form. Because of its simple format, it is very easy to process the data inside the file and extremely portable too.
The great thing about the CSV files is that they are compatible with almost any text editor as well as a large number of popular applications such as Microsoft Excel or Google Sheets, making them easy to create, share, and edit.
Read More >>>
6. Learn How Easy It Is To Connect To Microsoft SQL Server In Windows Delphi Development
This sample allows the user to create temporary connection definition at run-time and master-details relationship between datasets using TFDQuery to work with MSSQL databases. You can find the MSSQL sample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesGetting StartedMSSQL
Subversion Repository:
You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Read More >>>
7. Learn About How To Redirect Inserting, Deleting And Updating Records In Delphi With FireDAC
This sample shows how to redirect inserting, deleting and updating records using standalone table adapter. You can find the Commands sample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesDApt LayerCommands
Subversion Repository:
You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Read More >>>
8. Easily Learn To Work With Oracle Stored Procedures In Delphi On Windows With This Sample App
You can find the OraclStoredProc sample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesDApt LayerOracl_StoredProc
Subversion Repository:
You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Description
The OraclStoredProc sample shows you how to work with Oracle stored procedures. Note: This demo requires Oracle Demo connection definition. See Demo Databases.
Read More >>>
9. Optimize Database Population Performance With Array DML In Delphi
This sample demonstrates how to use Array DML in FireDAC and compares its performance for different array sizes. You can find the ArrayDML sample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesComp LayerTFDQueryExecSQLArrayDML
Subversion Repository:
You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Read More >>>
10. Learn How To Easily Manage Database Transactions With This Delphi Sample App
This sample demonstrates how to use the following properties and methods:
The isolation property is used for setting up the transaction isolation level for the transactions managed by FireDAC.
The auto commit property is used to control the automatic transaction management.
The start transaction method is used to start a new DBMS transaction.
The commit method is used to permanently store modifications made in the current transaction to the database.
The rollback method is used to cancel all modifications made in the current transaction to the database.