mORMot Open Source

Well, the internet provider helped and will let a .EXE run in their CGI-BIN directory. Let's the tests begin.

The solution is routing like Ruby on Rails does, using regular expressions:

http://guides.rubyonrails.org/routing.html

It's a hosted enviroment in the internet provider of my client. I can't do anything about this. Must be IIS.

mORMOt will not run in this cenario? Will have less then 100 connections / day, performance is not high priority.

Sorry for ressurect a old topic.

ServerTimeStampSynchronize() not existed when I asked the question a year ago. This is the best approach now, right?

@warleyalex: I am trying to find you in the Facebook.

Warley, tentei encontrá-lo no Facebook. Gostaria de trocar algumas idéias sobre Delphi and mORMot.

@Warley

you are using a local SQLite with mORMot, right? when I use mORMot with unigui, I use TSQLRestClientDB.

Why mORMot and Unigui makes sense?

Unigui is the server of aplication. mORMot is the server of data. Unigui's ServerModule.pas is the only mORMot client. I think I can use just TSQLRestClientDB and forget about my database because mORMot will take care of my data.

I writing the application has a single user desktop application and yet it will by used for many web clients. The complexity of threads and multi-user access is managed by the web client of Unigui and TSQLRestClientDB will manage the concurrent data access.

Trying some selects in mORMot created tables, SQLite Administrator give me this error message:

SQL Error: no such collation sequence: SYSTEMNOCASE.

I think I should change my tool. Which free sqlite admin do you recommend?

Roberto, I am from Brazil too. My parents live near to you, in Chapeco. Can I add you in Facebook?

AB, I want to make a request: please put the files sqlite3fts3.obj and sqlite3.obj on the same ZIP download of the mORMot source code.

The extra time for downloading the .ZIP is lesser than the time required to search for these *.obj in this site.

In this case, this is a stand-alone application.

And I don't know if, inside a transaction, when calling Client.Add() I should to use the SendData parameter as True or False.

I allways use JclFileUtils.FileExists(), this function was implemented using a GetFileAttributes call. It is a better approach than SysUtils.FileExists() which use FindFirst/FindNext API.

AB, what you think about writing this methos as a function Get: TObjectList?

Other question: when is better to use collections and when is better to use TObjectList with mORMot?

Emanuele, today Unigui is free, closed source. I think that Farshad will charge for the source code in the future.

I don't have used Unigui with mormot yet.

About Bigtable replacing TIniFile, I have this idea after reading this Zed Shaw's post:

http://sheddingbikes.com/posts/1277495906.html

Where he is reasoning about the advantages of using sqlite as a config file.

For sencha/ExtJS, I use www.unigui.com, very good Delphi vcl components.

Thanks. But, there are some another way in the framework to check if the server is online?

Try update your sqlite3*.obj, Armand updated sqlite engine some days ago.

Can't find this information in documentation. How can a mORMot http server know the client's IP address?

Another issue: if I declare the interfaces variables as in

type
  TForm1 = class(TForm)
  private
    Service: IPictureService;
  end;

and create a instance like:

procedure TForm1.FormShow(Sender: TObject);
begin
  // Client already created and service registered.
  Client.Services.Info(TypeInfo(IPictureService)).Get(Service);
end;

Then, if I call the Service.GetPicture() 2 or more times, some exceptions will raise when destroying the form (reference counting, OS errors etc). However, if I wrote in Form1.OnDestroy() event:

procedure TForm1.FormDestroy(Sender: TObject);
begin
  Service := nil;
end;

...then no exceptions will rise. And the termination of the application will be faster.