mORMot Open Source

I was just looking at it. Unfortunately I installed the Trial in the past to make tests with REST and now, even installing a new version, I can not use because the trial period has ended.

I'll have to find another way to test that.

Thanks for the tips.

Thanks for the help Arnaud.

We are evaluating the two options. We know the benefits of SOA. But the SOAP also has some advantages. How we work with many typed objects between Delphi and Java application server, SOAP facilitates a bit.

It's a long discussion! But we are looking for the best alternative for our case.

http://stackoverflow.com/questions/3285 … st-or-soap

Now I began to understand!

In your opinion should I design my software as in the first diagram?

I understand that TSQLRecord and TSQLRest classes, as well as the types like RawUTF8, are a kind abstract types (Super types). That is ok. But I think we're looking at the problem from different perspectives. Of course, we're on totally different levels of knowledge, but let me try to explain why I thought in the abstraction layer.

According to the uncle bob lecture ...
My software must not know the frameworks I'll use (mORMot). The frameworks need to be plugged in the software. I must not develop my software based on a framework. If I do it'll be stuck in this framework.

So the question is, how do I design my software so that it does not know the framework? How am I going to plug the framework in my software.

I thought creating an abstraction layer could solve this.

If I use any class or type of framework directly into my software I will be tying my software to the framework. Or not?

Imagine that in 5 years we decided to change ORM (I see no reason for this, just a guess), using the mORMot.pas and SynCommons.pas units I have to refactor the whole system.
I understand that mORMot has your own abstraction layers, but these layers, willingly or not, are part of the framework.

Do you think that creating a new layer of abstraction is the wrong way?

I'm having a hard time imagining how to separate the layers using DDD and mORMot. I wanted to create a diagram (fictional) where I could see more clearly the layers and organizing things with DDD.

I know that's abuse, but maybe it would be interesting to create a diagram showing an architecture using a simple software with mORMot. Something more like the real world.
Could contain:
  - A CRUD
  - A report
  - A business rule

I think it would be a very useful diagram showing how objects (entities and objects of value) fit with Repositories using mORMot on a project with DDD. At which layer the framework classes fit, etc...

Thank you.

Thank you very much. I will check this out.

I tried this method, but not work for me.

My code is like this:

Table := Client.List([], 'Select * from SGRUSR01');

The result is nil.

I dont have de TSQLRecord classes for this tables.

You have another idea?

... and about those codes i posted (Services), its possible do that?

That's not make sense for me ManUn.

We have to do that in ORM approach.

I think I found it.

in TSQLRestClientURI.UpdateFromServer method the "T.InternalState" is equal to "State" (ServerInternalState). In this case the conditional test in line 20531 don't pass and nothing happens.

i have the same problem.

http://synopse.info/forum/viewtopic.php?id=1091

That same software. The table tpeople has 10 thousand records. Every time a customer requests the data (CreateAndFillPrepare) memory consumption of the server increases almost 1 MB. Debugging realized that memory allocation is done in JSON parser. But I could not figure out why this memory is not freed.

There are no memory leaks after closing the server.

I had been using '1=1' because this parameter is required. Would not be better to let a default value for this parameter?

one more question.

I'm using the command UpdateFromServer to fetch updates the list of people. It's not working for me.

code:

var
  refreshed:boolean;
begin
  if Assigned(TableToGrid) then
  begin
    Client.UpdateFromServer([PeopleList], refreshed);   
    // I also tried  Client.UpdateFromServer([PeopleList.FillTable], refreshed); 
    if refreshed then
    begin
      TableToGrid.Refresh();
      DrawGrid1.Refresh;
    end;
  end
  else
  begin
    PeopleList := TPeople.CreateAndFillPrepare(Client, 'ID<>0');
    TableToGrid := TSQLTableToGrid.Create(DrawGrid1, PeopleList.FillTable, Client);
  end;

How should I use?

UpdateFromServer([PeopleList], refreshed) 
or 
UpdateFromServer([PeopleList.FillTable], refreshed)

I add a new record to the database via IBExpert. When executing this method (UpdateFromServer) the variable "refreshed" is false.

On the server log I notice that he does not perform a select on the database.

I suppose maybe this method only works when the table is changed exclusively thru the ORM. (Documentation: make use of the InternalState function to check the data content revision)

In this case, there is some method to update a table that eventually can be changed by another application?

I know that any manipulation in the database must pass through the server (ORM), but as we are trying to migrate an old application, it is not possible at the moment.

Yes, is a external table.

I captured this command via debug.

SELECT ID,Name,Age,BirthDate FROM People WHERE 1=1

I run this command via IBExpert and works.

I just do not have the server started.

After this line

Client:= TSQLHttpClient.Create = ('127 .0.0.1 ', '888', Model);

the Client.LastErrorException is nil.

Thanks Arnaud.

I have some questions.

I just do not know when the server connection is working or not.

I have this code:

Client:= TSQLHttpClient.Create = ('127 .0.0.1 ', '888', Model);

Is there any way to test if a connection to the server is ok?

In the example that I put in this post http://synopse.info/forum/viewtopic.php?id=1053
There is still no solution for this, right?

Now it's a bit clearer to me.

I will try to implement an example.

Thank you.

It may be necessary have more than one machine providing access to ORM.

In that case I would have to enable the property EngineAddUseSelectMaxID? Or the servers communicate with each other?

Do you have any examples of how to implement this?

Is there any mechanism for load balancing?

Thanks Arnaud.

I also do not like packages . But our project is really big, I need to evaluate this option .

It was exactly what I was talking about.

Excellent. Thank you for sharing.

Maybe we can include these classes in the framework, what do you think Arnaud?

I'm not able to compile in version 1.1.0.371 Smart Mobile Studio :
Syntax Error: There's no accessible member with name "properties"! [line: 613, column: 20, file: mORMotServer]

In my case the example is not working. By clicking on connect nothing happens. If I find something I post here.

Not bad

is good to see that other people have reached similar conclusions and results.

Amazing.

I do not know what to say. Simply Fantastic.

DBExpress: 5,7s
Aurelius: 28,4s
mORMot: 1,3s

I would like to test with this setting EngineAddUseSelectMaxID. I do not know how. this property is in TSQLRestServerStaticExternal class. How do I access this object from my client (TSQLRestClientDB)?

Thank you very much.

Thanks Arnaud.