mORMot Open Source

@ab,
I use the very same set of Synopse Framework source code for both XE4 and FPC, so it's not possible some of the files are un-synced (out of date).

Update: Now the latest commit can be compiled under xe4.
But it surprises me that the fpc-compiled TestSQL3 program passed all test cases, while 20,293 of 40,427,058 test cases compiled by XE4 failed!

The log file is here: https://send.firefox.com/download/d16be … Ar_b_E93NQ

FPC/Lazarus trunk version 2018/01/25 TestSQL3.exe result:
===
Run on: Windows 7 64bit SP1 (6.1.7601) - codepage=936
    4 x Intel(R) Core(TM) i5-5200U CPU @ 2.20GHz (x86)
Using mORMot 1.18.4518
    TSQLite3LibraryStatic 3.23.0 with internal MM
Generated with: Free Pascal 3.1.1 MOP 32 bit compiler

Time elapsed for all tests: 1m19
Performed 2018-04-12 12:04:37 by edwin on EDWIN-T450

Total assertions failed for all test suits:  0 / 38,960,317
! All tests passed successfully.

Delphi XE4TestSQL3.exe result :
===
Run on: Windows 7 64bit SP1 (6.1.7601) - codepage=936
    4 x Intel(R) Core(TM) i5-5200U CPU @ 2.20GHz (x86)
Using mORMot 1.18.4518
    TSQLite3LibraryStatic 3.23.0 with internal MM
Generated with: Delphi XE4 32 bit compiler
Time elapsed for all tests: 5m50
Performed 2018-04-12 12:00:21 by edwin on EDWIN-T450

Total assertions failed for all test suits:  20,293 / 40,427,058
! Some tests FAILED: please correct the code.

Update 2:
Additional console output:
===
1.6. ECC cryptography:
- Reference vectors: 23 assertions passed  31.39ms
- ecc_make_key: 50 assertions passed  126.61ms
- ecdsa_sign: 50 assertions passed  128.60ms
- ecdsa_verify: 50 assertions passed  156.48ms
- ecdh_shared_secret: 147 assertions passed  271.41ms
  - Certificates and signatures: 6 / 91 FAILED  113.64ms
- ECC command line tool: 118 assertions passed  26.63s
- ECDHE stream protocol: 521,295 assertions passed  1.94s
Total failed: 6 / 521,824  - ECC cryptography FAILED  29.41s

There are more but I cannot scroll up the console window...

Unfortunately, I need to try it under Delphi xe4 but it failed to compile

[dcc32 Error] SynCommons.pas(62196): E2441 Inline function declared in interface section must not use local symbol 'COMPRESS_SYNLZ'

Yes, I got my answer from Alred - go to the Setup+ dialog and on the upper right there are edit boxes to enter the rev. numbers.

As far as I know, the Raft protocol (https://raft.github.io/) is the current mechanism for doing replication/distribution.

Two open source projects using the raft spec:
dqlite: https://github.com/CanonicalLtd/dqlite
rqlite: https://github.com/rqlite/rqlite

an interactive, graphical illustration of the raft consensus protocol:
http://thesecretlivesofdata.com/raft/

That's my question!
I might should have done some research instead of asking that, so I went ahead today to have read some material, and I found that the wikipedia page explained it very very clear:

And this:

I understand it in this way - if TSQLRecord is corresponding to a database table row, a DTO is corresponding to a "database view row". I can see benefits of such approach, for example assuming we have the following db tables:
- TSQLDepartment (with 10 fields)
- TSQLStaff (with 20 fields)

If the clients needs the following data:
- Staff's first name and last name.
- The name of the department.
It's only 3 fields from the above described two tables. We'll have two ways to transfer the data from the server to the client:
- Non-DTO way: on the client-side, read the TSQLStaff record and the corresponding TSQLDepartment record, and this involves two network round-trip and 30 fields.
- The DTO way: On the server-side we define an interface method, such as IServerApi.GetStaffFullNameAndDeptName, and the client-side needs only one call to the API and this involves one a single network round-trip and 3 fields, moreover, the client-sides code logic can be significantly simplified.

Just my humble conclusion after after reading several wikipedia pages.

Good to hear that. I believe these two new API exist for a reason. At first glance, it achieve 'run in memory entirely' with just two calls, very easy and simple than the backup API.

I have experienced a "database disk image is malformed" error because the user forced the computer to shutdown when the program is operating the sqlite db.

If you want to expose from the server-side to the client-side your stored procedure such as GetUserLoginInfo you mentioned, you have two high-level "mORMot approaches":
1 - use method-based service, or
2 - use interface-base service.

For approach #1, you can take a look at https://github.com/synopse/mORMot/blob/ … Server.dpr

Code like the following will be much much more easier and intuitive than doing everything in THttpApiServer.OnRequest.

type
  // TSQLRestServerFullMemory kind of server is light and enough for our purpose
  TServiceServer = class(TSQLRestServerFullMemory)
  published
    procedure Sum(Ctxt: TSQLRestServerURIContext);
  end;

See that? You don't even need the TSQLRecord class or the SQLITE engine.

I didn't take into account the unit file size when I was thinking about it, just thought about it logically

@mdbs99, yes, you have a valid point

@mpv, do we have a compatible Node.Js package list for syNode?

Count me in, the OwnsObjects parameter would allow us to control the lifetime of the contained objects.

Speaking of cache, does the mORMot framework has a generic object pool yet?

Hi ab,

If it makes sense, I'd suggest to include the "load_extension()" in the engine compilation if it doesn't add to much size to the resulting .obj file, you know, allow using those powerful Sqlite loadable extensions is a plus to mORMot

BTW, I want to use the following SQLITE extensions
- the 'dbdump' extension.
  for dumping data to disk and then restoring back to the db.

- the spell check extension: http://www.sqlite.org/spellfix1.html

- the csv extension: https://sqlite.org/csv.html
  For accessing a csv disk file through the SQL interface, wow!

- the carray extension: https://www.sqlite.org/carray.html
  I assume I can pass an delphi array to the sqlite engine?

- the zipfile extension: http://sqlite.org/zipfile.html
  For reading a disk .zip file.

- the appendvfs extension:https://sqlite.org/src/file/ext/misc/appendvfs.c
  For reading a sqlite db appended to the end of a .exe file.

Any instruction for using these extensions will be appreciated.

Well done and thanks for sharing!

@warleyalex, So it's a win for delphi deveopers?

One question -
- I think Ideara hasn't acquired FMSOFT?

The issue's gone now.
Thanks for the **always** very quick help!

I think the so-called initialization vector or nonce or salt, since it's already being sent to the client in plain text, when posting back to the server, just include that salt in plain text would be ok.

@mpv, oh yes, through a new firewall I installed yesterday, I noticed the 'proxy changed' notification upon fiddle4 starting and closing.

But, how to " configure a mOrmot client to use a default system proxy"?

I noticed the aProxyServer and aProxyByPass parameters for TSQLHttpClient.Create(), as I understand, I can specify a proxy server to use, and specify which hosts to not use the proxy.

Thanks again

@mpv, thanks for the info. I my previous testing Fiddler  captures only some of the http traffics but not the mORMot client traffics. Not sure why, but will try again next time.