This all-editions release brings native SSH and file transfer, HTTP/2, full-text search, richer SQL, messaging, authorization and AI integrations. Performance work spans lock contention, lock-free data structures, thread reuse, memory allocation, statistics collection and HTTP throughput.

If you like kbmMW, please let others know! Share the word!

We strive hard to ensure kbmMW continues to set the bar for what an n-tier product must be capable of in the real world!
Please check the end of this post for a detailed change list.

This release require the use of kbmMemTable Professional v. 8.25.00 (Pro/Ent).
Community Edition installer includes Community Edition of kbmMemTable.

The release includes:

  • Compiles using latest versions of Delphi and MIMERPascal (MIMER Polyglot Compiler)
  • Native SSH2, SFTP, FTP and FTPS clients and servers let Delphi applications run remote commands, transfer files and host their own endpoints.
  • The native HTTP server gains HTTP/2, WebSockets, Brotli and gzip compression, and TLS certificate renewal without a restart.
  • ORM field declarations now create full-text indexes on SQLite, PostgreSQL, MySQL, SQL Server and Oracle, all searchable with the same CONTAINS query.
  • New native adapters connect to PostgreSQL, Firebird/InterBase and ODBC, while the SQL rewriter gains recursive queries, window frames and broader upsert support.
  • Store-and-forward clients can retain messages across disconnects and retry them in queue order, while servers can defer acknowledgements until processing finishes.
  • Native SMTP, IMAP and POP3/POP3S clients support email, and Microsoft Graph integration lets applications send mail and read Microsoft 365 mailboxes.
  • Policy-based authorization adds rules and conditions, while actor and role categories simplify bulk administration.
  • Licensed AI integrations add streaming chat, tool calls and embeddings, alongside access to theMIMER retrieval, web and conversation memory APIs.

kbmMW 5.25.00 is released for Community Edition (Delphi 13/Win32 only), Pro and Enterprise Edition.

This release gives Delphi developers both ends of an SSH connection, clients and servers for three file transfer protocols, and a native HTTP server with HTTP/2 and WebSocket support. On the data side, the ORM can turn a field declaration into a working full-text index on five database engines. There are also new database adapters, more control over message delivery, and integrations for Microsoft 365 and AI services. The features available in a particular installation depend on its licensed edition.

SSH, SFTP, FTP and FTPS, on both sides of the connection

The networking additions are built on kbmMW’s own asynchronous socket stack. They cover applications that connect to an existing service as well as applications that need to host one.

ProtocolWhat ships in 5.25.00
SSH2An SSH2 transport, client and server for remote command execution. An application can issue a command to an SSH service or host the endpoint that receives it.
SFTPAn SFTP client and server built on the new SSH2 transport. You can retrieve files from a partner’s SSH endpoint or provide an SFTP endpoint for incoming transfers.
FTP and FTPSA client and server for FTP and FTP over TLS. Passive FTPS transfers support TLS session reuse with both OpenSSL and Windows SChannel.
SMTP, IMAP and POP3/POP3SNative mail clients for sending and retrieving messages, with MIME support for message content and attachments.
HTTP and WebSocketA native HTTP/1.1 client and asynchronous server, plus opt-in HTTP/2 and WebSocket support on the server.

There are new options below the protocol layer, too. A synchronous socket client lets application code use blocking reads and writes with a pluggable TLS backend. TkbmMWSyncServer brings that programming model to accepted connections, including server-side STARTTLS and receive limits. On Windows, the SChannel backend uses the operating system’s TLS implementation and requires no OpenSSL DLLs.

HTTP/2, live browser updates and certificate renewal

Enable EnableHttp2 on the native HTTP server and HTTPS clients can negotiate HTTP/2 or HTTP/1.1 on the same port. The HTTP/2 implementation includes HPACK header compression and stream flow control. For live browser applications, WebSocket connect, message and close events give the server a direct way to push updates. Frame and message size limits are configurable.

Several changes make a difference once a service is running:

  • Renew certificates while the service is live. The server can reload a certificate with OpenSSL or SChannel. Existing connections stay open, and a failed reload leaves the current certificate in use. The new kbmMWCertificate unit can also generate self-signed server certificates as a password-protected PFX on Windows or as PEM files through OpenSSL 3.
  • Stream large files with bounded memory. An HTTP/1.1 file download reuses one buffer, 64 KB by default, regardless of file size. A known-length response carries Content-Length, so clients can show download progress and keep the connection open. In the Windows test recorded in the release history, throughput for a 10 MB download over eight loopback connections rose from 4.02 to 4.91 GB/s.
  • Compress traffic in both directions. The server negotiates Brotli or gzip for eligible responses and can decode Brotli, gzip or deflate request bodies before they reach the handler. The HTTP client can also compress outgoing requests. Applications can use the new pure Pascal Brotli encoder and decoder independently, alongside new ZIP, raw DEFLATE and zlib support.
  • Control upload memory across connections. The native HTTP server shares a process-wide memory budget for request bodies and spills them to disk when needed. Decoded request bodies are also subject to a configured size limit.

Full-text search from an ORM field declaration

The fts setting on kbmMW_Field now creates a working search index. Mark the searchable fields on a model, run CreateOrUpgradeTable, and kbmMW creates the database-specific index if it is missing. This also works when you add search to a table that already contains data.

Suppose an Article model declares its title and body searchable. The same ORM query can find articles mentioning Delphi while excluding those that mention “deprecated”:

