TMS RemoteDB is a set of Delphi components enabling developers to create high‑performance, cross‑platform, scalable, 3‑tier database applications. It allows client applications to perform SQL operations on a remote HTTP server instead of directly accessing a database server, using a TDataset descendant. This dramatically simplifies migrating existing client‑server Delphi applications into modern 3‑tier architectures with minimum changes in source code. The RemoteDB Server receives HTTP requests from clients and forwards SQL operations to the actual database server using a chosen database-access component (FireDAC, dbExpress, ADO, UniDAC, and others). The result is returned transparently to clients through a TXDataset instance. Client applications work as if they were connected directly to the database, maintaining full compatibility with existing dataset components, fields, parameters, and datasource structures. TMS RemoteDB supports Windows, macOS, iOS, and Android on the client side, provides HTTPS, gzip and chunked response handling, and kernel‑mode HTTP server features on Windows. It also integrates seamlessly with TMS Aurelius, allowing existing Aurelius-based applications to become 3‑tier applications instantly by switching the connection adapter.

Features

Core Capabilities

• Allows Delphi applications to perform SQL operations on a remote HTTP server instead of a database server
• Uses a TDataset descendant, making client‑server migration to 3‑tier easy with minimal code changes
• Fully cross-platform and scalable
• Blazing fast with optimized memory usage
• Keeps existing dataset behavior (e.g., TFieldDefs)
• Supports FireDAC, dbExpress, UniDAC, and other database-access components Architecture (Server Side)
• RemoteDB Server is a Delphi application/service that listens to HTTP requests
• Forwards SQL operations to the actual database server using chosen adapters
• Supports a wide range of components: FireDAC, dbExpress, dbGo (ADO), ElevateDB, NexusDB, SQL‑Direct, UniDAC, Advantage Database Server
• Works with any thread‑safe database server supported by these components
• Supports HTTP Secure (HTTPS)
• Based on http.sys on Windows:
  • Kernel-mode caching
  • Kernel-mode request queuing
  • SSL support in kernel-mode
  • Multiple processes can respond on the same port Client Features
• HTTP client available on Windows, macOS, iOS, Android
• Supports HTTPS
• Handles chunked and gzip‑encoded responses transparently
• Full dataset experience: SQL, Open, ExecSQL, Params, Fields, Datasource, etc.
• Multiple TXDataset components can be linked to one TRemoteDBDatabase connection TMS Aurelius Integration
• Existing Aurelius apps can become 3‑tier with no code changes except switching the connection adapter
• Aurelius provides a RemoteDB adapter via IDBConnection Supported Platforms
• Windows 32‑bit (Client & Server)
• Windows 64‑bit (Client & Server)
• macOS (Client)
• iOS (Client)
• Android (Client)

Benefits

• Minimal migration effort: Convert existing client‑server apps to 3‑tier with almost no code changes.
• High performance: Optimized memory usage and fast SQL transport make it suitable for heavy workloads.
• Scalable distributed architecture: Server‐side adapters give flexibility to fine‑tune connection behavior.
• Cross‑platform client support: Build modern, distributed apps for desktop and mobile systems.
• Developer productivity: Full dataset compatibility means no need to rewrite database layer logic.
• Secure & modern: HTTPS, gzip compression, and kernel‑mode HTTP features ensure efficient and secure transport.
• Perfect for enterprise systems: Remote access, multi-tier scaling, and seamless Aurelius integration support large‑scale applications.