mORMot Open Source

Well, this one is much more complicated !
No mORMot code, ZEOS (version ?), Postgresql (version ?), no code at all.
Hard to solve/help for me ...

ab,
+1 !!

Good !

Some updated info about FPC/Lazarus and RTTI.
The whole rtti branch of FPC is abandoned. But it is also not needed anymore.

Just use NewPascal: it has all the RTTI (and more) you need for the mORMot. See http://synopse.info/forum/viewforum.php?id=21
Or use fpcupdeluxe to install NewPascal anywhere you want ! See https://github.com/LongDirtyAnimAlf/Rei … /tag/0.99c

Yes, you can. And should ... ;-)

However, this separate mORMot is (only) created for the benefit of the NewPascal initiative.
This NewPascal has some features that  require (small) changes in the mORMot source.

If things are more or less stabilized, the changes could/should be merged with official mORMot. After review.
Much better to have a single source, also because changes required are minor.

But untill then, you are free (with FPC) to use the special mORMot !

With CodeTyphon, you need to change a setting (synopse.inc):

{$ifdef VER3_1}
  {$define ISFPC27}
  {$define HASDIRECTTYPEINFO} // <-------------------------------- enabled for CodeTyphon !!!!!
  // define this for trunk revisions older than June 2016 - see
  // http://wiki.freepascal.org/User_Changes_Trunk#RTTI_Binary_format_change
{$endif}

I just ran Sample 01 on Linux64 with fresh CT out-of-the-box !

Good news !!!
Some recent changes in FPC trunk (optimizers for i386 by Florian) now allow for a flawless mORMot with -O0, -O1, -O2 and -O3 on i386 !
NewPascal release will soon be updated to include these changes.

This question has been asked before.
There is no row security feature. As there is no column security feature. Only table security.

You have to write your own method to get (limit) the data you want.
I have been struggling with the same !

Hi Maciej,

I would be very very interested in these offline features and auto-sync.

In my case, a lot of data-acquisition systems are running with the mORMot. They store local and must sync remote.
Any intelligence to handle this (without me reinventing the wheel) would be a very welcome addition.

And for Android, it is nearly a natural must-have-feature.

Is this a redundant feature, already available ? Or any other reason ?? Any hint would be welcome.

@hnb
According to your experience, what are sensible values for the three timeouts on Android ?

Found the error for static on Linux !
No solution however.

Description:

In constructor TSQLite3LibraryStatic.Create all functions are assigned correctly.
I can see their correct (pointer) values.
I have removed anything else from this constructor. So only the function assignments are there.
If the debugger jumps over the sqlite3 := TSQLite3LibraryStatic.Create; all function pointers are set to the value of initialize (@sqlite3_initialize) !!
????????

@warleyalex

My Linux mORMots run on Arch Linux 64 bit, in the cloud thanks to Amazon Web Services.
Never had a single problem. I have never tried Kylix.

The final problems you encounter with Linux are known.
The record error is a simple (FPC) string problem that is not relevant nor solvable by the mORMot.
Some time ago, I have solved the DDD error (time consuming), but it got lost.
Will try to find it again.

This:
Paths --> Libraries (-Fi): C:\NewPascal\cross\lib\i386-linux\; C:\NewPascal\cross\bin\i386-linux\
should not be necessary (I hope).

Dynamic linking:
synopse.inc:

{$ifdef LINUX}
    {$ifdef CPUX86}
      {.$define FPCSQLITE3STATIC} // disable with dot !! <----------------------------
    {$endif} 
  {$endif}

The interfaceRTTI branch of the compiler from SVN does not work (does not compile). So don 't use it.
All "FPC features" of the mORMot from https://github.com/LongDirtyAnimAlf/mORMot are already included in the oficial mORMot. So don 't use it.

Unfortunately, there is no official FPC with interface RTTI.

Best Windows sources for FPC with RTTI:
http://newpascal.org/
https://github.com/dathox/newpascalpack … ss-v1.0.22 (also for easy cross-compiling towards Linux and Android)

Best Linux sources for FPC with RTTI:
Use fpc(laz)up and build the right FPC/Laz yourself.
FPC fixes: fpclazup --fpcURL="fixes" --lazURL="fixes" --fpcPATCH="fpc300rtti.patch" --verbose
FPC trunk: fpclazup --fpcURL="trunk" --lazURL="trunk" --fpcPATCH="fpctrunkrtti.patch" --verbose
Fpclazup: https://github.com/LongDirtyAnimAlf/Reiniero-fpcup

