mORMot

Yes, "composition over inheritance"

Hi,To contour the problème, I used IdTCPClient to check the availibility of the server before creating the TSQLDBWinHTTPConnectionProperties instance.Thanks anyway

I guess this is about the memory reserved per active thread.There is a thread pool in the mORMot server, so even if the memory is released in the code, there is still around 2MB of memory reserved when you run a thread.So after a while, the memory ... [More] consumption would stabilize around 20MB.Try to close the server instance, and don't leave the program.You will see the memory decrease as expected.We have seen several mORMot servers running for years now without any restart.And stable memory consumption. [Less]

You are right.Should be fixed now with https://github.com/synopse/mORMot2/commit/ad229b03

You are right.Should be fixed with https://github.com/synopse/mORMot2/commit/bd6082d8

You are right.Should be fixed now with https://github.com/synopse/mORMot2/commit/c8f9830c

Yes use rowid if you have virtual tables.

I confirme, this is a Bug under Freepascal/lazarus.You can test your self the code posted in the lazarus forumhttps://forum.lazarus.freepascal.org/in … 544.0.html

TOrmInvcanceled=class(Torm) private Ftestid: PtrInt; Fxml: rawutf8; published property testID: PtrInt read Ftestid write Ftestid; property xml:rawutf8 read Fxml write Fxml; end;procedure errororm; var lis:ilist; ... [More] model:TOrmModel; begin model:=tormmodel.Create([TOrmInvcanceled]); Model.VirtualTableRegister(TOrmInvcanceled,TOrmVirtualTableBinary); srvmem:=TRestServerDB.Create(model); srvmem.Model.Owner:=srvmem; srvmem.CreateMissingTables; showmessage(TOrmInvcanceled.OrmProps.SqlTableRetrieveAllFields); srvmem.orm.RetrieveIList(TOrmInvcanceled,lis,'testID=?',[1],'*'); end;The above causes the following error:Project Project3.exe raised exception class ESqlite3Exception with message 'Error SQLITE_ERROR (1) [SELECT ID,testID,xml FROM Invcanceled WHERE testID=?] using 3.37.0 - no such column: ID, extended_errcode=1'.if the following is used, no error exists:srvmem.orm.RetrieveIList(TOrmInvcanceled,lis,'',[],'*'); [Less]

Egh, sorry. I didn't notice that TSqlDBSQLite3Statement is a descendant of TSqlDBStatement whitch implements ISqlDBStatement and ISQLDBRows interfaces.