mORMot Open Source

No because you're basically creating a small data warehouse. These are usually built using batch ETL processes and contain aggregates of your normalised data, which fits with your use case. You also have the option of putting the aggregates into a separate columnar database if you need even more speed - maybe something like DuckDB.

Yeah I was checking the return value but had missed that I'd declared the wrong subclass. The type of oversight that can take a while to spot :-)

Thank you! I've been meaning to get back to it and, e.g., sort out templates but it's been working great for me as-is so it keeps slipping down the list :-) I should find some time later in the week to test with WebCore before merging - thanks again.

Cheers, Bob

The problem is still present with the latest code. I've debugged further and it first appears in commit:

e778e5e8bcf79a210f7a45c15542cb97861e2ede  20/04/2023 @ 15:28

It occurs in TSynLog.LogInternalFmt at the line:

fWriter.Add(TextFmt, TextArgs, twOnSameLine,
  [woDontStoreDefault, woDontStoreVoid, woFullExpand]);

At the time it occurs TextFmt contains 'CreateMissingTables on %'.

The only thing I can see that looks odd is a chinese-type character in VWideChar in TextArgs.

I'll try and find time tomorrow to dig a bit deeper.

Cheers, Bob

I've found that the comments in v2 are usually very similar to those in v1 - anything I can't find I search a phrase from the v1 comment and always find what I need.

Cheers, Bob

I've been using TMS WebCore with mORMot for a while now and it works great - the pas2js compiler is just fantastic. It might also be worth taking a look at pas2js in Lazarus.

Since SMS died, DWScript is now available through the Quartex project. I'm planning to take a look at it soon - it certainly looks a bit more complete than SMS ever was.

Cheers, Bob

I've actually gone off AWS - primarily because of cost. Initial costs might look reasonable but bandwidth costs can be a killer, especially for a SaaS startup. I'm hoping to get mORMot integrated with one of the serverless providers in a few months - will report back! The one certainty though is that mORMot was definitely the right choice - a joy to use.

Cheers, Bob

Ok thanks - I pulled that fix but still have the problem. Will investigate....

Still getting a generic AV message (I can see the new exception in the code as I step through but it doesn't get there). For testing I'm using a VCL forms app with the following simple code in the form unit:

  TTestEnum = (tteOne = 1,
               tteTwo = 2);

  ITestIntf = interface(IInvokable)
    ['{7F2B6047-D04B-488E-AA6D-03E184BE980A}']
    function TestEnum: TTestEnum;
  end;
  ....
  initialization
    TInterfaceFactory.RegisterInterfaces([TypeInfo(ITestIntf)]);

Yes I also came across this a few months ago. The most reliable way to search the forum is to just Google, e.g., IgnoreCertificateErrors site:synopse.info/forum

In fact, the Search button on the forum should maybe just link to a page explaining how to search using Google - it's always going to be more reliable I think. With the current setup unsuspecting users could be missing a lot.

Cheers, Bob

This is really exciting stuff - well done guys!

@mpv
>For a long time we can't participate because we can't compile a mORMot in cloud environment. Now that FPC 3.2 is released it is possible.

I'm curious to understand what the problem was - just for my own understanding :-)

Thanks - and good luck.

Thanks Arnaud - yes those two points are part of my design. I'm looking at possibly using AWS for functions such as Federated Identity Management and load balancing. E.g. AWS Incognito handles logins via Google, Facebook etc. (I'll have a free tier and many users could be non-corporate). I have a vague memory you run a cloud service on mORMot - I take it your authentication is done through your own microservice since you'll have a purely corporate user base?

Cheers, Bob

The AV is caused by specifying nil for the server in the TRestStorageInMemory constructor. In v1 I can use nil in the TSQLTestStorageInMemory but in v2 the nil fRest in the base TRestOrm eventually gets used in TRestOrm.GetServerTimestamp (via TOrm.ComputeFieldsBeforeWrite).

Excellent - thank you.

I'm going to try and track down the warleyalex code but if anyone has any opinions regarding pas2js vs. DWScript I'd be interested to hear.

Thanks, Bob

Thanks Arnaud - I've found the Zeos forum and there's a section for each database.

Hi Erick - that's great news, looking forward to it. I'm specifically interested in the security aspects of your web apps - having gone through Pen Testing it sounds like it'll be an invaluable resource for mORMot web apps. I used EWB many years ago, then Smart Mobile Studio and am now on TMS Web Core (although still subscribe to SMS). Combined with the FNC components Web Core really is in a different league, and the pas2js compiler is very impressive.

Cheers, Bob

@RedOctober - I agree with edwinsn. Start with the samples, identify key classes that are used and search the forums for other info, then use the docs to complete the picture. The forums are a goldmine of useful info and you'll find it's not as complicated as it first appears.

The FNC components are very cool. I'm developing a fairly complex desktop app and I'm careful to inherit-out my visual components and keep the UI separate from my code (I build almost the entire UI in code). Using FNC I got the original VCL version running under FMX Windows in a couple of hours, and an additional couple of hours to get it running on Android. I think they're worth the money and have high hopes for TMS Web - the ability to cover that number of platforms is very impressive. I'm also an SMS subscriber and the new version is very good, but I think they've missed the boat.