mORMot Open Source

@Junior,
Sorry to hear that and I'm glad you are recovering!

Take care, @ab and all.

I don't know Contabo. When I was switching from Linux to Windows VPS, vultr is the only acceptable option to me. I first heard about it through good words on Hacker News - which is a trust worthy community to me.

Here is the stats:
CPU: 1 vCore
RAM: 2048 MB
Storage: 55 GB SSD
Bandwidth: 2000 GB/Month
Price: $26 (VPS: $10; Windows License Fee: $16 ) = eur21.5

Maybe we can use mORMot sample 09 + Apace ab to do a side-by-side benchmark?
Maybe we can even ask all member on this forum to share about their VPS statistics?

@pvn0, how old are you then?
I have the impression that vultr is quite new - it appeared after Digital Ocean IIRC...

Yes! When the db is used as a document file format, the user might copy the file across different locals.
And yes, that hard-coded collation must be **unicode-ready**.
Thanks for your effort!

@pvn0,

Yes, I do. Just checked, I pay $26/month for a Vultr Windows VPS, maybe $10 is the Windows license fee.
I also use linux VPS (AWS/digitalocean/Linode)

Actually, vultr is the only big-names that provide decent Windows VPS at a reasonable price - the others is either expensive or slow.

If you or everybody is interested, use my reference link, I think both you and me will get some deposit 

@ab,
That's Great! But since the comments (posted below) didn't mention any Delphi versions and the code is either `{$ifdef  DELPHI6OROLDER}` or `{$ifdef CPU64}`, so I actually couldn't read the info you provided above...

But thank you all the same!

{$ifdef DOPATCHTRTL}
  {$define DOPATCHDISPINVOKE} // much faster late-binding process for our types
{$endif}
{$ifdef CPU64}
  {$define DOPATCHDISPINVOKE}
  // we NEED our patched DispInvoke to circumvent some Delphi bugs on Win64
{$endif}
{$ifdef DELPHI6OROLDER}
  {$define DOPATCHDISPINVOKE}
  // to circumvent LIdent := Uppercase() in TInvokeableVariantType.DispInvoke()
{$endif}

{$endif FPC}

I will try, but I found two lines of comments about this conditional define:
  // we NEED our patched DispInvoke to circumvent some Delphi bugs on Win64
  // to circumvent LIdent := Uppercase() in TInvokeableVariantType.DispInvoke()

Are these two items still true?

Good choices! Thanks ab for all your efforts!

Sorry, but I have to disagree. Why the exception, it doesn't make sense. `TSqlite3HttpServer ` looks good and it's comply with the new naming convention. Maybe it takes a little to get use to it

And happy new year!

I highly agree with Eugene, especially the drawback of conflict with System.UTF8String in some cases!

@ab,

Thanks for the detailed explanation!

@ab,

Thanks! Since  now sqlite.org officially provides both win32 and win64 versions of DLL download, why not just use their version...Wait! I remember now, mORMot includes an encryption layer for sqlite...

So in other words, if I don't use the mORMot encryption layer for SQLite, I can just use the official dll from sqlite.org, right?

@zed,

Wow, thanks for the help and I appreciate that!

So I confirm sqlite3 dll from https://synopse.info/files/SQLite3-64.7z does NOT working with fts5 Trigram, but dll from https://www.sqlite.org/download.html works!

@zed, I use SynSQLite3Static.pas

FTS5 Trigramidx info page: https://sqlite.org/fts5.html#trigramidx

@ab,

Thanks! Very helpful!

I also noticed TSQLDataBase.SetUseCache  will create a TSynCache object:

TSynCache.Create(16384*1024,true)

which is a 16-Mb framework-level cache.

Unfortunately, the size of the TSynCache size is hard-coded. Any chance to make it configure-able?

@ab,
Thanks for the details. And "no compile warnings" is really an extraordinary achievement - even the Delphi RTL will produce a lot of warnings IIRC

@pvn0, agreed, the scripting language has never been the issue for me to do web frontend, the lack of a RAD way of doing the UI is.

Nowadays I prefer htmx.org (successor of intercooler.js) to do the basic stuff and jquery does the rest.

What I meant is the client passes in a 'ClientId', which allows your service method to get/initialize the actual connection string.

But yes, ab had the perfect answer already

I guess you should/can pass it using a parameter of the GetQueues method?

TSyn prefix for all types are good, but I don't think we need prefix for procedures and functions - it's not a common practice  IMHO. We can just use fully qualified names for procedures and functions. for example: `unit1.procedure1`