SELECT * FROM Article
WHERE Article CONTAINS 'delphi -deprecated'

The table name is intentional. Article CONTAINS searches the fields selected in the model, and the predicate can participate in joins or combine with other conditions. Underneath, kbmMW uses SQLite FTS5, a PostgreSQL tsvector with a GIN index, MySQL FULLTEXT, a SQL Server full-text catalog and index, or an Oracle Text index. On SQLite, it also creates the triggers that keep the index in step with inserts, updates and deletes. If an engine cannot honor a requested tokenizer or stemming option, the error identifies the affected table and fields.

Broader SQL support and three new native adapters

The SQL rewriter now handles outer join chains, recursive common table expressions, set operations, window functions and frames, and transaction statements with savepoints. It translates details that often force developers to maintain separate SQL by hand, including explicit NULLS FIRST or NULLS LAST, date arithmetic, and string aggregation.

Writes received particular attention. UPDATE ... FROM and DELETE ... USING retain their source tables. INSERT ... ON CONFLICT translates to the upsert form the target engine can express, and RETURNING can expose old or new row values where supported. An important MERGE fix preserves the matching rules and insert branches that earlier versions could lose.

There are also native PostgreSQL, Firebird/InterBase and ODBC adapters that load their client libraries at runtime, including 64-bit support for Firebird/InterBase. MySQL and PostgreSQL gain dedicated metadata components. And if an import job or another application writes directly to an ORM-managed table, the new triggers:auto option lets supported databases maintain generator fields for those writes. ORM-routed writes suppress the trigger work so values are applied only once.

Messaging that can wait for a reconnect

A store-and-forward client can enable HoldOutboundWhileDisconnected to retain queued messages through a broken connection and retry unconfirmed sends in queue order. On the server, ConfirmAfterProcessing defers the acknowledgement until processing succeeds or the server gives up on the message. Retries can deliver duplicates, an important detail for handlers that create orders, post payments or perform another one-time action.

For larger deployments, several queues can share a fixed worker pool while retaining their individual message order. Several listening ports can likewise share an I/O thread pool, with separate connection and pending limits per port. TCP messaging servers also gain controls for backlogged clients and separate idle limits for connections awaiting their first valid message and those already established.

Authorization, Microsoft 365 and AI

TkbmMWAuthorizationManager gains policy handling with rules, conditions and a parser. Actors and roles can now be organized into categories, updated by category-aware methods and removed by category. On the client side, TkbmMWSmartClientPool ties a borrowed client’s lifetime to an interface reference. Releasing that reference returns the client to the pool.

For Microsoft 365, kbmMWGraphMailClient can send mail and read mailboxes through Microsoft Graph using application or delegated credentials. The accompanying OAuth 2 client supports client credentials, refresh tokens and XOAUTH2.

For installations licensed for AI, kbmMWAI adds integrations for OpenAI-compatible and Anthropic services, with streaming chat, tool calls and embeddings available according to the service. kbmMWMIMER provides access to theMIMER host service’s retrieval, web and conversation memory APIs.

Diagnostics, scheduling and upgrade details

Services can now log directly to standard output or emit newline-delimited JSON and XML for log collection. Debugging support expands across MAP, TDS and DWARF, including better inspection of counted strings and dynamic arrays. The scheduler can add an event from inside a running event, and a waited UnSchedule now completes the event’s end callbacks before returning in the normal termination case. That matters when those callbacks use objects the caller is about to free.

Two changed defaults are worth checking during deployment. Native socket servers now apply a 30-second idle timeout when IdleTimeoutMS is zero. The native HTTP server also compresses eligible responses by default, with controls at both server and response level.

Professional and Enterprise Edition is available for all with a current active SAU. If your SAU has run out, please visit our shop to extend it with another 12 months.

Community Edition (CE) can be used as a 60 day trial, alternatively as a free product, provided the license is followed. Please read license.txt file for details. CE supports a large subset of the Enterprise Edition features, but may have technical and artificial limitations in certain areas. It only supports a specific Delphi/Win32 SKU, produce Win32 executables and do not include source.

Please visit https://portal.components4developers.com to download.

Notice that Community Edition (CE) is currently only available on request, and after signing up with COMPLETE and CORRECT info on the portal, due to export restrictions to Russia and Belarusia.

—-

kbmMW is the premiere n-tier product for Delphi, C++Builder and MPC on Win32, Win64, Linux, Java, PHP, Android, IOS, .Net, embedded devices, websites, mainframes and more.

Please visit http://www.components4developers.com for more information about kbmMW.

—-

Components4Developers is a brand established in 1999 with the purpose of providing high quality development tools for developers and enterprises. The primary focus is on SOA, EAI and systems integration via our flagship product kbmMW.

