mORMot Open Source

Yes, I agree with you. I'm a believer and lover of mORMot's ORM/REST/RemoteAPI approaches.
I'm just posting for people's information

Speaking of SQLite FTS5, what's missing is the `offsets` function, which was provided by FTS3/4...

Great! Spring4D is great too but in most cases I don't want to introduce another not-so-small dependency, and now we have generic collections in mORMot2 too!

I like that the methods are directly attached to IList and IKeyValue. On the other hand, with Spring4D you have a LOT of interfaces and types to explorer in order to find what you need.

One question - What's the **best practice** to implement a reusable descendant of IList<T>?

With my past experiences of using **interface-based** collections, I won't say I like it very much, because, for example, with TObjectList, I can easily create an extended TObjectListEx, which I add a lot of new methods.
Let's face it - we don't have very much situations where we need a list to treat the Interger, String, Doubles, Objects, and so on, with the exactly same logic. Sometimes, it's just **too generic**.
So after years of using spring4D, I go back to use my TObjectList descendant, because in the end I figured out that all I need is just "generic collections with powerful features (loop, some, filter, etc) packed without bloating the EXE".

Hope it makes sense.

I'm still interested, what does you team use the attributes for?

I know there are some uses of attributes are very helpful:
- In Delphi Event Bus, you can use attributes to define whether you want your event handler to be run in the main thread, in the calling thread or in a dedicated thread.
- Some ORM framework uses attributes to define the object models ( I do wish I can define default db values in mORMot, BTW).

I agree with sakura and thanks him for sharing his experiences.

@sakura, speaking of similarity of mORMot1 and mORMot2, how does it feel?
Over the years I've built up a bunch of utility functions and classes based on mORMot1, I wonder in the future if I will be able to easily port them to mORMot 2.

ok, quite easy if you know how to do it, here is a working example might might be helpful for others:

class procedure TSQLMyTable.InitializeTable(Server: TSQLRestServer; const FieldName: RawUTF8; Options:
    TSQLInitializeTableOptions);
begin
  inherited;
  // the engine is adding the missing MyField1 field, we need to update the db table for this field to
  // have the default value, because the mORMot engine has no direct support for 'default field value'
  // see: https://synopse.info/forum/viewtopic.php?id=5469
  if (FieldName = 'MyField1') then
    UpdateDefaultValueForCardTextSourceProp(Server);
end;

class procedure TSQLMyTable.UpdateDefaultValueForCardTextSourceProp(const aServer: TSQLRestServer);
var
  sql: RawUTF8;
begin
  sql := FormatUtf8('UPDATE % SET MyField1 = % WHERE MyField1 IS NULL',
    [self.SQLTableName, cDefaultValueForMyField1]);
  aServer.Execute(sql);
end;

Setting default field values in the constructor only works for **new rows**, but not an existing row with missing field(s).
For the latter, you might need to take the "override TSQLRecord.InitializeTable then run TSQLRest.UpdateField() to put some default value when the field is detected as missing." approach, which is not very convenient, as described in https://synopse.info/forum/viewtopic.php?id=5469

And this is your only photo on the internet?

https://entwickler-konferenz.de/speaker/arnaud-bouchez/

I guess that's the reason I've stopped digging into it many years ago when I came across it for the first time.

Amazing work again, ab!

With all these mORMot2 improvements, I just hope it'll not that difficult when upgrading from mORMot1 in the future.

And that's why I offered to help spending their money by consuming their always-free VM

I remember SIMDJson, it was hot on hacker news: https://hn.algolia.com/?q=simdjson

And this simple project of mpv, it's really a simple example for wrapping a C++ project into a C DLL then used by Pascal. Thanks for sharing!

I guess the value of TSQLHttpServer.HttpServer.RemoteIPHeader should be set to 'X-Forwarded-For' by default?
Because according to the Mozilla docs:

Use mORMot2 (in test state) instead: https://github.com/synopse/mORMot2

And it turned out that they are not able to accept payments from people in China... very strange nowadays - we use Vista cards, paypal, and so on...

Actually Cromis Scheduler uses a separated thread to perform the loop:
https://github.com/CPsoftBE/BackupOfCro … .pas#L1048

@ab, the screenshot posted by flydev doesn't look right to me - Sqlite is backward compatible, what do you think about allowing mORMot to be compatible with **new versions** of SQLite?
Take this screenshot as an example, mORMot complains about 3.34.0 is missing while 3.34.1 (the newer version) is already provided?

@ab,

A side question - what's your tool chain for fiddling the c/c++ stuff like this?

@ab,
I'm so exciting about the upcoming integration of QuickJs to the mORMot framework!
Will it also available for mORMot 1?

BTW, I prefer js over pascal for **scripting*, because all the Pascal script engine are **dialects** (not fully compatible with Delphi or FPC). The main issue is that, when you have a problem, you'll find that you can't find enough documents, examples or other resources to help you solve the issue. On the other hand, you can instantly find a solution for any js problem!

Great work and thanks for sharing!

@ab,

IIRC, the mORMot master/slave replication does not intercept raw SQL execution direction to the db?
Also, it cannot be used to sync an old db?
And, the target must have a mORmot server running?