Overview (FireDAC)
Go Up to FireDAC
FireDAC is a unique set of Universal Data Access Components for developing multi-device database applications for Delphi and C++Builder. With its powerful common architecture, FireDAC enables native high-speed direct access from Delphi to InterBase, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, Access, Firebird, Informix and more.
Description
Based on 10 years of experience writing native drivers for database back-ends, FireDAC was built as a powerful access layer that supports 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, or compromising on performance.
FireDAC Benefits
- FireDAC is the fruit of 10 years of experience in developing real-world database applications.
- FireDAC enables the developer to concentrate on developing the application, not on the complexities of database interaction.
- FireDAC provides a modern feature-rich set of components to address all major RDBMS environments.
- FireDAC uses one set of components to address all supported RDBMS types.
- FireDAC reduces the Total Cost of Ownership by providing:
- Less initial cost, compared to separate expensive libraries.
- Less time required to learn and become familiar with the unique powerful libraries.
- Straight-ahead application design and development when targeting different databases.
FireDAC Core Features
Native access
Enterprise:
Workgroup:
Database in clouds:
- Microsoft SQL Azure
Desktop:
Embedded:
Multi-tier:
Generic access
Provided through bridge drivers to:
Enterprise:
- Sybase Adaptive Server Everywhere
- SAP MaxDB
- IBM AS/400
Workgroup:
- Ingres Database
- Nexus Database
Desktop:
- Microsoft SQL Server CE
- Microsoft Excel
Legacy:
- MicroFocus Cobol
- DBase
- FoxPro
- Paradox
- Clarion
Multi-Device support
- Delphi Win32, Win64, OSX32, iOS, Android
- C++Builder Win32, Win64, OSX32
API
- Fast and Powerful Delphi DataSets
- ADO.NET-like data engine
- 60 Delphi Components
Unification
- Data Types
- SQL Dialects
- SQL Script Dialects
- Data Editing
- Auto-Incrementing Fields
- Error Reporting
- Quoted Identifiers
- Transaction Support
- Login and Password Changing
- Database Event Support
- Data Moving, Exporting and Importing
- Metadata Retrieval
- Records Paging and Counting
- Master-Detail Relationship
Performance
- Rowset Fetching
- Array DML Execution
- Live Data Window
- Command Batches
- Asynchronous Command Execution
- Command Execution Canceling
- Metadata Caching
- Update Commands Caching
- Connection Pooling
- Faster than dbGo and dbExpress
Advanced
- Options Inheritance System
- Automatic Connection Recovery
- Disconnected Mode
- Centralized Cached Updates
- Dataset Persistence
- International applications
- DB services (backup, restore, etc)
- Local SQL Engine
Other
- Debugging Support
- Design Time Support
- Utilities
3rd Party Integration
- EhLib
- FastReport
- Quantum Grid
- ReportBuilder
- TMS Advanced Grid
Clarity
- 100% source code