Querious Help 5

Settings / Preferences

Some of the settings most worth knowing about.

The Preferences window
The Preferences window

Key

General #

Pane Covers
General Whether connections are restored when Querious launches, and whether recent queries in the Query view are kept between launches.
Key Bindings Keyboard shortcuts for Querious's commands.
Navigation Which object types Go To… suggests (tables and views, routines, triggers, events), each switched on or off independently.
Updates How Querious checks for new versions.

Appearance #

Pane Covers
Appearance The overall look of the application.
Editor Theme Syntax coloring for SQL editors, including your own themes.
Result Rows How values are displayed and edited in result tables: row size, column fitting, hexadecimal display of binary and geometry values, and booleans and JSON. Edit in separate window decides which column types open in their own window instead of inline. See Editing Table Content.

Views #

Pane Covers
Table Content Limit results to — the default row limit; whether rows are retrieved automatically when you select a table; whether rows are cached between searches; the default row sorting; whether sorting is remembered per table; and which large column types are not loaded automatically. See Working with Large Servers.
Query View Which database is selected in a new query editor — none, the one from the Content and Structure views, or the connection's default — and what happens when an error occurs while running several statements: stop, continue without stopping, or ask.
Query Editing Editor behavior: indentation, line wrapping, line numbers, and autocomplete — what it suggests (database, table, column, event names), whether it triggers on a delay or on Return, and whether it suggests inside comments.

Databases #

Pane Covers
MySQL Connection encoding, including Prefer utf8mb4 encoding when supported; connect and read timeouts; Allow SSL when not explicitly specified; Hide internal databases; how boolean types are interpreted; the MySQL plugin path; and whether all databases are refreshed after an SQL import.
Postgres Whether PostgreSQL support is enabled, and the default search path.
SQLite Whether SQLite support is enabled.