mORMot Open Source

Hi ab,

I need to communicate with the Chrome browser via WebSockets: https://developer.chrome.com/devtools/d … r-protocol

IIRC, it's announced few years ago, I don't think it's under active development tough.

To me, with the recent JSON support added to sqlite3, it's almost perfect in my use cases so far

@ab, sorry, I thought FormatUTF8() is a *complete* counterpart of Format() and I used "%d", and just found this comment in the source code:

// only supported token is %, with any const arguments

I think there is no ready-made methods of doing this.

Sorry, I misread your post and I thought you were talking about auto-reloading without refreshing the browser. AB has given you the correct answer.

@ab, actually I was thinking of using WebSockets too, I'll give it a try next !

@itSDS, Very nice finding and thanks for sharing!

I added to items to the benchmark list, it's ReplaceStr and ReplaceText.
Test results on my computer:

Standard StringReplace(): 0.2180 secs
StringReplace1: 0.1250 secs
StringReplace2: 0.1090 secs
StringReplace3: 1.7630 secs
StringReplace4: 0.0780 secs
FastStringReplace: 0.0310 secs
ReplaceStr: 0.2340 secs
ReplaceText: 0.3430 secs

The winner is: FastStringReplace
------------------------------------------------------------

Not sure I understand you, but the mORMot is fundamentally based on the RESTful concept.

Another web frontend framework that might be of interesting is VCL.JS - it's based on TypeScript (a language which is very similar to Delphi created by the same creator of Delphi), and it mimics the VCL's conception for component encapsulation based for the most popular html framework Twitter BootStrap.

http://www.vcljs.com/Demo/#show/PageHome/7b7d

Agreed! start from the supplied samples (over 30 samples!) and it's very very easy to understand.

@warleyalex, you are fast! And it also proves that Framework7 is easy to use while powerful

@ab, I inferred the github repository of warleyalex's example: https://github.com/smartpascal/smartms

Hi ab,

I'm really sorry, after spent hours of checking, it turned out to be a logical bug in my program but not a problem of the mORMot frame itself. I will update the original topic above.

ab, what connection properties do you mean? The TSQLRestClientURI in question is already working with other type of 'select' statements...

Never tried 'Tsql', but you can just try it ('CreateMisingTables') and see the result immediately.

I don't think it's possible with the current version of mORMot. mORMot can automatically create and update database schema from the TSQL-prefixed class models, but not the other way around.

@mvp, that sounds exciting! How much node.js module we'll be able to use with that addition?

Quoting from the sqlite.org website: "The fts4aux module is automatically included in all builds that include FTS." I'm not sure if it's the same case with mORMot.

Thanks MPV, I'm not using it in the browser, but that seems a limit of JS, is there a way to get around it, like treating the IDs as strings?

Great! Just noticed that the the json1 JSON extension has been integrated into sqlite 3.9.0 official release!

PS, there is a new 3.9.1 which includes a critical fix for a bug related to the newly added JSON features: https://www.sqlite.org/src/info/57eec374ae1d0a1d

@mpv, PS, looks like http://duktape.org/ is much simple and easy to make a wrapper, and I'm quite sure SpyderMonkey is much full-featured

Thanks @Nouba, good to know that!

PS, it's extremely useful when upgrading an existing database if one can execute multi sql statements at a time, for example, execute a bunch of SQLs from a .sql file extracted from a db management tool.

Hi Arnaud,

Yes, I can solve the problem that way. But I still tend to think the ExecuteList() should either correctly determine all field types or the user have to manually set type for all fields, otherwise it's error-prone.