Suppress auto-update check silently

[metaad]

Is there a supported method to suppress or disable the automatic check for updates in SQLiteStudio silently through file or registry or command line argument to be passed during installation?

The setting is available in GUI but can you provide where the value to enable /disable is stored in file/registry.

[pawelsalawa]

It's stored in settings file: https://github.com/pawelsalawa/sqlitestudio/wiki/Configuration_directory_location in table settings

Note, that this table stores binary (serialized) value of QVariant, so you cannot just set it to ordinal true/false. You need to operate on binary data.

To see current value you can use following query and switch to Form View and there to Hex tab to see actual value:

select * from settings where [group] = 'General' and [key] = 'CheckUpdatesOnStartup';

and to insert/update it (to disabled state) you can use:

insert or replace into settings ([group], [key], value) values ('General', 'CheckUpdatesOnStartup', x'000000010000')

[metaad]

How this can be achieved programmatically through PowerShell?

[pawelsalawa]

The easiest way is to run the app, go to Options, disable updates, quit the application. Copy the config file to some storage and then restore it back to appropriate user's directory with PowerShell.

If you want the user to start with clean configuration (except for disabled updates), you should edit your side copy of settings (as it's a SQLite3 database file - you can edit it with SQLiteStudio) and delete data from all its tables, except for this single entry that matches select * from settings where [group] = 'General' and [key] = 'CheckUpdatesOnStartup';