kbmMW is currently used as the backbone in hundreds of central systems, in hospitals, courts, private, industries, offshore industry, finance, telecom, governments, schools, laboratories, rentals, culture institutions, FDA approved medical devices, military and more.



 5.24.00 Sep 17 2025

        New stuff
        =========

        - Added actor and role categories to TkbmMWAuthorizationManager, with category-aware
          add and update methods and removal by category.
        - Added MySQL and PostgreSQL metadata components.
        - Added IkbmMWSmartClient and TkbmMWSmartClientPool. Acquired clients return to the pool
          when their interface reference is released.
        - Added SpokeSlowScoreMax and SpokeIdleTimeoutMS to native TCP messaging servers, allowing
          them to disconnect backlogged or idle spokes.
        - Added kbmMWUnEscapePath and Windows TkbmMWPreventSleep helpers.
        - Major expansion of the kbmMW SQL rewriter dialect support. The rewriter now emits, per
          database dialect, the full set of newer kbmMemSQL constructs:
             - Outer joins (LEFT/RIGHT/FULL), multi table join chains and JOIN ... USING.
             - Set operations (UNION/UNION ALL/INTERSECT/EXCEPT), with Oracle emitting MINUS for EXCEPT.
             - Common table expressions, including recursive ones (WITH RECURSIVE).
             - Window functions: ROW_NUMBER(), RANK(), DENSE_RANK(), aggregate OVER (PARTITION BY ...),
               and LAG()/LEAD().
             - EXISTS/NOT EXISTS, quantified ANY/ALL/SOME comparisons, and CAST(expr AS type).
        - Implemented full text search. The fts setting in kbmMW_Field, its tokenizer (Unicode, ASCII or
          Trigraph), Porter stemming and prefix settings have been declarable for some time, but nothing
          acted on them and an FTS marked contract was created as an ordinary table. CreateOrUpgradeTable
          now emits the indexing DDL, per database:
             - SQLite: an FTS5 external content virtual table plus the insert, update and delete triggers
               that keep it in step with the base table.
             - PostgreSQL: a generated STORED tsvector column with a GIN index, which the database
               maintains itself, so no triggers are needed.
             - MySQL: a FULLTEXT index on the base table, maintained by the storage engine. A Trigraph
               tokenizer selects the ngram parser.
             - MS SQL Server: a full text catalog and a full text index keyed through the primary key
               index, with CHANGE_TRACKING AUTO.
             - Oracle: a CTX_DDL MULTI_COLUMN_DATASTORE preference and a CTXSYS.CONTEXT domain index.
          The index is created through the new mwmdtFTS metadata type, which first probes whether one is
          already present, so re-running a create is harmless and marking fields full text searchable on
          an already existing table is picked up on the next create or upgrade rather than only on a
          freshly created table.
          Added the CONTAINS predicate for querying a full text index, rewritten per dialect:
             SELECT * FROM Article WHERE Article CONTAINS 'delphi -deprecated'
          Its operand is the TABLE, not a column, because a full text index covers every field the
          contract declared searchable under one configuration. It is a predicate rather than a function
          because what it rewrites to is not a function either: an operator on PostgreSQL and SQLite, a
          special form on MySQL, a grammar predicate on MS SQL Server, and on Oracle a function whose
          score has to be compared. Being a predicate, it composes with AND/OR/NOT and works inside a
          join. It emits an FTS5 MATCH sub select correlated on the key on SQLite, @@ to_tsquery on
          PostgreSQL, MATCH ... AGAINST ... IN BOOLEAN MODE on MySQL, CONTAINS over the column list on
          MS SQL Server and CONTAINS(...)>0 on Oracle.
          The node is RESOLVED between parse and rewrite: the ORM fills in the table, its full text
          fields and its key while walking the compiled statement, which keeps the parser free of schema
          knowledge and the rewriter free of schema lookups. A CONTAINS that never went through the ORM
          is refused rather than guessed at, and dialects without a full text engine report it as an
          unsupported node.
          A metadata reports its ability through the mwmdfFTS feature flag. Where a database cannot
          honour a specific setting (Trigraph on PostgreSQL, MS SQL Server or Oracle; Porter stemming on
          MySQL), or where the database has no full text engine at all, a clear exception now names the
          table and the fields instead of the settings being silently ignored.
        - Improved per dialect identifier quoting with automatic reserved word detection. MS SQL Server
          now brackets identifiers ([name]) and carries a full T-SQL reserved word list.
        - Added STDDEV aggregate emission per dialect (STDDEV_SAMP on ANSI/PostgreSQL/Oracle/MySQL,
          STDEV on MS SQL Server; SQLite has no built in equivalent and reports it).
        - Added optional automatic database triggers to the ORM. A table opts in through
          [kbmMW_Table('triggers:auto')], after which CreateTriggers/DeleteTriggers emit and drop triggers
          that maintain the table's generator fields for raw SQL writes that bypass the ORM. The trigger
          bodies stand down during ORM routed writes, since the resolver path brackets itself with
          BeginTriggerSuppression/EndTriggerSuppression, so a generator value is never applied twice.
          Trigger names are deterministic (KBMMW_TRG_<table>_<INS|UPD|DEL>_<column>) so the per database
          metadata can reproduce them when emitting CREATE/DROP/EXISTS DDL, and the trigger DDL is
          refreshed when a table upgrade rebuilds the table. Per database metadata may decline to emit
          triggers, which is logged and does not abort the upgrade.
        - Expanded the native cross platform socket stack (source/Socket) with a suite of protocol clients
          and servers, all built on kbmMW's own async sockets - no third party socket library:
             - A synchronous socket client (kbmMWSocketSyncClient) with a pluggable, process wide default
               TLS backend.
             - Native TLS via Windows SChannel/SSPI (kbmMWSChannel), requiring no OpenSSL DLLs, plus shared
               TLS trust helpers (kbmMWSslTrust).
             - A native HTTP/1.1 client (kbmMWHTTPClient) and an async socket HTTP/1.1 server
               (kbmMWSocketHttpServer).
             - FTP/FTPS client and server (kbmMWFTPClient, kbmMWFTPServer).
             - SMTP, IMAP and POP3/POP3S e-mail clients (kbmMWSMTPClient, kbmMWIMAPClient, kbmMWPOP3Client)
               with MIME message support (kbmMWMimeMessage).
             - An SSH2 transport, client and server for remote command execution
               (kbmMWSSHTransport, kbmMWSSHClient, kbmMWSSHServer), and an SFTP client and server on top
               (kbmMWSFTPClient, kbmMWSFTPServer).
             - HTTP/2 (RFC 9113) on the socket HTTP server, opted in through the EnableHttp2 config field:
               a transport free frame layer (kbmMWSocketHttp2), HPACK header compression (kbmMWSocketHPack,
               RFC 7541) and the connection and stream state machine with flow control
               (kbmMWSocketHttp2Connection). Selected over TLS by ALPN (the listener offers h2 and
               http/1.1, in server preference order), or accepted as a cleartext prior knowledge h2
               connection on any listener, TLS or plain.
             - ALPN support in the native TLS layer through the new IkbmMWALPNAware interface in
               kbmMWSocketBase, implemented by both the OpenSSL and the SChannel connection.
             - WebSocket (RFC 6455) on the socket HTTP server (kbmMWSocketWebSocket), covering
               fragmentation, control frames, the close handshake and strict UTF-8 validation of text
               frames. Surfaced as OnWebSocketConnect, OnWebSocketMessage and OnWebSocketClose, with
               WebSocketMaxFrameBytes and WebSocketMaxMessageBytes as guards. Extensions are refused
               rather than half supported, so any set RSV bit is rejected. This is separate from the
               existing kbmMWWebSocketServerTransport, which serves the classic kbmMW transport stack.
             - Streamed responses with a known total length (TkbmMWHttpResponse.BeginFixed). It emits
               Content-Length instead of chunked framing, writes the body raw and does not force the
               connection closed, so large downloads keep their progress indication, their resumability
               and the keep-alive, at the same memory cost as BeginChunked.
             - HTTP date headers (Date, Last-Modified, If-Modified-Since) are now formatted and parsed
               through the TkbmMWDateTime RFC1123 handling, which covers the obsolete forms and the
               timezone suffixes.
        - Added kbmMWConsoleLog, a console (stdout) log manager.
        - Added kbmMWDiff unit for text differencing (using the Patience diff method).
        - Added support for retrieving version info from SQLite.
        - Added TkbmMWFieldDefs helpers PrimaryKeyFields, NonPrimaryKeyFields and FieldNames.
        - Added property RequireLoginPrompt (default true). When false, a 401 response does not trigger
          the web browser login dialog.
        - Date conversion custom SQL functions now accept both a floating point TDateTime and an ISO8601
          string, auto detecting how to convert based on the value.
        - Added a property to the SQLite metadata component controlling whether the specialized kbmMW
          custom SQLite functions are used when rewriting.
        - Added NDJSON (newline delimited JSON) and NDXML log formats, as used by ElasticSearch and
          similar tools.
        - Added additional UTF-16 and UTF-32 character set variations (big and little endian).
        - Added IsNotNull to kbmMWNullable.
        - Added kbmMWGetPrivatePersistentNonBackupDirectory function.
        - Improved streaming for multi object/value streaming.
        - Added TkbmMWScheduler.InAFewSeconds methods, and made adding scheduled events from within a
          running scheduled event legal.
        - Added policy handling to TkbmMWAuthorizationManager (kbmMWSecurity.pas), built from
          TkbmMWPolicy, TkbmMWPolicyRule and TkbmMWPolicyCondition, with a TkbmMWPolicyParser to read
          them.
        - Added TkbmMWCustomThread.Proceed.
        - Added kbmMWGetInternalVersion and kbmMWGetUNCPath (Windows) for obtaining version info when the
          file version is not directly available, e.g. when running from a shared folder under VMWare.
        - Added Increment variants to TkbmMWDynamicLockFreeHashArrayU32.
        - Added generic TkbmMWLockFreeStack<T> and TkbmMWLockFreeQueue<T>.
        - SQLite: an integer/float field that actually contains the text true/false is now converted to
          1/0 instead of raising an exception.
        - Added more detail to Unsupported Conversion exceptions.
        - Updated timezones.
        - Switched the unit tests to the kbmUnitTest framework and added extensive tests for kbmMWGlobal,
          kbmMWSecurity, kbmMWNullable, the SQL rewriter, HPACK, the HTTP/2 frame layer, the HTTP/2
          connection state machine, the HTTP/2 server and WebSocket.
        - Added native PostgreSQL, Firebird/InterBase and ODBC data adapters. They load the client
          library at run time. The Firebird/InterBase adapter supports 64 bit targets.
        - Added kbmMWZip for reading and writing ZIP files and for raw DEFLATE and zlib compression.
          Added the buffered kbmMWZLib compression and decompression streams.
        - Added kbmMWOAuth2Client for client credentials and refresh token grants and XOAUTH2.
          Added kbmMWGraphMailClient for sending mail and reading Microsoft 365 mailboxes through
          Microsoft Graph, with application or delegated credentials.
        - Expanded MAP, TDS and DWARF debug support. The DWARF reader handles frame bases given
          as a register plus displacement, and reads stored bounds for counted strings and dynamic
          arrays from the target. Counted character arrays can be shown as text.
        - Added TkbmMWProcess.CreateObservedProcess on Windows so a debugger can receive process
          creation events for descendants before they start executing.
        - Added kbmMWMemTableLock to integrate kbmMW locking with kbmMemTable.
        - Updated CompileTool feature definitions for the native socket and protocol units, native
          database adapters, debugging units, ZIP and zlib, and kbmMWMemTableLock.
        - Added TkbmMWSharedSocketServer and TkbmMWSharedSslSocketServer. Several listening ports
          can share one I/O thread pool, with per-port connection and pending limits. An optional
          cleartext preamble is checked before TLS. Set SharedSocketServer on the TCP messaging
          server transport to use it, and SSLPreamble on the client to send the preamble.
        - Added kbmMWCertificate for generating self-signed server certificates. It can generate a
          password-protected PFX on Windows or PEM certificate and key through OpenSSL 3.
        - Added optional TkbmMWMessageQueueProcessorPool support to asynchronous messaging queue
          processors and SAF server transports. A fixed worker pool serves multiple processors,
          preserving each queue's order and limiting how many messages it handles per turn.
        - Added HoldOutboundWhileDisconnected to SAF messaging clients. With it enabled, queued
          messages wait for reconnect and unconfirmed sends are retried in queue order. Added
          ConfirmAfterProcessing to messaging servers to defer confirmed-delivery ACKs until
          processing succeeds or the message is given up. Retries can deliver duplicates.
        - Added two-stage TCP messaging server idle limits. PreMessageIdleTimeoutMS applies until
          the first valid message and IdleTimeoutMS then applies to the established connection.
          With SharedSocketServer, its idle limit governs the first stage.
        - The native HTTP server now uses a process-wide memory budget for request bodies and
          spills bodies to disk when needed. It answers unsupported chunked uploads with 501.
        - Added kbmMWAI for OpenAI-compatible and Anthropic services, with streaming chat, tool calls and
          embeddings. Added kbmMWMIMER for theMIMER host service's retrieval, web and conversation
          memory APIs. CompileTool includes both units under the licensed AI feature.
        - Added TkbmMWSyncServer for blocking reads and writes on accepted native socket
          connections, including server-side STARTTLS and receive limits.
        - Added kbmMWEncoding with URL, HTML and Base64 helpers, including single-line and
          MIME-wrapped Base64 output.
        - SQL rewriter: renders what kbmMemTable's SQL gained (kbmMemTable next version), in every
          dialect: ORDER BY and GROUP BY expressions with DESC on any item; ORDER BY ... NULLS
          FIRST/LAST (PostgreSQL, Oracle, SQLite, Firebird spell it; MySQL and SQL Server get a
          CASE key on NULL in front of the item, which repeats a column number's or alias's select
          list expression); SUBSTRING/SUBSTR, CONCAT (skips NULLs everywhere: CONCAT_WS on MySQL,
          COALESCE(..)||.. on SQLite/Firebird), FLOOR, CEILING/CEIL, ROUND/TRUNC with digits
          (PostgreSQL on NUMERIC, SQL Server ROUND(x,d[,1])), EXTRACT and kbmSQL's YEAR()..
          SECONDS(), DATEADD, DATEDIFF (counting boundaries crossed, as SQL Server does, in every
          dialect) and the aggregate STRING_AGG/GROUP_CONCAT (STRING_AGG, GROUP_CONCAT, LISTAGG,
          LIST). Parts a dialect cannot express are refused rather than written wrong (SQL Server's
          STRING_AGG has no DISTINCT; SQLite's GROUP_CONCAT(DISTINCT) only joins with a comma).
          Known differences: Oracle's ADD_MONTHS and SQLite's datetime() modifiers differ from
          kbmMemTable at month ends; Oracle's '' is NULL, so its CONCAT of only NULLs is NULL.
        - kbmMWSQLRewriter writes window frames (ROWS/RANGE BETWEEN ... AND ...), every window
          function argument (LAG(x,2,0), NTH_VALUE(x,2)) and FIRST_VALUE/LAST_VALUE/NTH_VALUE, as
          kbmMemSQL now supports them. A frame is left out for ranking functions and LAG/LEAD,
          which ignore it. SQL Server refuses NTH_VALUE and a RANGE frame with an n PRECEDING /
          n FOLLOWING bound, which it does not have.
        - kbmMWSQLRewriter writes kbmMemSQL's transaction statements (BEGIN, COMMIT, ROLLBACK,
          SAVEPOINT, RELEASE, ROLLBACK TO) per dialect. Most dialects get the standard forms;
          SQLite gets BEGIN TRANSACTION; SQL Server gets BEGIN/COMMIT/ROLLBACK TRANSACTION and
          SAVE TRANSACTION name; InterBase/Firebird get SET TRANSACTION. Oracle (BEGIN, RELEASE)
          and SQL Server (RELEASE) write no statement where they have none and need none.
          Added TkbmMWCustomSQLRewriter.RewriteTransaction.
        - Added kbmMWBrotli, a pure Pascal Brotli (RFC 7932) encoder and decoder with quality 0-11
          and an optional output ceiling. A malformed or truncated stream raises EkbmMWBrotli.
          Added kbmMWContentCodingAccepted and kbmMWBrotliAccepted for Accept-Encoding checks.
        - The native HTTP server compresses responses with br or gzip, as the client accepts, for
          compressible content types of CompressionMinBytes (256) or more, and adds
          Vary: Accept-Encoding. Controlled by the Compression setting (default on) and per
          response by Response.Compression. Compressed request bodies (br, gzip, deflate) are
          decoded before the handler, bounded by MaxBodyBytes (DecompressRequests, default on);
          a body that does not decode is answered 400.
        - kbmMWHTTPClient advertises gzip, deflate and br and decodes br. Decoded bodies are
          bounded by MaxResponseSize. RequestEncoding ('br' or 'gzip') compresses request bodies
          of RequestCompressMinBytes or more.
        - TkbmMWHTTPCompress gains mwhcBrotli and EncodingType. The custom HTTP service prefers br
          over gzip, and the REST, AJAX and HTTP.sys transports compress with the chosen coding.
        - Added kbmMWDeflateGzip and kbmMWInflateRawMax/ZlibMax/GzipMax with an output ceiling,
          and kbmMWInflateZlibExact to kbmMWZip.
        - Added live TLS certificate renewal without a restart: TkbmMWSslSocket.ReloadCertificate
          and ReloadCertificateFiles (OpenSSL) and ReloadWinSSLCertificate (SChannel), exposed on
          TkbmMWSocketHttpServer as ReloadCertificate, ReloadCertificatePem and
          ServerCertificateDER. Existing connections keep their certificate, and a failing
          reload keeps the current one.
        - The SChannel certificate store lookup by subject now picks the certificate that is valid
          now with the latest expiry. TkbmMWSChannelServerCredential gains Create(cert,protocols),
          Cert, EnabledProtocols and CertificateCurrentlyValid.
        - A configuration name that is an absolute path is now used as given by the file based
          configuration storages (TkbmMWConfiguration.GetConfigFileName).
        - The native HTTP server sends a file (ServeFile over HTTP/1.1) by reading the next block
          into one reused buffer only when the previous send has completed, so a download holds
          one block of memory however large the file. The default block size is now 64 KB
          (was 256 KB).
        - On Windows, accepted native sockets use FILE_SKIP_COMPLETION_PORT_ON_SUCCESS: a large
          send that completes at once is finished on the same I/O thread instead of going
          through the completion port. A 10 MB download over 8 loopback connections went from
          4.02 to 4.91 GB/s.
        - The native HTTP server keeps the Date header text per thread for the current second,
          and tears closed connections down on a small pool of reused threads instead of
          starting a thread for each.

        Changed behaviour
        =================
        - TkbmMWScheduler.UnSchedule(AEvent,AWait=true) now returns with the event's end callbacks
          (AfterEnd) run EXACTLY ONCE. Before, a waited UnSchedule waited only while the event body
          executed; the thread that ran the event called the end callbacks after that, so UnSchedule
          could return while AfterEnd had still to run - on an object the caller was about to free.
          The end callbacks now run either on the thread that had already started them (waited for),
          or on the CALLER'S thread, which includes an event that never ran at all. The main thread
          pumps CheckSynchronize while waiting, so a synchronized AfterEnd still runs. A waited
          UnSchedule with ADontTerminate=true skips the end callbacks.
        - The end callbacks of a scheduled event run at most once in its lifetime. They used to run
          once per caller of DoExecuteEnd, so an event that ended as its scheduler stopped could run
          AfterEnd twice. Added IkbmMWScheduledEvent.WaitExecuteEnd.
        - A waited UnSchedule also waits for the scheduler to release its reference to the event
          when called from outside the scheduler's own threads. This lets the caller free objects
          captured by the event after UnSchedule returns.
        - TkbmMWMREWLock now parks a contended waiter in the kernel after spinning on Windows 8+
          and Linux x64/ARM64. When a reader upgrades to a write lock, it gives up its read share
          while it waits, so two simultaneous upgrades can make progress. Re-read protected data
          after BeginWrite, since another writer may have acquired the lock in between. A read
          acquired inside a write stays held after EndWrite, allowing a downgrade.
        - Native socket servers use a 30 second idle timeout when IdleTimeoutMS is zero.
          HTTP, FTP, SSH and TCP transports expose configurable limits, and the idle sweep
          leaves a connection alone while its receive handler is running.
        - FastCGI now uses kbmMW's native synchronous TCP client on all supported platforms.
          Kept connections can be reopened and an unanswered idempotent request retried if
          the peer closed the connection.
        - The native socket Listen and Connect now refuse mwspUDP with an exception (message
          KBMMW_SOCKET_UDP_REFUSED). They serve TCP connections only: a UDP Listen used to fail
          silently through its callback, and a UDP Connect could not work on Windows.
        - kbmMWHTTPClient with Decompress=false now returns the body as sent and keeps its
          Content-Encoding. Before, a gzip or deflate body was decoded anyway.
        - The native HTTP server compresses eligible responses by default. Set Compression to
          false in its configuration, or Response.Compression per response, to send them as is.
        - TkbmMWDateTime.RFC1123UTCDateTime and RFC1123DateTime, and so the HTTP Date,
          Last-Modified and Expires headers, now write the IMF-fixdate form RFC 9110 requires,
          with spaces: 'Sun, 06 Nov 1994 08:49:37 GMT'. They wrote the hyphenated form before.
          Parsing accepts IMF-fixdate, the RFC 850 form and the asctime form.

        Fixes
        =====
        - Fixed WebSocket frame encoding and decoding in kbmMWWebSocketServerTransport.
        - Fixed SmartBind updates for filtered FireMonkey list views.
        - Fixed native TCP messaging receive processing so a message arriving as the current
          processor exits is picked up.
        - Fixed the TkbmMWTextPChar/PAnsiChar/PByte.SkipSpaces helpers which always returned false.
        - Fixed RFC1123 date/time formatting to emit English month names regardless of the machine locale.
        - Fixed Hex2Byte, Hex2Bytes and TkbmMWStringBuilder.DeleteFirstChar.
        - Fixed kbmMWORM not honoring the kbmMWField name attribute.
        - Fixed JSON and XML logging format when data is missing.
        - Fixed 64 bit IDE compilation.
        - Fixed missing LF in PEM generation for valid certificate syntax.
        - Fixed leaks in I18N and ORM.
        - Fixed CSV loader with a limit set, TkbmMWURL handling of an initial slash in the path, and
          kbmMWEncodeEscapes incorrectly encoding valid characters.
        - Fixed setting the null flag on kbmMWNullable types in kbmMWONMarshal.pas.
        - Fixed YAML parsing to support valid non quoted + and . names and values.
        - Fixed an ancient scope locking bug and a reader biased vs writer biased lock race condition.
        - Hardened the native server side sockets and fixed HTTP POST.
        - Fixed TkbmMWScheduler.Active never being set to active, and InAFewSeconds firing more than once.
        - iOS/Mac fixes: kbmMWGetFileSize/kbmMWGetFileInfo/kbmMWGetFileVersion, kbmMWI18N, kbmMWLog and
          Kqueue socket bugs.
        - Fixed the HTTP client no longer being forced to provide a certificate, which is not the norm
          for HTTP servers.
        - Optimized kbmMWMemoryDebug and the lockfree hash array, and a minor kbmMWDateTime record
          initialization optimization.
        - Fixed a use after free at process exit in kbmMWSmartEvent: the global event hub's process
          event AfterEnd closure could run after TkbmMWEvents had been freed. It now holds a life
          token instead of the object, and the event lists are freed exactly once. Also fixes a leak
          of those lists when the event was idle at shutdown.
        - Fixed TkbmMWLock.Write: the scope it returns took a READ lock and released it with
          EndWrite, so a write scope excluded no other thread and leaked one read lock each time.
          kbmMWSmartEvent's subscribers take one per fluent call, so subscribing leaked reads.
          Write scopes now really exclude. TkbmMWEventCustomSubscriber.Activate no longer holds
          its write scope while it registers with the event lists, which would have been a lock
          order inversion against notification now that the scope excludes.
        - Fixed TkbmMWMREWLock: a lock freed while read locks were still counted left them in the
          per thread read lock table, keyed by its address, and the next lock allocated there
          inherited them - its first BeginWrite then waited forever. Destroy now removes them.
        - Fixed native HTTP/2 handling and concurrent first use of the HPACK Huffman decoder.
        - Fixed SmartBind datasource updates and improved keyboard and mouse interaction on grids.
        - Fixed scheduler cleanup and reactivation, including events removed before their pending
          addition was processed.
        - Fixed a leak when a TkbmMWCustomThread was finalized on its own worker thread.
        - Fixed concurrent TkbmMWLockFreeQueue<T> dequeue and node reclamation, including queues
          with managed values. TkbmMWMREWLock also handles more than 64 locks held for reading by
          one thread and uses ordered atomic reads on non-x86 targets.
        - Fixed a TCP messaging client disconnect race that could discard an unsent message.
          Fixed confirmed-delivery ACK subjects and rollback of unconfirmed messages sharing a
          hash bucket. Fixed cleanup of disconnected spokes and owned messaging queues.
        - Fixed sync and async message queue processors to call their published OnProcess handler.
        - Fixed native socket send and disconnect handling, including immediate sends from a
          callback and flushing pending writes on synchronous client disconnect.
          The socket handle is
          invalidated before close so concurrent I/O cannot act on a reused handle. IOCP shuts
          down the send side before closing so queued data can reach the peer.
        - Fixed FTPS passive transfers to start data TLS after the preliminary transfer reply and
          offer to resume the control session with OpenSSL or SChannel. DataTlsSessionReused
          reports the result. TkbmMWSyncClient.StartTLS accepts a session source.
        - Fixed OpenSSL protocol deny options to apply the allowed version range, including TLS 1.1.
          TrustSystemStore and CABundleFile can be applied to an existing context. System trust
          on Linux uses SSL_CERT_FILE or the distribution's CA bundle. TCP messaging clients
          expose SSLTrustSystemStore, SSLCABundleFile and SSLVerifyHostName.
        - The TCP messaging server now checks for a certificate and key before starting TLS and
          installs its password callback before loading an encrypted key.
        - Fixed ZIP reading to validate directory bounds and check the local header, decompressed
          size and CRC before returning an entry.
        - Reduced allocations when initializing TkbmMWDateTime and TkbmMWDuration records.
        - Fixed FileStore message queue rollback to retain stalled messages when no stalled
          message handler takes them.
        - Fixed LZ4 decoding to reject uncompressed blocks larger than the output buffer.
          Fixed JPEG error cleanup so libjpeg state and buffers are released and decode errors
          reach the caller.
        - Fixed Windows enum sizes in HTTP.sys and Remote Desktop declarations to match the
          native API layouts.
        - Fixed CompileTool's -ga option to generate projects for all supported IDEs, including
          those absent from the build machine. Fixed RAD Studio 13 detection in that mode.
        - Fixed thread pool reuse of stopped workers and stale entries during pool cleanup.
        - Fixed FTP server LIST date formatting to use English month names on every locale.
        - Fixed ORM queries through AsLinq without a query text returning all rows.
        - Fixed the native HTTP server not reading the next request on a kept-alive connection
          after a fixed length streamed response (ServeFile).
        - Fixed a waited UnSchedule spinning forever after kbmMWShutdown, for example when
          SmartBind was freed during finalization, which left the application not responding.
        - Hardened kbmMWZip inflate against oversubscribed Huffman tables and over long length
          repeats.
        - The runtime packages containing kbmMWTCPMessagingServerTransport now also contain
          kbmMWSharedSocketServer, and the D120/D130 runtime packages contain kbmMWBrotli.
          The installers ship kbmMWBrotli, kbmMWSharedSocketServer, kbmMWCertificate,
          kbmMWMemTableLock and the include files kbmMWBrotliData.inc, kbmMWSChannelTrust.inc
          and kbmMWSocketSyncServer.inc.
        - Fixed the weekday in RFC1123 date/time output, which was that of the local date rather
          than the printed one around midnight.
        - Fixed TkbmMWLocalStat counters: min and max compared the raw value rather than the
          stored one (Value/Base on a per-second counter). Adding a point no longer scans the
          whole list, trimming to BufferSize no longer shifts the list once per removed point,
          and a turnaround is timed before the statistics lock is taken.
        - Fixed the SQLite adapter storing an empty string or empty blob parameter as NULL, and
          reading an empty TEXT value back as NULL.

        Fixes (SQL rewriter)
        ====================
        - MERGE was written as an UPDATE of all its assignments by every dialect, losing its
          inserts and its matching rules. It is now written for PostgreSQL (15+), SQL Server,
          Oracle, Firebird and the generic ANSI-2003 dialect, and refused by MySQL/MariaDB,
          SQLite and ANSI-92, which have no MERGE. Oracle takes its own restricted form: one
          UPDATE and one INSERT branch, each with an optional WHERE.
        - UPDATE ... FROM and DELETE ... USING lost their FROM/USING tables, and UPDATE and
          DELETE lost a target alias. Each dialect now writes them its own way: PostgreSQL
          natively, SQLite with UPDATE ... FROM and an EXISTS, MySQL/MariaDB as multi-table
          UPDATE/DELETE, SQL Server with a FROM clause, and Oracle, Firebird and ANSI with
          correlated subqueries and an EXISTS.
        - Window functions: DESC on an ORDER BY expression inside OVER (...) was lost and NULLS
          FIRST/LAST was dropped there; a GROUPS frame was written as RANGE and an EXCLUDE clause
          was left out. GROUPS and EXCLUDE are written for PostgreSQL, SQLite and Oracle and
          refused by the dialects whose databases lack them.
        - Integer division (DIV) truncates toward zero in every dialect. Oracle rounded a
          positive quotient up, SQL Server used a \ operator T-SQL does not have, SQLite floored
          a negative quotient, and Firebird called a DIV function it does not have.
        - The generic ANSI dialects write || (SQL-92) and MOD (SQL:2003) instead of refusing them.
        - INSERT ... ON CONFLICT is written for every dialect whose database can express it:
          natively for PostgreSQL and SQLite, as ON DUPLICATE KEY UPDATE for MySQL/MariaDB, and as
          a MERGE for SQL Server, Oracle, Firebird and the generic ANSI-2003 dialect. A bare
          column in DO UPDATE is qualified with the target, which PostgreSQL otherwise refuses as
          ambiguous. MySQL assignments are ordered so that none reads a column assigned before
          it; only a cycle is refused. SQLite INSERT ... SELECT ... ON CONFLICT gets the WHERE its
          parser needs. The MERGE form is not atomic against concurrent inserts.
        - DML RETURNING is written for SQL Server (OUTPUT INSERTED/DELETED, also on an upsert),
          Firebird (OLD/NEW), MariaDB and SQLite. On PostgreSQL an OLD/NEW image that is the
          returned row anyway is written as a plain column, so it runs before PostgreSQL 18, and
          renamed images get their WITH (OLD AS o, NEW AS n). An image a database cannot give,
          and MariaDB RETURNING on an upsert that may skip rows, is refused.
        - COUNT(t.*) FILTER (WHERE ...) is written for PostgreSQL with the whole-row value and
          refused by the dialects that have none.
        - Fixed SQL rewriter string results carrying over previous fragments, including arguments
          to SQLite CONCAT. Full text search is validated before emitting table DDL.
        - A column or table alias was written as a string ('alias'), which PostgreSQL and Oracle
          refuse. It is now an identifier, quoted the dialect's way when it needs to be.
        - MID/SUBSTRING with a length on the ANSI base (Firebird, InterBase, generic): the FOR part
          replaced everything before it, giving " FOR n)".
        - kbmSQL's YEAR()/MONTH()/DAY()/HOURS()/MINUTES()/SECONDS() were passed through as they
          were, though most dialects have no such function. They are now EXTRACT of the part.
        - INTERSECT ALL / EXCEPT ALL: Oracle's EXCEPT ALL was written as a plain MINUS, which drops
          the duplicates EXCEPT ALL keeps; it is now MINUS ALL (Oracle 21c+; an older server refuses
          it instead of answering wrong). SQL Server and SQLite have no ALL variants: refused.

Loading

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.