mORMot Open Source

ps. I know it's perhapns not the safest AES implmentation but it's more than enough for my purposes.

have you got technical possibility to report issue to EMB?
So (maybe) there is a chance to make real full support in 11.1...

Probably as you have said, it's paper support only..

If you want try the last time or not anyway I'm pasting with the latest commit:  https://i.imgur.com/Dl6tUbm.png

https://i.imgur.com/ZBkQLEt.png

it's old now, 3.35.4 on the way ☺

@ab, ok I thought it will need own compilation but if that's matter of your github update then ok, thx

ps. you was so right about sqlite version...current comming is : 3.32.3

@ab, good decision SQLite3MultipleCiphers  and VFS is the best way to go, serialize/deserialize due to memory issues is not an option.
In long term much harder solution will pay and I guess it should be future major sqlitle changes resistant.
+ optional compression is very nice addition.

@ab, test TestSQL3 worked, thanks,
sad news about troubles with encryption custom patch,
quick latest versions of sqlite was BIG mORMot advantage..

1) Forget about older Delphi compilers
Minimum supported XE4 or XE7 (personally I would go with Tokyo 10.2 as minimum)
At least if possible forget all before XE4

Waste of energy to maintain very old or very buggy/outdated Delphis
This energy could be spend on development new things/improving current instead of patching vendor bugs.
Aside from the topic point:
I never understand moneygrubbers who create sell their software make money on it and the same cannot spend some bucks to support creators.
Ok, maybe EMB policy and quality is far far away from beeing good anyway c'mon spending money on new compiler once a 5 years should not be big pain.
Nobody telling that you should have sub and new twice or one per year.
For those who love to be free so much - yes please, you have Lazaurs and FPC - good luck.

Now there is even stonger argument for getting rid of Old Delphi - Emb offers FREE compilers for free low income usage.
This is another argument against supporting very old.

2) SQLite object compilation - re-check which compiler produces the fastest/most realiable(least buggy) obj code:
BCC5.5 vs XE7 vs RIO 10.3.3  vs MS C++ (with coff conversion)
http://rvelthuis.de/articles/articles-cobjs.html

3) Add Argon2id, Argon2, Bcrypt/Scrypt hashing/key der.

4) Add AES GCM mode cipher,

5) Implement native 7-zip compression LZMA2, beside current solutions, native without external dlls based on c objects.

Thank you

Quick test, No problem noticed with Delphi 10.3.2 will continue testing.

Using mORMot 1.18.5378
    TSQLite3LibraryStatic 3.29.0 with internal MM
Generated with: Delphi 10.3 Rio 64 bit compiler

Time elapsed for all tests: 1m01
Performed 2019-09-24 16:54:48 by Greg0r on DESKTOP-GR

As for noticed problems looks like .o from new compiler must be used with XE6+ without issues
Anyway great results and lot of Delphi's are covered assuming usage of both "normal" and newer llvm compiler.

@ab, check msg

Fantastic! Thank you so much..
1) Successfully build with bcc64 7.40 from 10.3 Community with warnings and without -6 switch
https://i.imgur.com/8d0jkGL.png
2) While build Delphi mormot sample and 64 bit .o build above, following errs:
[dcc64 Error] SynSQLite3Static.pas(1279): E2065 Unsatisfied forward or external declaration: '_FInf'
[dcc64 Error] SynSQLite3Static.pas(1279): E2065 Unsatisfied forward or external declaration: '_Log'
[dcc64 Fatal Error] TestSQL3.dpr(874): F2063 Could not compile used unit 'SynSQLite3Static.pas'

@ab what about vc++ express and coff/comm converter?

You all guys are right totally but I'm afraid my needs are different I post frequent ~100 kb Jsons with txt data
For me it make difference if server store 50 or 30% of oryginal size.
Also I have noticed that most of even programmers doesn't know about blazing fast LZMA in fastest method compression
I agree that in normal it unusable slow for server purposes.
LZMA normal and fastest are not comparable when comes to speed.
@mpv do you know any good component or way to compress json string with LZMA in Delphi (10.2, 10.3)

@ab
For JSON txt data: Fast/fastest method it compress text much better than zip/gzip at similar speed or even faster.
(I have tested 7-zip)

Thanks

Don't worry I'm not upset, If I sound bad, sorry then.

No, it's not supported why you saying it's supported  ?
I exactly pointed out static linking and bundled 64 bit sqlite C .obj files...
So I mean full mORMmot with Sqlite 64 bit included file.
I do not mean dynamically loaded sqlite libraries.
For example want to utilize fast AES asm optimized etc.
Many people see for that and it's 2019, still not supported.
Please add.