mORMot Open Source

Hi ab,
mORMotUILogin pas Unit causes Access violation at address 4005F50 in moudle rtl70.bpl,
after launching it through exe host and then close the form,
I build a VCL winform in dll with "Build with runtime packages" checked.
I just use it in use clause but do nothing,but the error occurred.
Can you tell me the reason or maybe a bug,you can fix it.

Hi ab,
It seems like that,I find the memory leak for the Class named TAutoFree.
when I use the TAutoFree.Create(xxx,XXXClass.Create) in a procedure or a function within a loop code,it will be a memory leak reported by FastMM4.
I encapsulated an internal procedure/function within a procedure or a function,and invoke it within a loop,for example,

function TFrmHost.LoadNetworkConfigFileAndConnectToServer: Boolean;
var
  index, retryCount: Integer;
  errorMsg, hintMsg: string;
  encrptionKey, serverAddress, serverPort, wsPort, rootName: string;

  function CheckConnectToServer(): Boolean;
  var
    fClient: TSQLRestClientURI;
    fModel: TSQLModel;
  begin
    TAutoFree.One(fModel, TSQLModel.Create([], rootName));
    TAutoFree.One(fClient, TSQLHttpClient.Create(serverAddress, serverPort, fModel));
    Result := fClient.ServerTimeStampSynchronize;
  end;

begin
  Result := False;
  retryCount := 5;
  for index := 1 to retryCount do
  begin

    Result := CheckConnectToServer;
  
  end;
      // 尝试次数达到最多仍然无法联网
  if not Result then
  begin
    ShowError('无法联网,请检查网络连接或服务器是否正常启用，稍后再试！', '发生错误');
  end;
end;

if I use TAutoFree.Create(fModel, TSQLModel.Create([], rootName)); instead of TAutoFree.One(fModel, TSQLModel.Create([], rootName));
the FastMM4 will give a memory leak report for TAutoFree,but when I use TAutoFree.One(fModel, TSQLModel.Create([], rootName));
it is fine.
Can you tell me the reason ?

Hi dear author of mORMot,I'd like to get your sincere reply.
I have a question for your framework.
you know,your framework is designed full of ORM,some bit like the Hibernate in java,all OOP designed.
but sometimes we only need the db connection pool and transaction manager ,with writing the dynamic SQL by our-self,
especially for some complex query requirements.We think ORM without any SQL written or all SQL generated by framework is
not convenient sometimes and we need more time to learn it.
Maybe you can add the functions like Mybatis in Java,only for sql-mapping by all SQL  written by our-self.
actually,we don't need to change the Database frequently on production environment.SQL dialect - Database combination is normal.
An other question is ,in SQLRecord class ,the property ID,is designed for TID,which is int64 with high primary index performance,
but it is generated with auto-increment.Can we use our ID generator written by our-self or provided by your framework?
even if it can support the string type like UUID, I think it should not be constrained by any framework,actually it will be high performance if it is designed with int64.
if the ID is filled with generated content ,it will be convenient for us to merge database content without any primary or foreign key conflict.
Thank you.