mORMot Open Source

I am developing application with fts feature using mormot framework. The key problem is that I need stemmer for russian and ukrainian languages.
What is the proper way to load custom stemmer dll for sqlite using mormot framework?

I played with TSQLRestServer options and faced with a few issues.
First of all I really want to say thank you for realization of soAddUpdateReturnsContent and rsoComputeFieldsBeforeWriteOnServerSide features but could you please clarify some details of its behavior:
1. Regarding rsoGetAsJsonNotAsString: if Model doesn't contain variant field the JSON response contains its fields in the uppercase. If model contains any variant field everything works fine. I think such behavior is a bit confusing.
2. Regarding soAddUpdateReturnsContent: The response always contains object fields in the upper case.
3. Regarding rsoComputeFieldsBeforeWriteOnServerSide: It works fine for fields TModTime / TCreateTime but if I perform PUT or POST request with only few fields (not with all fields of the model) then in "onBeforeWrite" function it is possible to modify only these fields. It is a bit inconvenient as for example I need to update only one field of the model (for example "Name") but on the server side I need to update another field "last_change_user_name" in "onBeforeWrite" function and for now I can’t do that.

Many thanks in advance!

Hello!
I faced with new issue while getting JSON object response with fields in the upper case. Let me first describe my situation.
I tried to map fields as you suggest but with no luck(But still thank you for your idea, I used it for making table field's names more readable in the db). And unexpectedly I
discovered that if I add variant field to any model everything works as I need. The fields names are exectly as I set in the Model.
My model is:

type
  TProgramPlanDeleted = class(TSQLRecord)
    private
      FDeletedPlanId: TID;
      FCreateTime: TDateTime;
      FComment: Variant;
    published
      property DeletedPlanId: TID read FDeletedPlanId write FDeletedPlanId;
      property CreateTime: TDateTime read FCreateTime write FCreateTime;
      property Comment: Variant read FComment write FComment;
  end;

So without variant field "Comment" I get(http://local:8080/root/ProgramPlanDeleted/1):

{
  ID: 1,
  DELETEDPLANID: 2,
  CREATETIME: "2016-03-16"
}

And if I add variant field "Comment" I get:

{
  ID: 1,
  DeletedPlanId: 2,
  CreateTime: "2016-03-16",
  Comment: {
    a: 1
  }
}

So I resolved the issue by adding variant field to any model I use. But unfortunetly this worked only with version '1.18.1907'.

Today I updated my mormot to latest version and faced this issue again. For now in spite of variant field I always get such result:

{
  ID: 1,
  DELETEDPLANID: 2,
  CREATETIME: "2016-03-16"
}

I remind that this happens only when working with firebird db. I can't refuse from firebird nighther want to stay on old mormot  version. 
Could you please provide any help on this issue?

Thanks for the idea. But how I will force the framework to use my funciton instead of builtin one.
I'd not want to change source files.

Yes, I used version '1.18.2291'.

I can provide you with test project (modified 04 - HTTP Client-Server) if necessarily.

Well, I think the best idea is to have a possibility to add a validator on server side, wich will process the requests and responses with custom json or at least with custom error message like "errorText":"'Name' field must be unique".   
As I know usually "422 Unprocessable Entity" or "409 Conflict" errors are used in such case.

Ok, no problem. I've created a ticket and you can check it by link: http://synopse.info/fossil/tktview/f65e … e8d6c38c00
Thanks for help!

Greate news, thank you very much for a fast fix!
You did this fix for  /tablename/id query, is it possible to add this improvement for /tablename/?select=* query also? I would be very grateful if you would do it.