Delphi DAC

Upgrade DAC products to the newest versions and explore their recent features!

Devart is glad to announce the release of Delphi Data Access Components with support for Lazarus 1.8.4, specific features of cloud and database providers in UniDAC, and much more! (more…)

Useful components, FTP and FTPS protocols support, and much more in the upgraded SecureBridge!

Devart is proud to announce that it has released the new version of SecureBridge, a network security solution. SecureBridge now provides a possibility to connect to a remote host through a proxy server, thus making indirect network connections to various network services. (more…)

Devart presented EntityDAC at this year’s Coderage XII conference

Devart was pleased to participate in the annual online conference for Delphi developers – Coderage XII organized by the Embarcadero company and held on November 7-9, 2017.

During the session, we presented the solution how using ORM for Delphi – EntityDAC can simplify and speed-up the application development process. In our presentation, we used real samples, as well as other Devart products (UniDAC, dbForge Studio for Oracle) to clearly demonstrate this.

(more…)

Fast and Simple Database App Development and Deployment to Linux in RAD Studio

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode in a custom application does not require the installation of client libraries, additional drivers, etc. This helps to avoid the overhead when accessing a DBMS, hence increasing performance.

(more…)

Use VirtualDataSet to Access Objects List via TDataSet Interface

TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms. TVirtualDataSet behaves the same way as any other TDataSet descendant and, therefore, it is compatible with all data-aware controls. However, it does not store data in memory. Work with TVirtualDataSet is implemented by means of events occurring during data exchange between an application and controls. As a result, you can choose a variety of entities as a data storage source: arrays, lists, records, XML files, etc. (more…)

How to Combine Data from Several Sources using SQL and VirtualQuery

The VirtualQuery component allows executing SQL queries to sources that are not a database, but a TDataSet or any its descendant. It also allows you to connect to several data sources at a time and work with them using SQL queries as with a single data source. Thus, work in heterogeneous environment is implemented, when execution results of queries to different sources can be retrieved in a single data set. (more…)

Increasing SQLite Performance

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue.

Perhaps, a classic case everyone gets into when using SQLite for the first time is very slow execution of multiple INSERT/UPDATE/DELETE operations. Indeed, sequential executions of not even thousands, but hundreds of INSERTs into a table may take too long. (more…)

Using Batch Updates in Delphi Data Access Components

Data amount processed by modern databases grows steadily. In this regard, there is an acute problem – database performance. Insert, Update and Delete operations have to be performed as fast as possible. Therefore Devart provides several solutions to speed up processing of huge amounts of data. So, for example, insertion of a large portion of data to a DB is supported in the Loader. Unfortunately, Loader allows to insert data only – it can’t be used for updating and deleting data.

(more…)

Disabling Direct Mode in LiteDAC and UniDAC

LiteDAC and UniDAC interact with SQLite in 2 approaches. The first approach is that an application uses functions of the linked SQLite library. For Windows OS it is sqlite3.dll, for Mac OS and iOS – libsqlite3.dylib, for Android – libsqlite.so. The second approach allows to connect to the database from the application directly, using so called Direct Mode. Direct Mode provides interaction with SQLite avoiding any external libraries linking. It is implemented by embedding the code of the SQLite library directly to the application. This approach allows to work with SQLite in cases, when using third-party libraries is impossible due to a number of reasons. For example, when developing applications for iOS or Mac OS, the Apple corporation prohibits deployment of any libraries along with the application.

(more…)

Resolving RAD Studio XE7 Update 1 and RAD Studio XE8 Installation Crash

Since RAD Studio XE7 Update 1 was released, the ETTracker.dll library was added to installation. Its purpose is obscure, but its presence in the installation caused serious problems for Windows XP users when installing RAD Studio XE7 Update 1. (more…)