mORMot Open Source

For URI problem you can read this explanation.

I did not test this TestSQL3Register on Windows 8, but if it fails, then run it from administrator console (Win button + X -> Command Prompt (Admin)).
This helped me when I registered custom URI via netsh with http.sys for some .NET application.

You are simply the best . I like your comparison and explanation about what really matters, real application versus some "academic calculation" as is Mandelbrot computation...

Hm, maybe combination of both (RC + translate on demand) would worked with some "load trick", because translations should be on one place and here will be used for i18n Sisulizer solution (which natively works via resource strings).

In my personal projects I already use your implementation of i18n with success , but this badly written (not by me ) huge application is "my daily work"...

Thanks for tips, based on them I have some new ideas .

P.S.: I think that moving resourcestring in several pas units will not help, because in the end is all put in one DRC file and after that it fails.

Hi,
there is a lot of topics with headline "Newbie..." or something similar, so gather knowledge using search on this forum.
This kind of question has been asked many times.

Second, look through samples in source code and try it out.

Cloning is not allowed, you must download zip and sync it to your favorite source control (fossil, subversion, git...).
I'm doing this way.

I can share your thoughts about frustration that some code is hard to understand and that it lacks "full blown tutorial examples", but you must understand that this is 99.99% work of single person (Arnaud and he missed to point this out ) and that majority is done in his spare time.
If you take into consideration that this framework is evolving very fast (sometime I get feeling that to fast ), it is hard to cope with all subtasks at once (examples, unit tests, documentation).
Community (we all in this forum) which test mORMot on daily bases (e.g. they use it in "production code"), could help with this.

P.S.: I have done real world application with mORMot successfully, but it is based on out of date version (more then year) of the library and I must "teach myself again" to return on current track (I was out for a while) .

mORMot is very much alive and kicking beast .

Warning is not error, it is a warning .

Hi, You should use:

AddPagesToFooterAt('Page %d/%d',RightMarginPos);

Sorry for bothering you, that was my mistake .
I know when the interface goes out of scope.
I didn't really look the source code about relationship between locDB and rows (in this case).
So I didn't realized importance of "destruction" sequence.

Of course it is, but you must bring it to "life" SynProject (or download zip file), which does it .

I have thoughts about "pascal web collaboration" too, but for different aspects of usage.

1. You may translate your whole pascal code to the javascript+html+css, but this limits you to specific applications (maybe with PhoneGap you can go further).
2. You may have server and client written in pascal (Delphi, Lazarus-FPC), but client is translated to "web languages" (javascript...). Here you can have two ways of implementation scenarios: first both server and client (GUI) live on same machine as one logical application (in FPC case you can port this to many platforms, e.g. game on Android, ) and second as true client/server model where you need live connection to the Internet.
3. Write both parts in native way (server in pascal and client in "web languages") and glue them together with some prepared library (communicating objects written in pascal and javascript). Even without "glue library" this "old fashion" approach is not so missed for huge projects, where you don't want to mix presentation and business layer. Sometimes is better (for better control) to write "web code" at your favorite editor (or full blown IDE) and prepare some javascript to interact server data (mORMot JSON) with client GUI.

I really don't know what is best, but for my opinion there is no clean winner for all cases.

In case of web application frameworks we can take this link as starting point.
I did not test neither of this frameworks yet in sense ease of development and customizations, performance... Takes time to do that for all of them (list is growing every year) .

OP4JS is now SmartMobileStudio (no real business demos on their page, just "games"), Morfik looks bigger every day, uniGUI and p2js look very nice for business applications (uniGUI demos, p2js demo).

@ab: Why did you choose SmartMobileStudio in favorite to others (which are mostly not payable at "start")?

1. If you use "real localization" (e.g. multi language support), then you should follow the localization rules (resourcestrings...) and use SQLite3i18n unit and proper functions from it. Then you have many possibilities to set the current language and the regular formating (windows regional settings) will be used automatically (as already said by Arnaud), if you don't provide other option.

2. If you don't use "real localization", but hard coded one, then you may use TSQLTable.ExpandAsString function (which is used e.g. by TSQLTableToGrid), which in turn uses i18nDateText function. And to this function (which is in SynCommons unit) you can assign your custom implementation.

In 1. case assignment of i18nDateText is already done behind the scene, you must just set the current language, so usage of e.g. TSQLTableToGrid will be already in localized form.

The simplest solution is via SOA way.
You can look how is done at sample 06 - Remote JSON REST Service or 14 - Interface based services.

As I see you reverted again to the "unsafe version" (my opinion, because your example app and my example app without global assignment do not work properly on my computer).
Definitely some user will ask for solution again.

It would be better to at least put the safe version code in comments (e.g. If it does not work uncomment this...).

See answer .