You're welcome.
Question: would it be an idea to include the (below) simple locate code into TSynSQLTableDataSet ?

TSynSQLTableDataSetWithLocate = class(TSynSQLTableDataSet)
  public
    function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions) : boolean; override;
  end;  

function  TSynSQLTableDataSetWithLocate.Locate(const KeyFields: string;
  const KeyValues: Variant; Options: TLocateOptions): boolean;
function SearchForField(const aLookupFieldName:RawUTF8;aLookupValue:variant):boolean;
var
  f,r: integer;
begin
  result:=false;
  f := Table.FieldIndex(aLookupFieldName);
  if (f<0) then exit;
  r := Table.SearchFieldEquals(VariantToString(aLookupValue),f);
  result:=(r>0);

  if result then RecNo:=r;
end;

var
  i, l, h : Integer;
  FieldList: TList;
begin
  Result := inherited;
  CheckActive;
  if IsEmpty then exit;

  Result:=True;

  if VarIsArray(KeyValues) then
  begin
    FieldList := TList.Create;
    try
      GetFieldList(FieldList, KeyFields);
      l := VarArrayLowBound(KeyValues, 1);
      h := VarArrayHighBound(KeyValues, 1);
      if (FieldList.Count = 1) and (l < h) then
      begin
        if SearchForField(KeyFields,KeyValues) then exit;
      end
      else for i := 0 to FieldList.Count - 1 do
      begin
        if SearchForField(TField(FieldList[i]).FieldName,KeyValues[l+i]) then exit;
      end;
    finally
      FieldList.Free;
    end;
  end else
    if SearchForField(KeyFields,KeyValues) then exit;

  Result:=False;
end;

Yes !
Could you imagine ... the power of mORMot with Delphi starter ... all for free !!
Unfortunately ... just limited in time ... at least the Delphi part.

@mpv
Would be good to ask the FPC devs on the FPC forum.

@Bo
The whole NewPascal install that has been made available at
https://github.com/LongDirtyAnimAlf/fpc … i/releases
has been made with fpclazup.
So, it would be fairly simple to make your own with fpclazup.

Also, it has clearly been stated that this release only works in C:\NewPascal.
Being a work-in-progress, please accept the limitations at this moment.
More features will be added in the future !

You could investigate two other possibilities, also to be explored with the help of FPC.
1) make a library (.so) with FPC and export some (ORM) methods to be used directly by you Delphi client.
2) make a localhost server (.so library) with FPC and connect with localhost with your Delphi client (exported methods: StartServer, StopServer).
You have to include this library into your Delphi app.

Then you have to dig deeper : what is the output (JSON) of :lSQLTable.GetJSONValues, after you executed your SQL ?

No hints from me yet ... ;-)
I am eagerly awaiting fixes 3.0.2, to try to fix the remaining problems !!
So, you just need a bit of patience ...

@Chaa
We will allow changes. But this is just a preview. Final will have a small app that adjusts all paths to whatever location you want.

@hnb
Sure !!

Btw, I tried to add these releases into your repo, but I did not succeed.
In fact, I want them into NewPascal ! :-)

The thing that is not ok ATM, is the fact that you need to install into c:\NewPascal.
So, a script, or a small app to adjusts paths would be nice.

But again, we are still moving towards full integration. NewPascal perfection is lingering in the near future ... ;-)

@Chaa
I hope you mean by "your project" my version of FPC on GitHub (https://github.com/LongDirtyAnimAlf/fpctrunkrtti).
Answer.
Nothing. But mine is just an older version of FPC trunk. With only the RTTI for interfaces as an extra.

To prevent further fragmentation, I decided to join the newpascal effort.

NewPascal has already interface RTTI. And is updated on a daily base. And will contain more (sometimes bleeding edge) improvements by other contributors.
It has its own website, which will (also, hopefully) become a meeting place for mORMot and FPC users.

Its still in its development phase however. So, you have to be a bit patient ... ;-)  ... until all quirks are solved ... !

Good !

Would you mind trying the normal latest official mORMot too ?
My "longdirtyanimalf" version will be removed sooner or later, because all changes are added to the official mORMot !

@edwinsn
No, its not (yet) the same.
But I think the main goal for NewPascal will be to get rid of the framentation and bring everything (and everybody) together.
So, I will work together with the NewPascal founders to have one access point for a FPC that is, among other features, tailored to run the mORMot on all platforms.
Cross-compile support will be included naturally !
Stay tuned.