miab

Normally, after startup, there are already about 1500 threads running in Windows itself

For some time, there is a client and an example MQTT server in the ICS library.

There's always a free Zeos or a cheap UniDac. Both have the added advantage of running in Lazarus.

Here is a Demos to download:

https://github.com/Embarcadero/RADStudio10.4Demos

Or maybe a database server application with clients polling every now and then is enough?

Maybe use a chat solution, examples of which you'll find for network communication libraries like ICS or INDY.

Installation in System32 and SysWow64 is convenient for the developer, but for the end user I would rather provide a version with libraries in the application directory.

Yoy can use:

{$IFNDEF WIN64}
set path LIB32 
{$ELSE}
set path LIB64
{$ENDIF}

Place the 32 bit version of the dll in SysWOW64 and the 64 bit version in System32.

https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk/

You can use firemonkey-container

Maybe they use CheckBox-es?

There is such a test in mORMot 1.18:
mormot\SQLite3\Samples\15 - External DB performance\PerfTest.dpr

Here, for example, my results(ZEOS 8 svn7805):

Running tests using Synopse mORMot framework 1.18.6382, compiled with Delphi 11 Alexandria 32 bit, against SQLite 3.38.2, at 2022-04-28 19:45:52.

Insertion speed
     Direct    Batch    Trans    Batch Trans
SQLite3 (file full)    78    4947    47798    97382
SQLite3 (file off)    895    46449    56970    150902
SQLite3 (file off exc)    16290    152360    57546    180786
SQLite3 (mem)    46426    188964    58552    189897
ZEOS SQlite3    80    2271    48028    98382
ZEOS SQlite3 (ext full)    83    2309    46029    103982
ZEOS SQlite3 (ext off)    907    23439    55455    155424
ZEOS SQlite3 (ext off exc)    21101    135648    54687    161046
ZEOS SQlite3 (mem)    31066    156030    55969    163446
FireDAC SQlite3    11458    11450    35217    119967
UniDAC SQlite3    9192    21152    16356    41129
ODBC MSSQL2012    1551    14856    2457    18412
UniDAC MSSQL2012    1758    3637    2380    3724
ZEOS ODBC_W MSSQL2012    1937    6672    2622    40239
ZEOS ODBC_A MSSQL2012    1806    6215    2867    39693
ZEOS OleDB MSSQL2012    1971    6465    2607    51485
ZEOS Firebird    6119    50985    23009    50362
FireDAC Firebird    2796    51112    18134    51333
Oracle    956    55314    2433    82876
ZEOS Oracle    1540    60240    2852    70724
UniDAC Oracle    1084    2462    2026    2573
ZEOS PostgreSQL    1376    61229    3542    64189
FireDAC PostgreSQL    1234    18920    3415    20241
UniDAC PostgreSQL    1057    13510    1846    14945
ZEOS MySQL    2541    39168    2668    42597
FireDAC MySQL    1321    19768    1302    18890
UniDAC MySQL    2267    19860    2563    20004

Read speed
     By one    All Virtual    All Direct
SQLite3 (file full)    13286    400256    405383
SQLite3 (file off)    13083    381039    379737
SQLite3 (file off exc)    61208    383965    385297
SQLite3 (mem)    58449    389833    390289
ZEOS SQlite3    12813    218455    378845
ZEOS SQlite3 (ext full)    12501    216562    382614
ZEOS SQlite3 (ext off)    12124    206338    369248
ZEOS SQlite3 (ext off exc)    52040    211729    367484
ZEOS SQlite3 (mem)    51253    208707    370096
FireDAC SQlite3    5933    92874    126179
UniDAC SQlite3    6238    96185    136436
ODBC MSSQL2012    2497    113260    194348
UniDAC MSSQL2012    1872    133081    218722
ZEOS ODBC_W MSSQL2012    1344    159555    245712
ZEOS ODBC_A MSSQL2012    1303    141671    218856
ZEOS OleDB MSSQL2012    2497    186101    259040
ZEOS Firebird    23491    88052    126103
FireDAC Firebird    1860    62346    76218
Oracle    3111    56657    173798
ZEOS Oracle    3450    111358    156956
UniDAC Oracle    1096    51343    57296
ZEOS PostgreSQL    2801    141920    198412
FireDAC PostgreSQL    744    44931    47096
UniDAC PostgreSQL    401    90255    128710
ZEOS MySQL    2571    151860    237034
FireDAC MySQL    1063    69310    77087
UniDAC MySQL    1841    110270    158002

Michał

Why don't you use?:

-kbmmemtable

-clientdataset

-fdmemtable

-zmemtable

Michał

Interestingly, despite the change system.pas, system.dcu has not been updated.

It happened to me recently too. I repeated until success.

Cosmetic fixes in ZEOS8 svn7772
https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=73319&p=188585#p188585

Here are links to patches for the older and developed version of ZEOS:

https://zeoslib.sourceforge.io/viewtopic.php?f=3&t=143817

Link to the Zeos forum:
https://zeoslib.sourceforge.io/

Michał

You should install 32 and 64 bit PostgreSQL clients and ensure their exclusive visibility in both modes or explicitly point to the client libraries entry before the connection.

svn://svn.overbyte.be/ics
 

ZEOS 8.0.0 /trunk svn 7717

Works with: Delphi 7-Delphi 11 Alexandria, Lazarus 2.0.8-2.2.0RC2

NEW: ZMemTable - LoadFromStream/SaveToStream

https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=73319&p=183311#p183311
https://sourceforge.net/projects/zeoslib/
https://github.com/marsupilami79/zeoslib

To be able to use ZMemTable SaveToStream and LoadFrom Stream, you should enable in the zeos.inc file:
{$DEFINE ZMEMTABLE_ENABLE_STREAM_EXPORT_IMPORT} // line 97

Michał

From the level of Delphi11 I can see:
All 214
and on https://getitnow.embarcadero.com/
All 223

Indeed
 

uses
//  FMX.Forms,
  Vcl.Forms,

   ...

compiles in D11 too

As far as I know you could always mix VCL with FMX only FMX.Forms has to come before VCL.Forms:

uses
  FMX.Forms,
  Vcl.Forms,

  ...

ZEOS 8.0.0 /trunk svn 7671

Update for D11 Alexandria

https://zeoslib.sourceforge.io/viewtopic.php?f=50&p=179881#p179881

https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk/
https://github.com/marsupilami79/zeoslib?

Feel free to download, testing, use, submit comments.

Michał

#4 Auto-close