SecureBridge 11.0, EntityDAC 3.5, and dbExpress Drivers: Latest Versions Released

We are excited to announce a new release of SecureBridge, EntityDAC, and the dbExpress product line. This update introduces support for the newest RAD Studio version, enhances compatibility with popular databases, and adds new components and options to simplify development and strengthen security.

What’s new

SecureBridge 11.0

• Added support for RAD Studio 13 Florence.
• Added support for Lazarus 4.2.
• Added support for system proxy settings in TScWebProxy and TProxyOptions.
• Added a demo for the TScCMSProcessor component.
• Introduced the brand-new RestClient component with full demo samples.

A key addition in this release is the TScRestClient component in SecureBridge, designed to streamline communication with REST services. It represents the entire REST service within your application, with individual requests handled by TScRestRequest objects.

The component supports authentication through the Authenticator property, which references objects capable of handling standard and custom authentication methods. This greatly simplifies integration with external APIs, making applications more secure and easier to maintain.

Example usage

begin
  // setup the RestClient object to reflect REST-service
  var RestClient := TScRestClient.Create(nil);
  RestClient.BaseURL := 'https://rest-server.com/api/v1';
  RestClient.OnRequestPrepare := RestClientRequestPrepare;
  RestClient.OnRequestSuccess := RestClientRequestSuccess;
  RestClient.OnRequestError := RestClientRequestError;
  RestClient.OnGetFromCache := RestClientGetFromCache;
  RestClient.OnPutToCache := RestClientPutToCache;

  // setup the Authenticator object
  RestClient.Authenticator := TScBasicAuthenticator.Create('username', 'password');

  // setup the RestRequest objects
  var GetTransactions := TScRestRequest.Create(nil);
  GetTransactions.RestClient := RestClient;
  GetTransactions.Method := rmGET;
  GetTransactions.Endpoint := 'transactions';
  GetTransactions.FillByRestClient;

  // send request and receive response
  Result := GetTransactions.Execute.ReadAsString;
end;

EntityDAC 3.5

• Added support for RAD Studio 13 Florence.

dbExpress Drivers

We have introduced full support for RAD Studio 13 Florence across the entire product line, enabling developers to seamlessly work with the latest IDE features and capabilities.

dbExpress Driver for MySQL

• Added support for MariaDB 12, UUID, INET4/INET6
• Extended support for the Vector data type for AI-based applications.

dbExpress Driver for Oracle

• Added support for passwords longer than 30 characters in Direct mode for Oracle 23.

dbExpress Driver for PostgreSQL

• Added a new RequiredFields option for automatic mapping of NOT NULL fields.

dbExpress Driver for SQLite

• Added a new RequiredFields option for automatic mapping of NOT NULL fields.
• Added support for an ISO8601-like time format via the new TimeFormat property.

dbExpress Driver for SQL Server

• Added MultipleConnections parameter for better performance.
• Expanded support for the Encrypt parameter with Optional, Required, and Strict values.

New to our tools? Here’s what makes them stand out:

• dbExpress Drivers — Independent libraries for Oracle, MySQL, PostgreSQL, SQL Server, SQLite, InterBase, and Firebird. They deliver lightning-fast data access for applications without requiring client software.
• EntityDAC — A robust ORM for Delphi with built-in LINQ support. It supports database-first, model-first, and code-first approaches, giving developers maximum flexibility.
• SecureBridge — A reliable solution to protect TCP traffic using SSH, SSL, and Cryptographic Message Syntax (CMS). It ensures strong authentication, end-to-end encryption, and data integrity verification.

Refer to the product revision histories in the table below for a detailed list of changes.