miab

PdxEditor replaces quite a bit

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.

A number of changes, fixes, improvements and speedups have been made compared to ZEOS 7.2.6.1-stable. Among others, OLE DB (for Windows) and ODBC protocols were added, newer versions of SQL servers were included. Feel free to test and use the ZEOS 7.3.1-beta: https://zeoslib.sourceforge.io/viewtopic.php?f=50&p=155611#p155611 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/testing-7.3/ https://github.com/marsupilami79/zeoslib Michal

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, ...