mORMot Open Source

@AOG, I guess I found the wince problem you mentioned above: https://bugs.freepascal.org/view.php?id=33891

By the svn trunk I mean FPC and Lazarus, not mORMot.

Please google fpcupdeluxe.

Hi again my friends.

I developed a POS/Sales management system that's in production completely based on mORMot, I must say mORMot is so flexible, so powerful and of high performance, and I'm glad that I have chosen sqlite as the db engine, apart from it's of high speed, it makes the deployment so easy, and it's so easy to get the db file from the client for any investigation.

The above mentioned system is the first software I started heavily using mORMot, and it only took me days before I started designing and writing the software, and once started, I meet new requirements and I consult the documentation, the samples or this forum.

Well, I consider I myself an experienced Delphi programmer, but really, it's not that hard, I promise you that you'll never regret using mORMot once you get familiar with it.

Here are some **step by step** advises for you. (Here I assume you are familiar with the windows system, have enough database system knowledge and have basic http/web concepts)

1- Make an ORM server first.
No mater how complex your system is, the basic operations will be CRUD, so I suggest you first make an ORM server running on the windows server first, you can achieve that by modifying the "04 HTTP Client-Server" sample, all you have to do is redefine the classes being persisted b mORMot. At this step, don't consider other DB system first.

2 - Make an ORM client on windows (later on we'll tough the mobile part).
Also can be done by modifying the above mentioned 04 sample folder.
With this client, you try to implement inserting, deleting, updating and reading the objects.

3 - implement a server-side API.
You can choose interface-based API or method-based, the later will be easier, and you can learn and modify the "Project06Server" sample. Try adjust the server-side function to be close to your real needs, for example, make the "signup" method.

4 - Although I highly highly highly recommend mORMot+sqlite, because basically mORMot is essentially has turned sqlite into a multi-user, client/server database system. But anyways, start from here, you might want to change the backend database system, and then make sure the ORM and server-side function still works.

5 - Make the mobile client.
Well, I don't use the mobile client, but you can look at the "27 - CrossPlatform Clients", sample, learn and try how to generate the cross-platform clients include FireMonkey, Smart Mobile Studio and FPC.
Once you generated, for example the firemonkey client, you can use the program you done in step 2 as the blueprint, make a FireMonkey program that connect to and consumes the very same server, and ensure the ORM and server-side function works.

6 -
Once you done the above steps, I'm sure you know how to implement your real application.
The rules are, step by step, start small, and bite them piece by piece.

I wrote it in a hurry, hope it helps.

The fact that the author of mORMot (ab) is very passionated, high productive, helpful, have a high interest in optimizing the code, and that his dedicated to the mORMot framework, and he's supported by a company that's using mORMot, plus that the mORMot has been so mature and versatile, apart from the learning curve, I'm confident that **you won't be able to find another better framework** than mORMot at the moment.

As @pvn0 said, your question is too broad and you need to be specific if you want ** to be able to get help**

Just like what mpv said, in the mORMot.pas file the garbled characters are only exists in the comments, so maybe it's not worth the change.

What puzzles me is that even I have converted both the SynTests.pas and SynSelfTests.pas files to utf8 encoding from ANSI encoding, when it runs the UTF8 part would still give me many errors, but still I'm using mORMot for years without noticeable errors

@hnb,

What were you banned and can you point me to the page of the relative discussion?

Starting with the official documentation is the wrong path.

Try start with the samples, for your specific needs, check https://github.com/synopse/mORMot/blob/ … Server.dpr

And this blog series: https://tamingthemormot.wordpress.com/

On the other hand, "pas2js (used in the front-end, which is the web browser) + Lazarus + mORMot" is **already** there, what's lacking is a UI widgets library similar to the TMS ones based on pas2js.

Sorry if I'm the one who's misunderstanding the conversation here.

@warleyalex, I'm not a lawyer, but I believe that if you completely implement all the code for your library, it's definitely legal.

@ab,

There are times some exceptions can be ignored, for example, sending an email on the server-side, we might want to catch the 'internet error' and re-try again later.

On the other hand, it'll fix the issue if EchoCustom can tell TSynLog to ignore a given log entry.

@warleyalex,
I will the same about SMS although I haven't used it in deepth, but I watch the Delphi Facebook group, and I tried it earlier this year and the last year, it's cool, but it's not very stable and the document is lacking. On the other hand, I also tried Elevate Web Builder, it's looks much feature-complete and professional, and most importantly, it's very well documented.

I really have high hope on pas2js + TMS Web Core + FNC.

Do you know where to watch all the pas2js news?

I don't think so, I guess FluxBB is a pure web-based forum software.

Try this url, which shows the recent forum posts only:

https://synopse.info/forum/search.php?a … how_recent

@ab,

Sorry if I didn't make it clear - here I'm talking about the server side only. Like this:

function: TMyServerSideInterface.Method1: Integer;
begin
    // Point A
    try
      // do something.
    except // Point B
      // ignore all exceptions here.
    end;
end;

But the engine still logs exceptions raised between Point A and Point B.

Hey! I've just found the BEST solution IMHO!
With the URL Rewrite v2 and Application Request Routing modules for IIS, you can achieve the following:

Assuming you have many mORMot servers listening on local ports, for example:
http://localhost:8081
http://localhost:8082
...

And your domain is www.mysite.com, and your IIS URL Rewrite map would be something like:

<rewrite>
    <rules>
        <rule name="Reverse Proxy to webmail" stopProcessing="true">
            <match url="^client1/(.*)" />
            <action type="Rewrite" url="http://localhost:8081/{R:1}" />
        </rule>
        <rule name="Reverse Proxy to payroll" stopProcessing="true">
            <match url="^client2/(.*)" />
            <action type="Rewrite" url="http://localhost:8082/{R:1}" />
        </rule>
    </rules>
</rewrite>

And the result would be
All traffic to http://www.mysite.com/client1 will be redirected to http://localhost:8081, and
All traffic to http://www.mysite.com/client2 will be redirected to http://localhost:8082

Awesome, isn't it? I just tried on my Windows VPS with windows server 2016 (IIS 10).

Oh I almost forgot, here is the tuotrial.

Thank you two gentlemen!
@igors233, that's more than enough for now

I'm afraid of "classes explosion" (introduce too much classes) with DDD

On the other hand, even with DDD, your unit-of-work implementation is **on the ORM level** but not on the db engine level, right? So you need to use a global lock?

@juwo,
if you expose port numbers other than 80/443 you probably will encounter firewall problems in the future, and it's known not to be a good (professional) practice.

@ab,
Where I can find the code example or documentation as to implementing:

?
Thanks!

Did you tried using 'bytes = (SELECT max(bytes) FROM tracks)'?

@mpv,

Good point, it makes sense. Currently I use Windows only (so far).

@Leslie,
The old backup API does save the entire db data including the indexes either, it's the same in this regard. Not sure how to exclude the indexes...

I guess so, check https://synopse.info/forum/viewtopic.php?id=4478 which mentions the newly added sqlite feature https://www.sqlite.org/c3ref/serialize.html