mORMot Open Source

Erick,

do you have any results?

The problem is that FPC trunk - at least in this case. maybe more generally - does not handle  the address operator for a record property with a getter.

This solves the problem and makes sense performance-wise, but directly accessing the underlying pointer may violate a design principle: 

   ParamName := VMP^.NamePtr;

Good news:

https://www.sqlite.org/windowfunctions.html

Excellent!
Can you give me  what to change in the code to get it working?

Is there  way to have Android  include a stack trace with the  names of the Pascal calls into the crash report? That would be very useful as well.

AOG,

Seems you are  close.

I am curious, how do you debug an android app?

Is there a way to prevent android  from terminating the the app when there is an issue? With the usual Try Except  many times it is stopped before reaching the exception handling part.

AOG,

is the problem solved or it just does not appear on an other machine?

This is really strange. After pulling an older version for  FPC, Lazarus, LAMW, mORMot from a date when it worked for me, the problem remains the same.

I have installed NewPascal with fpcupdeluxe but the problem is the same.

@anonymous (who created the ticket)

I guess if each page of the original file can be  converted to an image (instead of single PDF) the images can be used for recreating your document with  SynPDF and sign it the way AB suggested. The size probably will be larger though.

displaying the PDF:

AcrobatReader  with OLE

OR

Delphi   - Winsoft PDFium
Lazarus - MuPDF

It is possible that  you can sign a PDF with these as well.

Edwin,

I took a look at this, but it seemed that it was saving the entire database, index data included, so the size of the result is larger than necessary. For some use cases this could be the desired behavior though.

There is a simple workaround but it is not optimal:

1. we need a thread safe temporary storage
2. where the messages are stored by the callback method
3. a jTimer instance periodically checks if there are new stored messages and clears the temporary storage after the messages are displayed

Since LAMW does not have message handling on the pascal side probably the only way to do this properly is to go to the Java side  first via JNI  and call back to the pascal side in a synchronized fashion.

ab,

wow, you are present on the forum even today ...

LAMW is for Lazarus. It creates  a CustomApplication  which uses native controls via JNI to build the GUI.  The pascal code is compiled into ".so",  so anything that works for linux  may be working here as well.

I can see a  few possible general solutions:

1. Creating a thread for the sole purpose of passing the callback messages to the main thread. (eg a synchronized calling of a function of the form) .
2. Creating the websocket client in the context of a thread instead of the main thread.  - Is this a good idea for bidir communication?
3. Msg for the main window proc - not sure, this is a real option with LAMW

Naturally FPC is the best option for Linux, but running a Delphi compiled mORMot server with wine is a viable possibility. 
It can be a temporary solution while the project is ported. But I have found at least one situation where it makes sense on the long run: when he server uses a library which has no viable equivalent for FPC.  In such a case I have found it best to create a Linux server implementing most of the functionality and an other one with Delphi. The main server forwards the requests it cannot handle to the other one which may make some  calls to the main server as well while doing its job.

I am not sure  I follow you.  TDateTime is a pascal type, right ? I need to work with date and time differences within the SQL queries. Eg to select records based on a  field value   within  7 days from a given date or within 10 minutes from a given time.
An example would be very useful.

That's the plan. But I need to create the  collation function for the native language to do that. I hoped that the easiest  and most optimized way would be to start with the current implementation  of UTF8ILComp and customize it. But it is not obvious how to do it. I assumed that this an issue with other locales as well, that is why I have asked for some general advice about tweaking the code.

My two cents: if Delphi was cared for the way AB looks after the mORMot Delphi would be far ahead in quality and functionality by now. There is so much difference in mentality, I do not think  they would be compatible.

Excellent news, Kudos to Maciej!

FPC has really matured to be a full blown competitor to Delphi even for Windows. For server side programming it makes all the sense in the world.  Dynamic loading of packages is one area where Delphi compiler is still ahead. 

I only wish there was a quality  skinning solution for LCL like AlphaSkin for VCL. The lack of it prevents Lazarus from  being a viable option for  client app development.
The Lazarus IDE is kind of a weaker link as well, CodeTyphon is closer to the Delphi experience.