var db: TSDLDatabase; q: TSDLQuery; begin db := TSDLDatabase.Create(nil); q := TSDLQuery.Create(nil); try db.DriverName := 'MSSQL'; db.Params.Values['Server'] := '127.0.0.1'; db.Params.Values['Database'] := 'AdventureWorks'; db.Params.Values['User ID'] := 'sa'; db.Params.Values['Password'] := 'secure123'; db.Connected := True; q.Database := db; q.SQL.Text := 'SELECT * FROM SalesOrderHeader WHERE OrderDate > :startDate'; q.ParamByName('startDate').AsDate := EncodeDate(2023,1,1); q.Open;
while not q.Eof do begin // Process each row q.Next; end;
, a lightweight database engine replacement designed for Delphi and C++Builder developers. Released on August 25, 2019, version 6.5.2 primarily introduced support for Delphi/C++Builder 10.3 Rio Key Purpose and Features SQLDirect v6.5.2 Full Source
: List supported servers including IBM DB2, Oracle , Firebird, and Sybase.
Designed for modern multi-threaded applications, ensuring stability in complex server environments. Version 6.5.2 Specifics var db: TSDLDatabase; q: TSDLQuery; begin db := TSDLDatabase
The Pooling property, when set to True , reuses physical connections across threads. Because you have the source, you can implement custom pool eviction policies (e.g., time-based, LRU).
By setting the FetchOptions and using ExecuteAsync , you can run long-running queries without freezing the UI. The source reveals the internal event mechanism, allowing you to extend it with progress callbacks. Version 6
In this blog post, we'll take a closer look at SQLDirect v6.5.2 and its features, as well as provide a download guide for the full source code.