mORMot Open Source

I need advice on how to implement this scenario: I have an application server that stores a lot of information, e.g. logged in users (with their statuses, sessions), conversation history between them, daily statistical data, etc. In case of server failure, I lose everything after server restart. I have an idea to move all objects to the MongoDB database and instead of storing in local objects, store in the database and in case of failure after restarting the server (or switching to another server) the data is just still available from the MongoDB database. The question is whether this is a good way and whether mongoDB is an effective enough base to integrate with it so much. This is a revolutionary decision so I must be sure this is a good way.

How the mORMot deal with database connection lost. I'm going to use it with MS SQL and set the ORM to async mode. What's happening if I'll cut the cable between ORM machine and database, the OLE DB I'm using does not inform about connection problems.

Can someone help me implement standard http authentication?
1. End-user send the username+password through the request headers (Authorization: Basic xxxxxxxxxxxx)
2. Server creates the session token and send the create cookie request to the client
3. Every request from client must contain cookie session token

All communication will be secured by https.

Hello,
I would like to pass the select statement with params from the web browser. The backend uses THttpApiServer to serve the json response. The JSONSQLClient demo works fine when I pass the plain query statement without params through the body.

Is this possible to pass for example json with params such as:

{

"query":"select * from users where name=? and id > ?",
"params":["john","6"]

}