Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.ditto.live/llms.txt

Use this file to discover all available pages before exploring further.

The SHOW statement allows you to view configuration parameter values that control various aspects of your Ditto instance’s behavior.

​
Syntax

DQL
SHOW ALL [LIKE pattern | ILIKE pattern [ESCAPE char]]
SHOW parameter_name
SHOW Syntax Diagram

​
SHOW ALL

Display all configuration parameters and their current values:
DQL
SHOW ALL

​
Filtering with LIKE

You can filter the parameters displayed using pattern matching:
DQL
-- Show all parameters containing "query"
SHOW ALL LIKE '%query%'

-- Show all parameters starting with "dql"
SHOW ALL LIKE 'dql%'

-- Case-insensitive pattern matching
SHOW ALL ILIKE 'DQL%'
The pattern supports:
  • % - Matches zero or more characters
  • _ - Matches exactly one character

​
Escape Characters

If you need to match literal % or _ characters in parameter names, use the ESCAPE clause:
DQL
SHOW ALL LIKE 'param\_%' ESCAPE '\'

​
SHOW Specific Parameter

Display the value of a single configuration parameter:
DQL
SHOW dql_strict_mode

​
Common Configuration Parameters

Some frequently used configuration parameters include:
ParameterDescription
dql_strict_modeControls whether strict mode is enabled for type definitions
max_query_timeMaximum execution time for queries
Use SHOW ALL to see the complete list of available configuration parameters and their current values in your Ditto instance.

​
Usage Examples

// Show all parameters
let result = await ditto.store.execute(
  query: "SHOW ALL"
)

// Show specific parameter
let strictMode = await ditto.store.execute(
  query: "SHOW dql_strict_mode"
)

// Show parameters matching pattern
let dqlParams = await ditto.store.execute(
  query: "SHOW ALL LIKE 'dql%'"
)

​
See Also