mORMot Open Source

Dear ab.

I need for greater flexibility to send and receive binary files (JPG and DataSet plain) with the aim of minimizing the consumption of internet, because here in my country this is a very poor quality of service.

For this I need in the Client for iOS and Android can write functions (services) sending and receiving TServiceCustomAnswer. Including more parameters. Today it seems that only this available to receive TServiceCustomAnswer.

Here we were treated this http://synopse.info/forum/viewtopic.php?id=2592, but only for download. But also said takes to upload.

Already I sought a solution to this and found the Forum and documentation and examples. Or am I blind.

To solve the problem I am momentarily using THttpApiServer and manupulando the Ctxt: THttpServerRequest. But it seems that is not secure.

Do you have any plans to implement this or have other better solution?

Thank you.

I will try to be as brief and concise as possible in this post.

Project Characteristics:
- Server: Windows Server 2012 64-bit on Amazon. Future think of migrating to Linux when mORMot is stable in this system Operacioal;
- Database: PostgreSQL 64-bit;
- Customer Mobile: mORMot Restfull with Indy. For Android and iOS. This is my biggest challenge. The performance;
- Windows Client: Only for Administration, so I'm not too concerned about performance.
- Summary Objective: There will be two types of users. Uusário seller, in this case it may have N Shops and registered their products with PHOTOS. User Buyer, which will search the app to find a product. The application should display the list of products found with the images. And if the user selects a product, should show the other photos of the product and its characteristics. That is, each product may have N PHOTOS. Also, will talk option (chat) between sellers and customers.

Points
- Parents Brazil. 3G Internet superlenta.
- Here in Brazil there is a big difference between Download and Uploud. That is, when committing (recording) data is about 70% slower.
- I'm with 80% of this application developed for the beta.
- Initially had used DataSnap + + FireDAC Restfull that comes with Delphi. This was done because until then the client version of mORMot for Mobile was not ready. Amazingly, so it was not possible to send a photo. But now with mORMot works great.
- Let's assume that within 2 years old, have 10,000 users. Being 1,000 vendors and 9,000 buyers. And that each seller has 2 stores. And each Lodge 50 products. And each product 4 photos (JPEG images).
- For photos'm reducing the image size to 160 x 160 pixels. And JPEG format.

Questions:
- If I'm doing something wrong or tm a better way, please, can speak.
- What settings should I use in mORMot server for better performance?
- Checking other similar applications, I noticed that are very fast. In fact I was impressed. I believe they are using TThread at all. Perhaps the first to raise the list of IDs, then other TThread for each ID. And then other TThread for photos of each ID. This would be the way to a good experience for the user?
- My idea would be to store photos of different sizes. Thus could select the picture size based on internet speed and size of the device screen. This would give a better experience for the user. But still can not create a function to send / receive photos (images) using TSQLRawBlob and make the necessary conversions on the server.

I miss one such example. Who worked with images for Mobile. If you can solve some points of performance, I think of and make a post here. I think that would help.

Sorry for the great post.

Updated the mORMot yesterday (14/01/2015) night and my server no longer works for Win64. And for Win32 runs smoothly.

I went back to the previous version of the previous mORMot and worked fine for Win32 and Win64.

Had some change for Win64?

Environment tested:
- Windows 7 and Windows Server 2012 both 64-bit;
- Delphi XE7
- In Windows7 PostgreSQL for Win32. With sqlite3.dll.
- In Windows Server 2012 for PostgreSQL Win64. With sqlite3-64.dll.

The access is accused violated the stretch down the Unit SynSQLite3.pas

function TSQLDataBase.DBOpen: integer;
….
  if fOpenV2Flags<>(SQLITE_OPEN_READWRITE or SQLITE_OPEN_CREATE) then
    result := sqlite3.open_v2(pointer(utf8),fDB,fOpenV2Flags,nil) else
    result := sqlite3.open(pointer(utf8),fDB);
…

In the passage above is the violated access. Recalling that for Win32 works. And the earlier version of mORMot I have works for Win32 and Win64.

That is the problem that the current version of Git asap Win64.

I hope I was clear.

I  do not intend to change the way work anyone. And if someone harmed by my words , I'm sorry . It was an accident .

What will I put here , maybe many already know. For the project to continue to improve and increasingly , all people must earn at work. Many here know / met wonderful projects that died because at the time had this vision sustainable

Another important aspect , which can go unnoticed is the fact that many companies do not feel secure in using software from a company that does not have or do not see this side . These companies simply can not count on support in speed than accuracy . Since it is a totally free service . Therefore , many companies prefer to pay and have the assurance of a stand, you see having to wait for a longer and free solution .

In my country ( Brazil ) there is a collection of components for Delphi called ACBr ( http://www.projetoacbr.com.br/forum/ ) . Initially it was totally free. But it was growing both the number of components , as the number of users and how the importance of the components in the middle of the Delphi community

Because of this , it was created a paid support . Just to correct the shortcomings mentioned above. I confess I have not paid for support, because he had no need yet. I've done some donations . And the project continued free as always was and will continue.

Well this was just an observation. Perhaps the designs Arnaud already have something or are thinking about it .

PS . Again , sorry for bad english . This was translated automatically by Google .

Arnaud.

Use the SynPDF at a certain time. Simply spectacular.

I am seriously considering using mORMot in Windows Server Client'll need for mobile platforms (iOS and Android).

In your blog you have a topic that you said you were porting mORMot Client to run in FireMonkey.

I also know that you have a script and it is not always possible to follow this script to the letter and meet all requests.

But if possible I would like to know how this this Migration. It was taken. Not found a demo. If this underway, I wonder when it will be available.

PS. Sorry, my english sucks. This was translated in Google.

Thank you.