Tag - mORMot
2016, Monday December 19
By A.Bouchez on 2016, Monday December 19, 21:27 - mORMot Framework
JSON Web Token (
JWT) is an open standard (RFC 7519) that defines a compact
and self-contained way for securely transmitting information between parties as
a JSON object. This information can be verified and trusted because it is
digitally signed. JWTs can be signed using a secret (with the HMAC algorithm)
or a public/private key pair using RSA or ECDSA.
They can be used for:
- Authentication: including a
JWT to any HTTP request allows
Single Sign On user validation across different domains;
- Secure Information Exchange: a small amount of data can be stored in the
JWT payload, and is digitally signed to ensure its provenance and
See http://jwt.io for an introduction to
JSON Web Tokens.
Our mORMot framework now implements
HS256 (HMAC-SHA256) and
ES256 (256-bit ECDSA)
algorithms (with the addition of the
"none" weak algo);
- Validates all claims (validation dates, audiences, JWT ID);
- Thread-safe and high performance (2 µs for a
verification under x64), with optional in-memory cache if needed (e.g. for
- Stand-alone and cross-platform code (no external
with Delphi or FPC);
- Enhanced security and strong design - per instance, it is by design immune
- Full integration with the framework.
2016, Thursday November 10
By A.Bouchez on 2016, Thursday November 10, 19:36 - mORMot Framework
EKON20 is now over, and there
was a lot of people, great speakers, beautiful T-Shirt, and fresh beer!
I've published the slides of my mORMot conferences on
The "classic" Synopse/mORMot slides have also been uploaded to their latest
revision, so don't hesitate to check what's new!
The PDF are also available for
direct download from our server.
2016, Tuesday October 18
By A.Bouchez on 2016, Tuesday October 18, 13:21 - mORMot Framework
In order to follow best practice, our
.private key files are
always protected by a password. A random value with enough length and
entropy is always proposed by the
ECC tool when a key pair is
generated, and could be used directly.
It is always preferred to trust a computer to create true randomness (and
TAESPRNG was designed to be
the best possible seed, using hardware entropy if available), than using our
human brain, which could be defeated by dictionary-based password
Brute force cracking would be almost impossible, since
PBKDF2_HMAC_SHA256 Password-Based Key Derivation Function with
60,000 rounds is used, so rainbow tables (i.e. pre-computed passwords list)
will be inoperative, and each password trial would take more time than with a
regular Key Derivation Function.
The issue with strong passwords is that they are difficult to remember. If
you use not pure random passwords, but some easier to remember values with good
entropy, you may try some tools like https://xkpasswd.net/s which returns values like
But even then, you will be able to remember only a dozen of such passwords. In
a typical public key infrastructure, you may create hundredths of keys, so
remembering all passwords is no option for an average human being as (you and)
At the end, you end up with using a tool to store all your passwords (last
trend is to use an online service with browser integration), or - admit it -
store them in an
Excel document protected by a password. Most IT
people - and even security specialists - end with using such a mean of storage,
just because they need it.
The weaknesses of such solutions can be listed:
- How could we trust closed source software and third-party online
- Even open source like http://keepass.info/help/base/security.html
may appear weak (no PBKDF, no AFSplit, managed C#, SHA as PRNG);
- The storage is as safe as the "master password" is safe;
- If the "master password" is compromised, all your passwords are
- You need to know the master password to add a new item to the store.
ECC tool is able to work in "cheat mode", storing all
.private key files generated passwords in an associated
.cheat local file, encrypted using a
As a result:
- Each key pair will have its own associated
.cheat file, so you
only unleash one key at a time;
.cheat file content is meaningless without the
cheat.private key and its master password, so you can manage and
store them together with your
- Only the
cheat.public key is needed when creating a key pair,
so you won't leak your master password, and even could generate keys in an
automated way, on a distant server;
cheat.private key will be safely stored in a separated
place, only needed when you need to recover a password;
- It uses strong File Encryption, with proven PBKDF, AFSplit,
AES-PRNG, and ECDH/ECIES algorithms.
2016, Saturday September 24
By A.Bouchez on 2016, Saturday September 24, 20:10 - mORMot Framework
After weeks of implementation and testing, we introduce today a new feature
of our mORMot Open-Source Framework.
Asymmetric encryption, also known as public-key
cryptography, uses pairs of keys:
- Public keys that may be disseminated widely;
- Paired with private keys which are known only to the owner.
SynEcc unit features a full asymmetric encryption system, based on
cryptography (ECC), which may be used at application level (i.e. to
protect your application data, by signing or encrypting it), or at transmission
level (to enhance communication safety).
A full set of high-level features, including certificates and command line
tool, offers a stand-alone but complete public-key
2016, Tuesday September 6
By A.Bouchez on 2016, Tuesday September 6, 07:35 - mORMot Framework
There are still a few days for "very early birds" offer for EKON 20
conference, and meet us for 3 sessions (including a half-day
training/introduction to mORMot)!
Join us the 7-9th of November in Düsseldorf!
sessions are not restricted to mORMot, but will use
mORMot to illustrate some concepts and design ideas:
You can contact me if you want to join, so that I may give you an additional
Hope we can meet for a chat and (a few) beers!
2016, Saturday May 14
By A.Bouchez on 2016, Saturday May 14, 11:14 - mORMot Framework
In any modern application, especially on
Client/Server nTier architecture as our little mORMot offers, we
often have to persist some private keys in a safe way.
Problem with such keys is that they consist in small amount of bytes (typically
16 or 32 bytes), easy to be left somewhere in disk or memory.
Given the abilities of recent forensic data recovery
methods, data can't be destroyed on magnetic or flash storage media
We have just added to our SynCrypto OpenSource library
the Anti-forensic Information Splitter algorithm, as proposed in
TKS1, and implemented in the LUKS
LUKS is the de-facto standard of platform-independent standard on-disk
format for use in various tools.
2016, Friday April 22
By A.Bouchez on 2016, Friday April 22, 11:29 - Open Source
You should have noticed that Delphi 10.1
Berlin has been released.
Our Open Source
projects, including mORMot and SynPDF and their
associated documentation have been updated to support this new
feedback is welcome, as usual!
2016, Saturday January 9
By A.Bouchez on 2016, Saturday January 9, 16:59 - mORMot Framework
Once your application is multi-threaded, concurrent data access should be
protected. We already wrote about how debugging multi-thread
applications may be hard.
Otherwise, a "race
condition" issue may appear: for instance, if two threads modify a variable
at the same time (e.g. decrease a counter), values may become incoherent and
unsafe to use. Another symptom of broken logic is the "deadlock", by which the whole
application appears to be blocked and unresponsive, when two threads have a
wrong use of the lock, so are blocking each-others.
On a server system, which is expected to run 24/7 with no maintenance, such
issues are to be avoided.
In Delphi, protection of a resource (which may be an object, or any
variable) is usually done via Critical
A critical section is an object used to make sure, that some part of
the code is executed only by one thread at a time. A critical section
needs to be created/initialized before it can be used and be released when it
is not needed anymore. Then, some code is protected using Enter/Leave
methods, which would lock its execution: in practice, only a single
thread would own the critical section, so only a single thread would
be able to execute this code section, and other threads would wait until the
lock is released. For best performance, the protected sections should be as
small as possible - otherwise the benefit of using threads may be voided, since
any other thread would wait for the thread owning the critical section
to release the lock.
We will now see that Delphi's
TCriticalSection may have
potential issues, and what our framework proposes to ease critical
section use in your applications.
2015, Friday December 11
By A.Bouchez on 2015, Friday December 11, 21:31 - mORMot Framework
We have seen previously how the ORM part of the framework is able to provide
Trail for change tracking.
It is a very convenient way of storing the change of state of the data.
On the other side, in any modern SOA solution, data is not at the center any
more, but services.
Sometimes, the data is not stored within your server, but in a third-party
Service-Oriented Architecture (SOA).
Being able to monitor the service execution of the whole system becomes sooner
or later mandatory.
Our framework allows to create an Audit Trail of any incoming or
outgoing service operation, in a secure, efficient and automated way.
2015, Saturday November 21
By A.Bouchez on 2015, Saturday November 21, 14:30 - Pascal Programing
There is a very trendy move, since a few years, to value so called "meta-programming".
In short, it is about the ability to treat programs as their data.
It is a very powerful paradigm in functional languages, and it was also
introduced to OOP languages, even in SmallTalk a long time
before this concept was trendy in Ruby, C# or Java.
In OOP compiled languages, reflection is used to achieve a similar behavior
at run-time, mainly via RTTI (Run-Time Type
RTTI since its version 1, as it was heavily used e.g. for all UI
In our framework, we rely on RTTI for its main features:
MVC - and even in some other parts, like
Desktop UI generation.
But RTTI could easily be abused.
Here are some thoughts, started as a comment in a
good old Mason's blog article about how RTTI performance may be a
My comment was to get rid of RTTI, and follow a SOLID
implementation with explicit OOP code, like use of
2015, Tuesday November 17
By A.Bouchez on 2015, Tuesday November 17, 21:01 - mORMot Framework
If you compare with existing client/server SOA solutions (in Delphi, Java,
C# or even in Go or other frameworks), mORMot's
callback mechanism sounds pretty unique and easy to work with.
Most Events Oriented solutions do use a set of dedicated
messages to propagate the events, with a centralized Message
Bus (like MSMQ or
JMS), or a
P2P/decentralized approach (see e.g. ZeroMQ or NanoMsg). In practice, you are expected to
class per message, the
class fields being
the message values. You would define e.g. one
class to notify a
successful process, and another
class to notify an error. SOA
services would eventually tend to be defined by a huge number of individual
classes, with the temptation of re-using existing classes in several
interface-based approach allows to gather all events:
- In a single
interface type per notification, i.e.
probably per service operation;
- With one method per event;
- Using method parameters defining the event values.
Since asynchronous notifications are needed most of the time, method
parameters would be one-way, i.e. defined only
const - in such case, an evolved algorithm would
transparently gather those outgoing messages, to enhance scalability when
processing such asynchronous events. Blocking request may also be defined
var/out, as we will see below, inWorkflow
Behind the scene, the framework would still transmit raw messages over IP
sockets (currently over a
WebSockets connection), like other systems, but events notification would
benefit from using interfaces, on both server and client sides.
We will now see how...
2015, Friday October 23
By A.Bouchez on 2015, Friday October 23, 14:19 - Pascal Programing
As we already notified in
this blog, Embarcadero has been finally bought by IDERA.
received a letter from Randy Jacops, IDERA CEO.
Written in my mother language, in perfect French. Nice!
The letter states that they have 20,000 customers...
It sounds more realistic than the numbers usually given for Delphi
Even if it counts for all their tools.
In our forums, we have 1,384 registered users (real humans: we
do not accept bots via a Turing test during
It sounds like if Open Source projects are able to gather a lot of users.
And certainly because we maintain support from Delphi 6 up to Seattle (and even
Delphi 5 for some part of our libraries)... we have for sure users using
FPC/Lazarus (which we also started to support), and others which did not
upgrade to the latest Delphi version!
In Randy's letter, the community has a special place.
I hope future of Delphi would see Open Source projects brought by the community
as a chance, not as
I'm currently working on a cloud of
mORMot servers, serving content coming from high numbers of
Object Pascal powered servers, under Windows or Linux (with FPC), are working
24/7 with very low resource use.
A lot of BigData stream is gathered into
MongoDB servers, following the CQRS
It is so easy to deploy those servers (including their high performance
embedded SQlite3 database), that almost everyone in my company did install
their own "cloud", mainly for testing purpose of the objects we are
Real-time remote monitoring of the servers is very easy and integrated. You
could even see the log changing in real-time, or run your SQL requests on the
databases, with ease.
When I compare to previous projects I had to write or maintain using Java or
.Net, I can tell you that it is "something else".
The IT administrators were speechless when they discovered how it worked: no
need of containers, no need of virtual machines (but for infrastructure
The whole stack is
SOA oriented, in an
Event-Driven design (thanks to WebSockets callbacks). It follows
DDD principles, thanks to the perfect readability of the object pascal
Delphi, and Open Source, could be great to create Internet Of
2015, Monday September 28
By A.Bouchez on 2015, Monday September 28, 16:54 - mORMot Framework
Spare Parts Catalog is, as its name suggests, a software for creating
and publishing spare parts catalogs.
It uses mORMot for
client-server communication and ORM, and SynPdf for the
Sounds like a powerful solution.
It is also a testimony that you could use big databases (20 GB of blobs) with a
SQlite3 engine, and access them via REST using mORMot,
without the hassle of setting up a regular RDBMS.
If you (or Google Translate or
via this direct link on translate.ru) know a little of Russian, it is worth
previous blog article, about how the software author interacted with our
Open Source project.
In fact, Chaa did provide a lot of feedback, patches and new features
(like direct authentication via Active Directory).
Open Source could be great!
Thanks Chaa for the feedback, and interest!
2015, Friday September 25
By A.Bouchez on 2015, Friday September 25, 14:51 - mORMot Framework
In Delphi code, NULLable types do not exist as such. There is no
int? type, as in C#.
But at SQL and JSON levels, the NULL value does exist and should be converted
as expected by the ORM.
In SQLite3 itself, NULL is handled as stated in http://www.sqlite.org/lang_expr.html
IS NOT operators).
It is worth noting that NULL handling is not consistent among all existing
database engines, e.g. when you are comparing NULL with non NULL values... so
we recommend using it with care in any database statements, or only with proper
(unit) testing, when you switch from one database engine to another.
By default, in the mORMot ORM/SQL code, NULL will appear only in
case of a BLOB storage with a size of
Otherwise, you should not see it as a value,
in most kinds of ORM properties.
Null-oriented value types have been implemented in our framework, since the
object pascal language
does not allow defining a nullable type (yet).
We choose to store those values as
variant, with a set of
TNullable dedicated types, as defined in
TNullableInteger = type variant;
TNullableBoolean = type variant;
TNullableFloat = type variant;
TNullableCurrency = type variant;
TNullableDateTime = type variant;
TNullableTimeLog = type variant;
TNullableUTF8Text = type variant;
2015, Wednesday September 16
By A.Bouchez on 2015, Wednesday September 16, 20:45
We just noticed a nice feedback from a mORMot user.
Vojko Cendak commented the well-known
DataSnap analysis based on Speed & Stability tests blog article
written by Roberto some months years (!) ago.
It is not meant to be the final word, perhaps there was some tuning
possible for RTC (which is told to be very reliable), but it is worth a
We used 3 products: RO, RTC and Mormot.. I won’t speak about RO ( slow and
heavy ). We tried RTC but was too very slow and CPU consuming in getting lots
of 1000 .. 5000 dynamically fetching OPC tags (let’s say list of small objects)
– at least once per second (one client). I mean Mormot is FAST and we’re glad
to be so. We use Mormot in actual productions 24/7 on several sites: servers
don’t even blink on client requests and run smoothly and reliably.
Thanks for the kind words!
We have a lot of feedback, around the world, from users of our little Open
Source project, very happy with its abilities.
We try to make it always better! Open Source, and Delphi as a platform, do
2015, Monday August 31
By A.Bouchez on 2015, Monday August 31, 17:50 - Pascal Programing
We expected Delphi XE9, and now we have Rad Studio 10
Seattle, with Delphi renamed as Delphi 10 Seattle, or
No big news for the Delphi compiler itself (we are still waiting for
Linux server support), but a lot of FireMonkey updates,
Windows 10 compatibility enhancements, enhancements to JSON (better performance
using a SAX approach), and NoSQL/MongoDB
support in FireDAC.
The documentation is
rather sparse for the new features, but it goes into the right direction
MongoDB since a long time, in our ORM/ODM).
See what's new
Of course, our Open Source mORMot
framework supports this version.
Feedback is welcome, as usual!
Enjoy the new DX IDE!
2015, Sunday August 23
By A.Bouchez on 2015, Sunday August 23, 13:34 - mORMot Framework
You know certainly that our mORMot Open Source framework is an ORM,
i.e. mapping objects to a relational / SQL database (Object
You may have followed also that it is able to connect to a
NoSQL database, like MongoDB, and
that the objects are then mapped via an ODM (Object
Document Mapping) - the original SQL SELECT are even
translated on the fly to MongoDB queries.
But thanks to mORMot, it is not "SQL vs NoSQL" - but
"SQL and NoSQL".
You are not required to make an exclusive choice.
You can share best of both worlds, depending on your application needs.
In fact, the framework is able to add NoSQL features to a regular
relational / SQL database, by storing JSON documents in TEXT columns.
In your end-user code, you just define a
variant field in
the ORM, and store a
TDocVariant document within.
We also added some dedicated functions at SQL level, so that
SQLite3 could be used as embedded fast engine, and provide
advanced WHERE clauses on this JSON content.
2015, Saturday August 15
By A.Bouchez on 2015, Saturday August 15, 14:25 - mORMot Framework
Among all its means of transmission, our mORMot framework
WebSockets, allowing bidirectional communications, and interface-based
callbacks for real time notification of SOA events.
After several months of use in production, we identified some needed changes
for this just emerged feature.
today a breaking change of the data layout used for our proprietary
WebSockets binary protocol.
From our tests, it would increase the performance and decrease the resource
consumption, especially in case of high number of messages.
2015, Tuesday July 14
By A.Bouchez on 2015, Tuesday July 14, 17:25 - mORMot Framework
An enthusiastic mORMot user, named willo in the forum,
just started a blog about his
experiments with our framework.
The information there is clear, simple, and right to the point.
If you are a little lost in our huge documentation, it is a good place to
2015, Tuesday June 30
By A.Bouchez on 2015, Tuesday June 30, 19:01 - mORMot Framework
A lot of our code, and probably yours, is highly relying on text
In our mORMot framework, most of its features use JSON
text, encoded as UTF-8.
Profiling shows that a lot of time is spent computing the end of a text buffer,
or comparing text content.
You may know that In its SSE4.2 feature set, Intel added STTNI (String
and Text New Instructions) opcodes.
They are several new instructions that perform character searches and
comparison on two operands of 16 bytes at a time.
I've just committed optimized version of StrComp()
and StrLen(), also used for our
The patch works from Delphi 5 up to XE8, and with FPC - unknown SSE4.2 opcodes
have been entered as hexadecimal bytes, for compatibility with the last century
The resulting speed up may be worth it!
Next logical step would be to use those instruction in the JSON process
It may speed up the parsing speed of our core functions (which is already very
optimized, but written in a classical one-char-at-a-time reading).
Main benefit would be to read the incoming UTF-8 text buffer by blocks of 16
bytes, and performing several characters comparison in a few CPU cycles, with
Also JSON writing would benefit for it, since escaping could be speed up thanks
to STTNI instructions.
Any feedback is welcome, as