I am wanting lightweight access to postgresql without the bde layer (I am not using data controls). I looked at mORMmot but found it too complexing and restrictive so instead created a thread safe connection class with an Array of zeos IZConnections that I plan to place on servermodule. The clientclass which sits on mainmodule passes the sql request and a pointer to its array (dataset) to a threadsafe class of IZConnections on servermodule. Thanks to the performance of zeos, under test in a delphi app, it completed 12,000 sql requests a second to 500 threads via 20 connections to postgresql (24 sql request per second per thread) in an oracle vm.
My thoughts are that 10 or so IZConnections placed on servermodule should easily serve 500+ unigui sessions. Thus saving valuable resources (no Data.DB). I name form tconrols with a similar name to database fields so can update forms with one function call.... DBSetFormControls(self, SQL) etc. so don't need no dammed bde
So my question is this. Is placing a class of zeos IZConnections on servermodule a bad idea for any reason?
Note.... Speed of unigui through the www (via vpn prozy) using zeos IZConnections without bde is simply outstanding. Saving my bickies so I can rid myself of the unigui trial banner soon.