ConfigDialog 0 0 866 580 Configuration Qt::PreventContextMenu 0 0 0 0 Qt::Horizontal 1 0 0 0 0 0 Search 0 0 150 0 QAbstractItemView::ScrollPerPixel false 1 General generalPage :/icons/img/config_general.png:/icons/img/config_general.png Keyboard shortcuts shortcutsPage :/icons/img/keyboard.png:/icons/img/keyboard.png Look & feel lookAndFeelPage :/icons/img/config_look_and_feel.png:/icons/img/config_look_and_feel.png Style stylePage :/icons/img/config_style.png:/icons/img/config_style.png Fonts fontsPage :/icons/img/config_font.png:/icons/img/config_font.png Code colors codeColorsPage :/icons/img/config_colors.png:/icons/img/config_colors.png Database list databaseListPage :/icons/img/database_online.png:/icons/img/database_online.png Code assistant codeAssistantPage :/icons/img/code_assistant.png:/icons/img/code_assistant.png Data browsing dataBrowsingPage :/icons/img/table.png:/icons/img/table.png Data editors dataEditorsPage :/icons/img/config_data_editors.png:/icons/img/config_data_editors.png Plugins pluginsPage :/icons/img/plugin.png:/icons/img/plugin.png Code formatters formatterPluginsPage 5 0 4 Database list If switched off, then columns will be sorted in the order they are typed in CREATE TABLE statement. Sort table columns alphabetically General.SortColumns Expand tables node when connected to a database General.ExpandTables Additional labels are those displayed next to the names on the databases list (they are blue, unless configured otherwise). Enabling this option will result in labels for databases, invalid databases and aggregated nodes (column group, index group, trigger group). For more labels see options below. Display additional labels on the list true false General.ShowDbTreeLabels For regular tables labels will show number of columns, indexes and triggers for each of tables. Display labels for regular tables General.ShowRegularTableLabels Virtual tables will be marked with a 'virtual' label. Display labels for virtual tables General.ShowVirtualTableLabels Expand views node when connected to a database General.ExpandViews If this option is switched off, then objects will be sorted in order they appear in sqlite_master table (which is in order they were created) Sort objects (tables, indexes, triggers and views) alphabetically General.SortObjects Display system tables and indexes on the list General.ShowSystemObjects Database dialog window When adding new database it is marked to be "permanent" (stored in configuration) by default. Checking this option makes every new database to NOT be "permanent" by default. Do not mark database to be "permanent" by default General.NewDbNotPermanentByDefault When this option is enabled, then files dropped from file manager onto database list will be automatically added to the list, bypassing standard database dialog. If for various reasons automatic process fails, then standard dialog will be presented to the user. Try to bypass dialog completly when dropping database file onto the list General.BypassDbDialogWhenDropped Qt::Vertical 20 40 true 0 0 433 718 Data browsing and editing Maximum number of configurations of Populate Table dialog stored in configuration. Value of 100 should be sufficient. 999999 General.PopulateHistorySize Number of data rows per page: Maximum number of configurations of Populate Table dialog stored in configuration. Value of 100 should be sufficient. Number of memorized table populating configurations <html><head/><body>If query results contain dozens (or hundreds) of columns, it is more likely that it will exhaust free memory of your computer by loading several gigabytes of data at once. SQLiteStudio may try to limit number of results displayed on one page in such cases to protect your computer. If you know that you don't work with big values in database, you can disable this limit and you will always see as many rows as defined per page.</body></html> Limit number of rows for in case of dozens of columns General.LimitRowsForManyColumns When this is enabled and user holds mouse pointer over a cell in any data view (query results, a table data, a view data) a tooltip will appear with details about the cell - it includes details like column data type, constraints, ROWID and others. Show column and row details tooltip in data view General.ShowDataViewTooltips <html><head/><body>Enable this to always enforce DEFAULT value when committing a NULL value for a column that has DEFAULT value defined, even though the column is allowed to contain NULL values.Disable this option to use DEFAULT value exclusively when NULL value is committed for column with NOT NULL constraint.</body></html> Use DEFAULT value (if defined), when committing NULL value General.UseDefaultValueForNull 150 16777215 1 99999 General.NumberOfRowsPerPage When editing a cell which used to have NULL value and entering empty string as new value, then this option determinates whether the new value should remain NULL (have this option enabled), or should it be overwritten with empty string value (have this option disabled). Keep NULL value when entering empty value General.KeepNullWhenEmptyValue <html><head/><body>By default (when this option is disabled) a real number is displayed in the format of decimals with decimal point. In some cases, when the number is really small (several places after decimal point), the default representation may appear inaccurate. In such case you may want to enable this option to use the scientific notation (i.e. 5.3e-21).</body></html> Use scientific notation for real numbers in the grid view General.UseSciFormatForDoubles Data column width <html><head/><body>When user enters new value into column and the value is bigger than the current column width, the application will enlarge the column to fit the new value, but not wider than the limit defined in the option above.</body></html> Enlarge column when entering value longer than current width General.EnlargeColumnForValue 150 16777215 When the data is read into grid view columns width is automatically adjusted. This value limits the initial width for the adjustment, but user can still resize the column manually over this limit. 10 99999 600 General.MaxInitialColumnWith <html><head/><body>When the data is read into grid view columns width is automatically adjusted. This value limits the initial width for the adjustment, but user can still resize the column manually over this limit. This value is also used when enlarging column upon new, longer value entered by the user (see option below).</body></html> Limit automatic data column width to (in pixels): <html><head/><body>Initial width of data columns will be set to at least show complete name of the column in the header. This can still be overwritten by the initial limit of column width specified in pixels (the setting above).</body></html> Keep at least the width to show complete column name General.ColumnWidthForName Inserting new row in data grid Before currently selected row true 0 General.InsertRowPlacement After currently selected row 1 General.InsertRowPlacement At the end of data view 2 General.InsertRowPlacement Table windows When enabled, Table Windows will show up with the data tab, instead of the structure tab. Open Table Windows with the data tab for start General.OpenTablesOnData When enabled the "Data" tab will be placed as first tab in every Table Window, instead of being at second place. Place data tab as first tab in a Table Window General.DataTabAsFirstInTables View windows When enabled, View Windows will show up with the data tab, instead of the structure tab. Open View Windows with the data tab for start General.OpenViewsOnData When enabled the "Data" tab will be placed as first tab in every View Window, instead of being at second place. Place data tab as first tab in a View Window General.DataTabAsFirstInViews Qt::Vertical 20 40 Qt::Horizontal 1 0 Data types General.DataEditorsOrder 3 0 0 0 0 0 Available editors: true Editors selected for this data type: true 0 0 0 0 Schema editing 150 16777215 Number of DDL changes kept in history. 9999999 General.DdlHistorySize DDL history size: Don't show DDL preview dialog when committing schema changes General.DontShowDdlPreview SQL queries 150 16777215 Number of queries kept in the history. 999999 General.SqlHistorySize Maximum number of query parameters (:param, @param, $param, ?) stored in history. When you re-use parameter with the same name/position, SQLiteStudio will pre-initialize it with most recent memorized value (you will still be able to change it). Value of 1000 should be sufficient. Number of memorized query parameters Maximum number of query parameters (:param, @param, $param, ?) stored in history. When you re-use parameter with the same name/position, SQLiteStudio will pre-initialize it with most recent memorized value (you will still be able to change it). Value of 1000 should be sufficient. 999999 General.BindParamsCacheSize <html><head/><body>If there is more than one query in the SQL editor window, then (if this option is enabled) only a single query will be executed - the one under the keyboard insertion cursor. Otherwise all queries will be executed. You can always limit queries to be executed by selecting those queries before calling to execute. You can also use dedicated shortcuts for executing in one mode or the other (currently configured to %1 for single query execution and %2 for all queries execution).</body></html> Execute only the query under the cursor General.ExecuteCurrentQueryOnly Number of queries kept in the history. History size: <html><head/><body>If enabled, lines longer than the editor width will be wrapped, so horizontal scrolling will not be needed.</body></html> Wrap lines in SQL editor General.SqlEditorWrapWords <html><head/><body>Highlights entire query that is currently under the insertion cursor. It's the same query that will be executed when you hit "Execute query" hotkey or button (unless configured otherwise).</body></html> Highlight current query General.SqlEditorCurrQueryHighlight Updates Automatically check for updates at startup General.CheckUpdatesOnStartup Session Restore last session (active MDI windows) after startup General.RestoreSession Allow multiple instances of the application at the same time General.AllowMultipleSessions Status Field When user manually closes the Status panel, this option makes sure that if any new message is printed in the Status panel it will be reopened. If it's disabled, then Status panel can only be open manually by the user from the "View" menu. Always open Status panel when new message is printed General.AutoOpenStatusField Qt::Vertical 20 40 15 Qt::Vertical 20 40 0 0 Code syntax colors Keyword foreground Colors.SyntaxKeywordFgCustom 50 16777215 Colors.SyntaxForeground 50 16777215 Colors.SyntaxBlobFg 50 16777215 Colors.SyntaxKeywordFg 50 16777215 Colors.SyntaxValidObject 50 16777215 Colors.SyntaxCommentFg Regular foreground Colors.SyntaxForegroundCustom Comment foreground Colors.SyntaxCommentFgCustom 50 16777215 Colors.SyntaxNumberFg Number foreground Colors.SyntaxNumberFgCustom 50 16777215 Colors.SyntaxParenthesisBg Valid objects foreground Colors.SyntaxValidObjectCustom 50 16777215 Colors.SyntaxStringFg 50 16777215 <html><head/><body>You can disable current query highlighting entirely on the General settings page.</body></html> Colors.SyntaxCurrentQueryBg BLOB value foreground Colors.SyntaxBlobFgCustom String foreground Colors.SyntaxStringFgCustom 50 16777215 Colors.SyntaxCurrentLineBg Colors.SyntaxParenthesisFg Bind parameter foreground Colors.SyntaxBindParamFgCustom 50 16777215 Colors.SyntaxBindParamFg Current line background Colors.SyntaxCurrentLineBgCustom Current query background Colors.SyntaxCurrentQueryBgCustom Matched parenthesis background Colors.SyntaxParenthesisBgCustom Matched parenthesis foreground Colors.SyntaxParenthesisFgCustom QFrame::NoFrame QFrame::Raised 0 0 0 0 0 Reset to defaults 0 0 0 0 Filter shortcuts by name or key combination Qt::NoFocus QAbstractItemView::NoEditTriggers false QAbstractItemView::NoSelection 0 false true false 16 150 false Action Key combination 0 0 0 0 true 0 0 364 283 Language Changing language requires application restart to take effect. General.Language Compact layout Compact layout reduces all margins and spacing on the UI to minimum, making space for displaying more data. It makes the interface a little bit less aesthetic, but allows to display more data at once. Use compact layout true General.CompactLayout Main window dock areas Left and right areas occupy corners :/icons/img/dock_layout_vertical.png:/icons/img/dock_layout_vertical.png true General.DockLayout vertical Top and bottom areas occupy corners :/icons/img/dock_layout_horizontal.png:/icons/img/dock_layout_horizontal.png General.DockLayout horizontal Qt::Vertical 20 40 0 0 Qt::NoFocus QAbstractItemView::NoEditTriggers false QAbstractItemView::NoSelection QAbstractItemView::ScrollPerPixel 0 false false 2 false false 1 2 0 0 0 0 Qt::Horizontal 40 20 Hide built-in plugins 0 0 0 0 Current style: General.Style Preview 0 Enabled 0 0 0 0 24 CheckBox 50 Qt::Vertical Qt::Vertical PushButton 0 0 Qt::AlignCenter Column 123 11111 22222 33333 456 44444 55555 66666 ... RadioButton ABC ABC XYZ <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"> <html><head><meta name="qrichtext" content="1" /><meta charset="utf-8" /><style type="text/css"> p, li { white-space: pre-wrap; } hr { height: 1px; border-width: 0; } li.unchecked::marker { content: "\2610"; } li.checked::marker { content: "\2612"; } </style></head><body style=" font-family:'Segoe UI'; font-size:9pt; font-weight:400; font-style:normal;"> Abcdefgh</body></html> Disabled 0 0 0 0 true QAbstractItemView::ScrollPerPixel false false false Language Active formatter plugin Configuration QFrame::NoFrame 0 true 0 0 222 313 SQL editor font Fonts.SqlEditor Database list font Fonts.DbTree Database list additional label font Fonts.DbTreeLabel Data view font Fonts.DataView Status field font Fonts.StatusField Qt::Vertical 20 40 Code assistant settings <html><head/><body>If this option is enabled, the code assistant will be triggered in cases, when user types for example tableName. to propose columns of the table. If the option is disabled, user will have to hit the assistant hotkey explicitly.</body></html> Automatically trigger the assistant after a dot is typed after an object name CodeAssistant.AutoTrigger Qt::Vertical 20 40 Qt::Horizontal QDialogButtonBox::Apply|QDialogButtonBox::Cancel|QDialogButtonBox::Ok ConfigRadioButton QRadioButton

common/configradiobutton.h

FontEdit QWidget

common/fontedit.h

1 ColorButton QPushButton

common/colorbutton.h

categoriesFilter categoriesTree pluginsList buttonBox expandViewsCheck sortObjects sortColumns ddlHistorySizeSpin dontShowDdlPreview queryHistorySizeSpin execQueryUnderCursorCheck expandTablesCheck activeStyleCombo previewTabs previewCheckBox previewVerticalSlider previewPushButton previewSpinBox previewTreeWidget previewToolButton previewLineEdit previewRadioButton previewComboBox previewTextEdit fontsScrollArea buttonBox accepted() ConfigDialog accept() 248 254 157 274 buttonBox rejected() ConfigDialog reject() 316 260 286 274