Jump to content


Popular Content

Showing content with the highest reputation on 06/25/22 in all areas

  1. Lajos Juhász

    DBGrid sort descending on Column Title Click

    In that case you use the AddIndex merhod. For more information: https://docwiki.embarcadero.com/Libraries/Sydney/en/Datasnap.DBClient.TCustomClientDataSet.AddIndex here you can find a helper procedure https://edn.embarcadero.com/article/29056 to sort.
  2. We are glad to announce that 2 New VCL Styles with Modern UI just released: https://www.delphistyles.com/vcl/ChambrayLight.html https://www.delphistyles.com/vcl/ChambrayDark.html Styles can be used together, which good to use with per-control styling feature! Also you can see how styles look with StyleControls VCL demos: https://www.almdev.com
  3. Greetings from the NexusDB Team! Please jump to the end of this message for a great EOFY Sale offer, valid for all purchases. News from the Dungeons: Development of new features in our best in class Delphi based NexusDB database engine is progressing well. Here are some new and recently added features that you may not be aware of, but which will come in handy for your projects: - Delphi 11.x Alexandria support - support for new Delphi versions is always up to date - NEW! Keyless Index engine - indices created with this engine takes up less space in a table and improves performance (see below) - NEW! Improved User privileges; users can now be assigned rights by individual database aliases and tables - NEW! User privileges can now be set and queried via new CREATE OR ALTER USER... SQL statements - NEW! 64 bit Global auto increment feature - when 4 billion discrete values is not enough to fit your requirements - NEW! Winsorized Mean aggregate SQL function, complements the standard AVG function - UPDATED! nxBackup utility greatly improved - now works as a virtual continuous backup solution for critical data - GUI editing of User privileges in Enterprise Manager in development for the next update - Single File database is being worked on, and making good progress toward alpha/beta releases later this year The new Keyless Index Engine is highly innovative, hugely reducing the size of tables and the accompanying server load. Here's an extract of a testrun of the new Keyless index engine, combined with the recently introduced Lz4 compression engine. 50% reduction in runtime and 94% reduction in table size is nothing to sneeze at! This is a targeted test; however, on a real life customer database, where Lz4 was already applied, switching to keyless indices reduced the size from 60GB to 42GB. You will want this to keep your customers happy! 😊 Running test with 5000000 records. Keyless: FALSE CompressedRecords: FALSE Elapsed: 2865555 Table size: 15724 MB Running test with 5000000 records. Keyless: TRUE CompressedRecords: TRUE Elapsed: 1423557 Table size: 599 MB And finally... Drumroll....... The EOFY offer! On all purchases until the end of June, take 50% off the normal price by entering the following code during checkout: EOFY2022 You may purchase tickets to the future via our web shop: https://www.nexusdb.com/support/index.php?q=pricing Regards, The NexusDB Team
  4. esegece

    MQTT: advice wanted

    Hello, Yes, mTLS is supported, the client can be configured with a client certificate, so the server can authenticate the client using the certificate, this is used by some IoT vendors like Amazon AWS or Azure, which are supported too. Kind Regards, Sergio