Readme.md

June 11, 2026 · View on GitHub

Trysil - Delphi ORM

A lightweight, attribute-driven ORM for Delphi
Map database tables to classes. Query, insert, update, delete — all through clean Object Pascal.

Features

Attribute-based mapping — decorate classes with [TTable], [TColumn], [TPrimaryKey] and you're done
7 database drivers — Firebird, InterBase, MariaDB, Oracle, PostgreSQL, SQL Server, SQLite — all through FireDAC
Fluent query builder — type-safe filtering with TTFilterBuilder<T>
Lazy loading — TTLazy<T> and TTLazyList<T> for related entities
Change tracking & soft delete — [TCreatedAt], [TUpdatedAt], [TDeletedAt] with automatic timestamps and user tracking
Optimistic locking — built-in via [TVersionColumn]
Identity map — per-context, multi-tenant safe
Unit of Work — TTSession<T> tracks and applies changes automatically
JSON serialization — full round-trip with TTJSonContext
REST HTTP module — attribute-based routing, CORS, JWT, multi-tenant support
Nullable types — TTNullable<T> generic wrapper
Connection pooling — delegated to FireDAC
Structured logging — SQL tracing with thread-safe correlation IDs
IDE Expert — visual entity designer, model & DDL generators, REST scaffolder, and one-click install of AI assistant skills (Claude Code, Cursor, Copilot, Windsurf)

Quick Start

1. Define an entity

type
  [TTable('Persons')]
  [TSequence('PersonsID')]
  TPerson = class
  strict private
    [TPrimaryKey]
    [TColumn('ID')]
    FID: TTPrimaryKey;

    [TColumn('Firstname')]
    FFirstname: String;

    [TColumn('Lastname')]
    FLastname: String;

    [TVersionColumn]
    [TColumn('VersionID')]
    FVersionID: TTVersion;
  public
    property ID: TTPrimaryKey read FID;
    property Firstname: String read FFirstname write FFirstname;
    property Lastname: String read FLastname write FLastname;
  end;

2. Use it

var
  LContext: TTContext;
  LPersons: TTList<TPerson>;
  LPerson: TPerson;
begin
  LContext := TTContext.Create(LConnection);
  try
    // Read all
    LPersons := TTList<TPerson>.Create;
    try
      LContext.SelectAll<TPerson>(LPersons);
      for LPerson in LPersons do
        Writeln(Format('%s %s', [LPerson.Firstname, LPerson.Lastname]));
    finally
      LPersons.Free;
    end;

    // Insert
    LPerson := LContext.CreateEntity<TPerson>();
    try
      LPerson.Firstname := 'David';
      LPerson.Lastname := 'Lastrucci';
      LContext.Insert<TPerson>(LPerson);
    finally
      LPerson.Free;
    end;
  finally
    LContext.Free;
  end;
end;

3. Watch it in action

_{▶ Watch: Trysil — Delphi ORM from scratch}

4. Filter with the fluent builder

var
  LFilter: TTFilter;
begin
  LFilter := LContext.CreateFilterBuilder<TPerson>()
    .Where('Lastname').Equal('Lastrucci')
    .OrderByAsc('Firstname')
    .Limit(10)
    .Build;

  LContext.Select<TPerson>(LPersons, LFilter);
end;

Database Support

Database	Driver unit	Notes
Firebird	`Trysil.Data.FireDAC.FirebirdSQL`	Localhost/embedded on Community; remote server requires Enterprise
InterBase	`Trysil.Data.FireDAC.InterBase`	Community edition; generator-based sequences
MariaDB	`Trysil.Data.FireDAC.MariaDB`	MariaDB 10.3+ (native sequences), via the FireDAC MySQL driver; localhost on Community, remote requires Enterprise
Oracle	`Trysil.Data.FireDAC.Oracle`	Requires Enterprise edition; EZConnect descriptor `//host:port/service`
PostgreSQL	`Trysil.Data.FireDAC.PostgreSQL`	Localhost on Community; remote server requires Enterprise
SQL Server	`Trysil.Data.FireDAC.SqlServer`	Requires Enterprise edition
SQLite	`Trysil.Data.FireDAC.SQLite`	Community edition; great for development and testing

FireDAC driver availability follows the RAD Studio edition matrix: Professional/Community covers local/embedded access (SQLite, InterBase, and localhost-only PostgreSQL/MySQL-MariaDB/Firebird), while full client/server connectivity — and SQL Server and Oracle in any form — requires Enterprise/Architect.

Delphi Compatibility

Version	Codename
Delphi 10.3	Rio
Delphi 10.4	Sydney
Delphi 11	Alexandria
Delphi 12	Athens
Delphi 13	Florence (active development)

All packages build on Community Edition, except Trysil.SqlServer and Trysil.Oracle, which require Enterprise/Architect (their FireDAC driver units ship only with those editions).

boss install davidlastrucci/Trysil

Manual

Clone the repository

git clone https://github.com/davidlastrucci/Trysil.git

Open Packages/<ver>/Trysil.groupproj in the Delphi IDE and Build All, or run from the command line:
```
Packages\Build370.bat
```
Add the output path to your project's Search Path:
```
$(Trysil)\$(Platform)\$(Config)
```
where $(Trysil) points to Lib/<ver>.

See the full Setup guide for details.

Documentation

Resource	Link
Online Help	davidlastrucci.github.io/Trysil
Blog	trysil.lastrucci.net
Manual (English)	PDF
Manual (Italiano)	PDF

Architecture Overview

TTContext  ─────────────────────────────  Main API
  ├── TTProvider                          SELECT / Read operations
  ├── TTResolver                          INSERT / UPDATE / DELETE
  │     ├── Validation (attributes)
  │     └── Events (Before/After hooks)
  ├── TTIdentityMap                       Per-context entity cache
  ├── TTSession<T>                        Unit of Work
  ├── TTTransaction                       Explicit transaction management
  └── TTFilterBuilder<T>                  Fluent query builder

TTConnection (abstract)
  └── TTGenericConnection
        ├── SQLite
        ├── PostgreSQL
        ├── SQL Server
        ├── Firebird
        ├── InterBase
        ├── MariaDB
        └── Oracle

Modules
  ├── Trysil          → ORM core
  ├── Trysil.JSon     → JSON serialization via TTJSonContext
  └── Trysil.Http     → REST hosting, routing, CORS, JWT, multi-tenant

Star this repository — it's free and helps others discover the project
Share your project in the Show and tell issue
Donate via
Reach out at david.lastrucci@gmail.com — feedback is always welcome

License

BSD-3-Clause — see LICENSE.md for details.

Naming

Trysil takes its name from Operation ORM, a World War II Allied operation.

Made with ❤️ by David Lastrucci