Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: SQLiteDAC for Delphi



Permlink Replies: 2 - Last Post: Jan 25, 2018 2:49 AM Last Post By: Bismark Appah Threads: [ Previous | Next ]
Bismark Appah

Posts: 26
Registered: 3/13/15
SQLiteDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 14, 2018 9:19 AM
SQLite Data Access Components (SQLiteDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQLite database from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based applications connect to SQLite database directly through the SQLite.Net, which is an ADO.NET provider for SQLite. SQLiteDAC is designed to help programmers develop faster and cleaner SQLite database applications with no need to deploy any additional libraries. SQLiteDAC is lightweight and performs well because it is optimized to access SQLite databases directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

NB: SQLiteDAC is part of the ADO.Net VCL for Delphi.

Key Features:
- Direct access to SQLite database. Does not require installation of other data provider layers (such as BDE).
- Interface compatible with standard data access methods, such as BDE and ADO.
- Full support of the latest versions of SQLite.
- Support for all SQLite data types.
- Transmission is via XML format, therefore can pass through firewalls.
- High overall performance.
- Fast controlled fetch of large data blocks.
- High performance of applying cached updates with batches. This is controlled by UpdateOptions.UpdateBatchSize property.
- High performance batch processing.
- Intelligent fetch block size control.
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property.
- CachedUpdates operation mode which is controlled UpdateOptions.UpdateMode property.
- Automatic data updating with TSQLiteQuery, TSQLiteTable, and TSQLiteStoredProc components.
- Advanced connection pooling.
- Fast data retrieval with TSQLiteDataReader component or using Server CursorKind property of the TCustomClrDataSet.
- Automatic record refreshing and locking.
- Automatic query preparing.
- Data export and import to/from XML.
- Advanced design-time component and property editors.
- Unicode support.
- Easy to deploy.
- and many more.

For more information go to https://crystalnet-tech.com/ADONetVcl/SQLiteDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Shlomo Abuisak

Posts: 100
Registered: 9/18/10
Re: SQLiteDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 17, 2018 12:12 PM   in response to: Bismark Appah in response to: Bismark Appah
On 14/01/2018 19:19, Bismark Appah wrote:
SQLite Data Access Components (SQLiteDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQLite database from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based applications connect to SQLite database directly through the SQLite.Net, which is an ADO.NET provider for SQLite. SQLiteDAC is designed to help programmers develop faster and cleaner SQLite database applications with no need to deploy any additional libraries. SQLiteDAC is ligh
tweight and performs well because it is optimized to access SQLite databases directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

NB: SQLiteDAC is part of the ADO.Net VCL for Delphi.

Key Features:
- Direct access to SQLite database. Does not require installation of other data provider layers (such as BDE).
- Interface compatible with standard data access methods, such as BDE and ADO.
- Full support of the latest versions of SQLite.
- Support for all SQLite data types.
- Transmission is via XML format, therefore can pass through firewalls.
- High overall performance.
- Fast controlled fetch of large data blocks.
- High performance of applying cached updates with batches. This is controlled by UpdateOptions.UpdateBatchSize property.
- High performance batch processing.
- Intelligent fetch block size control.
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property.
- CachedUpdates operation mode which is controlled UpdateOptions.UpdateMode property.
- Automatic data updating with TSQLiteQuery, TSQLiteTable, and TSQLiteStoredProc components.
- Advanced connection pooling.
- Fast data retrieval with TSQLiteDataReader component or using Server CursorKind property of the TCustomClrDataSet.
- Automatic record refreshing and locking.
- Automatic query preparing.
- Data export and import to/from XML.
- Advanced design-time component and property editors.
- Unicode support.
- Easy to deploy.
- and many more.

For more information go to https://crystalnet-tech.com/ADONetVcl/SQLiteDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Missing pas files compiling with Delphi 10.2.1

CNADONetVCLD18
CNClrLib.Host,
CNClrLib.Core,
CNClrLib.Data,
CNClrLib.EnumTypes
Maybe more
Bismark Appah

Posts: 26
Registered: 3/13/15
Re: SQLiteDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 25, 2018 2:49 AM   in response to: Shlomo Abuisak in response to: Shlomo Abuisak
shlomo abuisak wrote:
On 14/01/2018 19:19, Bismark Appah wrote:
SQLite Data Access Components (SQLiteDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQLite database from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based applications connect to SQLite database directly through the SQLite.Net, which is an ADO.NET provider for SQLite. SQLiteDAC is designed to help programmers develop faster and cleaner SQLite database applications with no need to deploy any additional libraries. SQLiteDAC is ligh
tweight and performs well because it is optimized to access SQLite databases directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

NB: SQLiteDAC is part of the ADO.Net VCL for Delphi.

Key Features:
- Direct access to SQLite database. Does not require installation of other data provider layers (such as BDE).
- Interface compatible with standard data access methods, such as BDE and ADO.
- Full support of the latest versions of SQLite.
- Support for all SQLite data types.
- Transmission is via XML format, therefore can pass through firewalls.
- High overall performance.
- Fast controlled fetch of large data blocks.
- High performance of applying cached updates with batches. This is controlled by UpdateOptions.UpdateBatchSize property.
- High performance batch processing.
- Intelligent fetch block size control.
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property.
- CachedUpdates operation mode which is controlled UpdateOptions.UpdateMode property.
- Automatic data updating with TSQLiteQuery, TSQLiteTable, and TSQLiteStoredProc components.
- Advanced connection pooling.
- Fast data retrieval with TSQLiteDataReader component or using Server CursorKind property of the TCustomClrDataSet.
- Automatic record refreshing and locking.
- Automatic query preparing.
- Data export and import to/from XML.
- Advanced design-time component and property editors.
- Unicode support.
- Easy to deploy.
- and many more.

For more information go to https://crystalnet-tech.com/ADONetVcl/SQLiteDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Missing pas files compiling with Delphi 10.2.1

CNADONetVCLD18
CNClrLib.Host,
CNClrLib.Core,
CNClrLib.Data,
CNClrLib.EnumTypes
Maybe more


Hello Shlomo,

During the installation, the installer downloads and automatically installs the .Net Runtime Library for Delphi (Required for building the ADO.Net App only but not required if the app is deployed).

If the Runtime Library has not been installed, then download and install a copy from https://www.crystalnet-tech.com/RuntimeLibrary/RuntimeLibraryFileDownload.ashx?filename=DotNetRuntimeLibrary4Delphi_Trial.exe

Best of luck

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02