mORMot Open Source

@Leslie7,

Very helpful! Clipped into evernote, thanks!

@danielkuettner,

Can you provide some configuration snippets to show the big picture on using Apache/Nginx as a reverse proxy, to redirect http(s) requests to a mORMot-powered http server?

Thanks.

Hi Arnaud,

I'm also interested in the DDD examples. Will it lead to "class explosion" issue, since as I understand it, each record will not have an extra wrapping class?

Wow! That's really a great achievement!

Is the list of that 119 node modules public somewhere?

@mpv,

Sorry, I'm not sure if I follow you...

All I want is to make sure the update **will fail** if the record's modified by another user.

Today I found some spare time connected from FireFox to the binding002 demo program, very cool

I use the .obj files - it's statically linked.

@ab, yes, I've been using mORMot for a long time, and this is the first time i had such situation.

PS, the db file is not entirely corrupted - Some tables are completely ok, while one of the tables will emit the originally posted error message in the server log, but, some of the record data can still be read from that so-called malfunctioned table...

@ab, No, I'm not using any database-level encryption.

@mpv, Just checked, In my program, TSQLRestServerDB.Synchronous is set to smFull;// to ensure max data stability!

@chaa, If I understand you correctly - I'm not using RemoteDataCreate() nor TSQLDBSQLite3ConnectionProperties (nor its decadent classes) directly.

PS, My win7 has the latest updated, and the db file is inside a TrueCrypt 7.1a virtual disk, but I don't think it's the problem, since I've been using TrueCrypt for over 10 years now, it's extremely stable.

And another extended question - Is it possible to cause database corruption if the program accessing it is killed by the Windows Task Manager?

It's recommended to use "batch mode":

http://synopse.info/files/html/Synopse% … l#NDX_1604

When creating the TSQLRestBatch instance, supply 'nil' for the 'aTable' param.

Caveat: When calling Add/Delete/Update methods of it, don't forget to pass the correct 'TSQLRecord' subclass, otherwise it won't work **siliently** ( suggested @ab to raise exception in this case, but he don't agree .

Thanks ab, very helpful!

Arnaud, Well done!

My most recent approach for handling detail items follows @ab's suggestion, except that **only use** types such as TObjectList, TStrings, etc (http://synopse.info/files/html/Synopse% … ml#TITL_26), that always stored as JSON arrays in the database.

Why so? Because you can take advantages of the JSON1 extension of SQLITE (https://www.sqlite.org/json1.html#jex), espciaally the json_each() function, to **directly access** the detail items in SQL, inlcuding joining regular table rows and json arrays, this is crucial, otherwise you'll lose the power of SQL statements.

In other words, do NOT use dynamic arrays to hold the detail items, because dynamic arrays will be saved as BLOB in the db.

This is my conclusion after hours studying and evaluating the JSON1 SQLite extension  today

Yes, but "viewable on any device"  != "designed with desktop web app in mind".
It's obvouse that, the layout and controls optimized for mobile web is different from one that's designed for traditional web apps.

Erick,

Congratulations! Just out of curiosity, why have you choosen EWB other than Smart Mobile Studio?

Very good questions, yes, this confuses people.

I'm not able to answer all your questions, but here is my experience FYI:

I'm currently using https://github.com/LongDirtyAnimAlf/mORMot on **Windows**, and it can cross-comiple for Linux I'm not sure about the latest versions, the last version I tried was one or two months ago. @AOG has done a great job here!

Re. NewPascal, as far as I know, currently it only offer download for Windows, and it does NOT cross-compile.

That being said, I also we can have one single download with these features:
- with the interface-patch integrated;
- runs on Windows but can cross-compile for Linux.

Actually, just FYI, I do NOT really want mORMot to be integrated into the compiler download, because mORMot updates so frequently and newPascal.org doesn't show it's interest/intention to keep up with the repository....

@erick,

Can't wait to see the mORMot interface library you are writing for EWB.

PS, does the EWB Pascal-to-JS completion also produces source-maps (https://developers.google.com/web/tools … maps?hl=en)?

Thanks, will check the video later.

Directly supporting css will be necessary, so that we can use external designs - either from open source frameworks, or designed by another designer.

@erick,

Checked the demo pages for Elevate Web Builder, sounds very powerful! And I see the controls are documented (this is most important).

Does the code editor support code completion?
What's the Pascal to JS engine do you use? I mean, is it the same as Smart Mobile Studio?  SMS is cool, except that it targets **only mobile apps**.

@ab,

I agree with you. It's more of an application design issue for handling large-scale data, rather than just about the capability of the backend DB system. But I believe that MS SQL server is easier to use than Postress, especially the administration tool part.

PS, since you mentioned use Nginx as the front-end for a mORMot application under Linux, do you have any instruction about setting up that? Thanks.

@ab,
I understand you, breaking changes are evil...

@mpv,
I"m not ssure, but with Windows Server Core, you'll have to learn PowerShell? I'd rather use linux commands now

@StxLog,

I don't think so, reading the original object, cloning it and then saving it back to the DB with a new ID would be the way to go.

@mpv, this is huge! Well done!

I own this lib but haven't used it out side of DISQLITE3: http://www.wikitaxi.org/delphi/products/stemmer/index

But I guess you  can integrate it with mORMot.