mORMot Open Source

You are right, i use third party tool to check integrity.
So i tought i found something wrong, but that was simply my mistake, and my problems comes from other side. Sorry for bothered you, and other members.
I return to investigation.

Best Regards

Thanks ab,
Here is a gist:
https://gist.github.com/juwo123/f48e275 … 1341c1a5bb
Here is a simple project: https://www.dropbox.com/s/j6c0kwhe1ar1p … m.zip?dl=0 - only 2 standard TSQLAuthGroup, TsqlAuthUser
I run with CreateMissingTables.
I noticed one more thing - index problem appears only when root in TSQLModel.Create([TSQLAuthGroup, TsqlAuthUser],'sss') is different than ''

Of course:
pic1: http://c-swde.com/p1.png
pic2: http://c-swde.com/p2.png
pic3: http://c-swde.com/p3.png

Thank you

Sorry for bothering - solution: o.FillFrom(table, i)

Thanks for this great framework

@edwinsn @ab thanks again for yours hints. I will try (for learning purpose) all suggestions. I have no words how valuable for me is mORMot. Thanks to this framework, in last few years, i discovered many new ways in pascal world.

Thanks a lot for new directions. Looks like i need to back to SAD documentation and rethink server part. But returning to my first question if i run mormot server as service for each client on different port with ssl (max. number of services is about 150) may i expect any problems?
I made some tests on weaker machine (2core, 2gb ram). I ran about 40 services and all worked very smooth. Surprisingly, since mormot is very well optimized,  processor usage was 0% most of the time (in real use with connected clients).
Of course so many services is not best solutions and definitely i need rework it. But, as temporary solution, windows server will be able to handle about 150 services? Someone has any experience?

edwinsn: thanks for reverse proxying sub-domains idea

Thanks a lot for your answers. I applied @edwinsn sugestion: variable and api on server

procedure TNoteServer.Model(Ctxt: TSQLRestServerURIContext);
begin
    case Ctxt.Method of
    mGET:
      Ctxt.ReturnsJson(_ObjFast(['ver', model_ver]));
    end;
end;

That works perfectly. Thanks!

@Bo you are correct i would like to avoid problems when not all clients was upgraded, or someone upgrade clients without server

Thanks for explanation and many thanks for your effort.

PS
I made small donation - I promise more when I will sell my first mormot powered application

After some tests:
This work fine:
sza := TSQLSzablon.CreateAndFillPrepare(form1.Database, 'Nazwa LIKE ?',[nazwa_wzoru]);
this not:
sza := TSQLSzablon.CreateAndFillPrepare(form1.Database, 'Nazwa = ?',[nazwa_wzoru]);
(only with national chars, without work as expected)