Arnaud missed the first problem with constants (is not yet corrected in source, all my changes are not there), so if you made corrections as I suggested (http://synopse.info/forum/viewtopic.php?pid=3683#p3683) then it must worked .
Esmondb obviously did follow both suggestions (I'm using this as daily practice, so it is WORKING).
I'm repeating myself to often .

This was already discussed and I did provide solution. I think Arnaud missed this answer and did not yet integrate this in source.

As I know it is not yet implemented, look here for similar question,answer.

I needed too some small "update on retrieved data" (changing inner JSON content), so I changed the source (in not universal, nasty way) a little bit to do that , but I'm waiting too for the official implementation by Arnaud.

If you like to be in control then mORMot is surely for you and if you wish to learn "some tricks" then you are again on the right road .
I'm too just "an user" (I contribute for now only found bugs or corrections of bugs) of this framework and is really nice when you have a need for SOA approach, but not very good at GUI (VCL) part.
I made my own "smart grid", which has been project for itself, so it is not really good think if you are in hurry (learning this framework through commercial project), you will burn yourself, I'm almost 99.999% sure .
But if you have time to learn, don't hesitate with mORMot.
Project is more or less stabile, but because it's evolving "beast" new bugs could be introduced, that is logical.

My personal project does not use encryption, so I can't tell you about that.
But I'm heavily using threads, COM ports, mORMot ORM part (strong typed objects) and table part (TSQLTable), named pipes, i18n, compression, windows services, reporting (PDF)...

...and it works very well. If I find the bug I try to correct and report it, or at least report it.
At first I found a lot smaller bugs, but now product is more stabile and bugs are not any more so common (at least in core part).
In commercial projects when I find some version of mORMot stabile I stick with it (if I don't need new features of course) and testing new checkins only on "test polygon".

Hello, see this post.

Major drawback (for you) can be absence of TDataSet approach, which is available in DISLite3 product.
mORMot is much larger "beast" but with totally different approaches which is best for building huge and "difficult" (SOA) applications (which in turn have long development cycle anyway).

I just checked example. HERE IS THE SOLUTION!
There are two issues, one is minor related to the automatic assigning of handler (I didn't investigate further, because "basic pascal" works always as I told already in previous posts) and the other to "not assigned global constants in class creation" (I think compiler stuff, Arnaud will know about this better ).

So, Arnaud if you can include this corrections:
1. Problem: Constants should be moved to the class (it is better looking anyway , more object approach ):

TSQLite3HttpService = class(TService)
  public
    const
    SERVICENAME = 'mORMotHttpServerService';
    SERVICEDISPLAYNAME = 'mORMot Http Server Service';
  var
(...)

if param='/install' then
          TServiceController.CreateNewService('','',TSQLite3HttpService.SERVICENAME,
              TSQLite3HttpService.SERVICEDISPLAYNAME, paramstr(0),'','','','',

2. Problem:
then next part of code, should be included\changed. Asm magic does not properly stop service, but startup and communication was ok with it:

procedure ServiceControlHandler(CtrlCode: DWord); stdcall;
begin
  Service.DoCtrlHandle(CtrlCode);
end;

{ TSQLite3HttpService }

constructor TSQLite3HttpService.Create;
begin
  inherited Create(SERVICENAME,SERVICEDISPLAYNAME);
  ControlHandler := ServiceControlHandler;
(...)

I didn't look at "10 - Background Http service" example, but maybe is there some issue which is explained here.

I'm having same source code at "3" different application implementations (different compiler defines) and works just fine (at least for named pipes at mORMot level):
1. For simple testing I implemented first as all in one GUI exe.
2. Then I separated on client\server part, client as GUI exe, server as console app.
3. At last I implemented server part as windows service too.

My favorite approach is not via sub-classing, but as composition (TService is just member).
So in short you need somewhere next basic things (approach is similar to the SvcMgr.TService):

winService: TService;
(...)
procedure ServiceControlHandler(CtrlCode: DWord); stdcall;
begin
  winService.DoCtrlHandle(CtrlCode);
end;
(...)
winService := TService.Create(SERVICE_NAME, SERVICE_DESC);
winService.ControlHandler := ServiceControlHandler;
winService.OnStart := StartHandler; //* In this handler you implement mORMot startup
winService.OnStop := StopHandler;  //* ...here the mORMot shutdown
winService.OnResume := StartHandler;
winService.OnPause := StopHandler;
ServicesRun; //* this is blocking function, here you put control to the windows service manager
(...)

Hm, 6 million tests, this must be wrongly counted, because line count of all your .pas sources is less then 400000 .

For memory leakage from Delphi 2006 up next simple setting could be used as first line in dpr file:

begin
ReportMemoryLeaksOnShutdown := True;
(...)
end.

This is usually enough, at least for me.

Naturally when you design the database relations first (not ORM tool), then you connect e.g. two tables with foreign keys (if it is feasible on the chosen database, if not then the TSQLRecordMany should be used) and put some rules on it (cascade delete...). So what is here better, you have two tables and you have some automatic rules on the lowest level, this is really good if you are connecting to the database with other tools too.

Not yet, because current project (simple layout, single connecting tool to the db) which I'm working on, does need none of discussed.

I'm aware of that. But for plain description of table (1:1) is enough, e.g. from the serialization point of view (like xml serialization) when you design your model from scratch (CreateMissingTables), not for connecting to some existing database, which could be complex...
I'm aware too, that this is only syntactic sugar, not a real feature, because such behavior, could be described as is with TSQLRecordExternal and even be read from some external source (xml files, schemas). For the last one, you are pointing out generated Pascal source, what could be very cool (JSON is fine for data, but not for human editing if this is introduced too).

. That would be the ultimate test .

I'm not really in database programming, but I think that for each "real" database engine could be specified best solution (Firebird has generators, MS SQL has @@IDENTITY, SQLite3 has ROWID...) for auto generated IDs. This approach is made with many frameworks, which just abstracts low level database specifics with high level objects.

Some other way is to do with common sql, issuing select statement immediately after insert as a "batch":

INSERT INTO Table1 (Field1) VALUES (Value1);
SELECT max(ID) FROM Table1;

But for the second one, I think that all engines does not allow batch queries (exotic ones and if I remember correctly I couldn't do batch queries with IBX components for Firebird database) and atomicity is in question too (locking, transactions ?!).