SQLite Browser¶

Description / name	Input element
Your domain name

Overview¶

SQLite Browser is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

Manual

Releases

Community

Deployment¶

sb install sandbox-sqlitebrowser

Usage¶

Visit https://sqlitebrowser.iYOUR_DOMAIN_NAMEi.

By default, the role is protected behind your Authelia/SSO middleware.

Role Defaults¶

Use the Inventory to customize variables. (1)

Example override
```
sqlitebrowser_name: "custom_value"
```
Avoid overriding variables ending in _default

When overriding variables that end in _default (like sqlitebrowser_docker_envs_default), you replace the entire default configuration. Future updates that add new default values will not be applied to your setup, potentially breaking functionality.

Instead, use the corresponding _custom variable (like sqlitebrowser_docker_envs_custom) to add your changes. Custom values are merged with defaults, ensuring you receive updates.

BasicsWebDNSTraefikDockerDocker+Global Override Options

sqlitebrowser_name

# Type: string
sqlitebrowser_name: sqlitebrowser

sqlitebrowser_role_web_subdomain

# Type: string
sqlitebrowser_role_web_subdomain: "{{ sqlitebrowser_name }}"

sqlitebrowser_role_web_domain

# Type: string
sqlitebrowser_role_web_domain: "{{ user.domain }}"

sqlitebrowser_role_web_port

# Type: string
sqlitebrowser_role_web_port: "3000"

sqlitebrowser_role_web_url

# Type: string
sqlitebrowser_role_web_url: "{{ 'https://' + (lookup('role_var', '_web_subdomain', role='sqlitebrowser') + '.' + lookup('role_var', '_web_domain', role='sqlitebrowser')
                             if (lookup('role_var', '_web_subdomain', role='sqlitebrowser') | length > 0)
                             else lookup('role_var', '_web_domain', role='sqlitebrowser')) }}"

sqlitebrowser_role_dns_record

# Type: string
sqlitebrowser_role_dns_record: "{{ lookup('role_var', '_web_subdomain', role='sqlitebrowser') }}"

sqlitebrowser_role_dns_zone

# Type: string
sqlitebrowser_role_dns_zone: "{{ lookup('role_var', '_web_domain', role='sqlitebrowser') }}"

sqlitebrowser_role_dns_proxy

# Type: bool (true/false)
sqlitebrowser_role_dns_proxy: "{{ dns_proxied }}"

sqlitebrowser_role_traefik_sso_middleware

# Type: string
sqlitebrowser_role_traefik_sso_middleware: "{{ traefik_default_sso_middleware }}"

sqlitebrowser_role_traefik_middleware_default

# Type: string
sqlitebrowser_role_traefik_middleware_default: "{{ traefik_default_middleware }}"

sqlitebrowser_role_traefik_middleware_custom

# Type: string
sqlitebrowser_role_traefik_middleware_custom: ""

sqlitebrowser_role_traefik_certresolver

# Type: string
sqlitebrowser_role_traefik_certresolver: "{{ traefik_default_certresolver }}"

sqlitebrowser_role_traefik_enabled

# Type: bool (true/false)
sqlitebrowser_role_traefik_enabled: true

sqlitebrowser_role_traefik_api_enabled

# Type: bool (true/false)
sqlitebrowser_role_traefik_api_enabled: false

sqlitebrowser_role_traefik_api_endpoint

# Type: string
sqlitebrowser_role_traefik_api_endpoint: ""

sqlitebrowser_role_traefik_error_pages_enabled

# Type: bool (true/false)
sqlitebrowser_role_traefik_error_pages_enabled: false

Container

sqlitebrowser_role_docker_container

# Type: string
sqlitebrowser_role_docker_container: "{{ sqlitebrowser_name }}"

Image

sqlitebrowser_role_docker_image_pull

# Type: bool (true/false)
sqlitebrowser_role_docker_image_pull: true

sqlitebrowser_role_docker_image_repo

# Type: string
sqlitebrowser_role_docker_image_repo: "lscr.io/linuxserver/sqlitebrowser"

sqlitebrowser_role_docker_image_tag

# Type: string
sqlitebrowser_role_docker_image_tag: "latest"

sqlitebrowser_role_docker_image

# Type: string
sqlitebrowser_role_docker_image: "{{ lookup('role_var', '_docker_image_repo', role='sqlitebrowser') }}:{{ lookup('role_var', '_docker_image_tag', role='sqlitebrowser') }}"

Envs

sqlitebrowser_role_docker_envs_default

# Type: dict
sqlitebrowser_role_docker_envs_default:
  TZ: "{{ tz }}"
  PUID: "{{ uid }}"
  PGID: "{{ gid }}"

sqlitebrowser_role_docker_envs_custom

# Type: dict
sqlitebrowser_role_docker_envs_custom: {}

Volumes

sqlitebrowser_role_docker_volumes_default

# Type: list
sqlitebrowser_role_docker_volumes_default:
  - "{{ lookup('role_var', '_paths_location', role='sqlitebrowser') }}:/config"

sqlitebrowser_role_docker_volumes_custom

# Type: list
sqlitebrowser_role_docker_volumes_custom: []

Hostname

sqlitebrowser_role_docker_hostname

# Type: string
sqlitebrowser_role_docker_hostname: "{{ sqlitebrowser_name }}"

Networks

sqlitebrowser_role_docker_networks_alias

# Type: string
sqlitebrowser_role_docker_networks_alias: "{{ sqlitebrowser_name }}"

sqlitebrowser_role_docker_networks_default

# Type: list
sqlitebrowser_role_docker_networks_default: []

sqlitebrowser_role_docker_networks_custom

# Type: list
sqlitebrowser_role_docker_networks_custom: []

Restart Policy

sqlitebrowser_role_docker_restart_policy

# Type: string
sqlitebrowser_role_docker_restart_policy: unless-stopped

State

sqlitebrowser_role_docker_state

# Type: string
sqlitebrowser_role_docker_state: started

The following advanced options are available via create_docker_container but are not defined in the role. See: docker_container module

Resource Limits

sqlitebrowser_role_docker_blkio_weight

# Type: int
sqlitebrowser_role_docker_blkio_weight:

sqlitebrowser_role_docker_cpu_period

# Type: int
sqlitebrowser_role_docker_cpu_period:

sqlitebrowser_role_docker_cpu_quota

# Type: int
sqlitebrowser_role_docker_cpu_quota:

sqlitebrowser_role_docker_cpu_shares

# Type: int
sqlitebrowser_role_docker_cpu_shares:

sqlitebrowser_role_docker_cpus

# Type: string
sqlitebrowser_role_docker_cpus:

sqlitebrowser_role_docker_cpuset_cpus

# Type: string
sqlitebrowser_role_docker_cpuset_cpus:

sqlitebrowser_role_docker_cpuset_mems

# Type: string
sqlitebrowser_role_docker_cpuset_mems:

sqlitebrowser_role_docker_kernel_memory

# Type: string
sqlitebrowser_role_docker_kernel_memory:

sqlitebrowser_role_docker_memory

# Type: string
sqlitebrowser_role_docker_memory:

sqlitebrowser_role_docker_memory_reservation

# Type: string
sqlitebrowser_role_docker_memory_reservation:

sqlitebrowser_role_docker_memory_swap

# Type: string
sqlitebrowser_role_docker_memory_swap:

sqlitebrowser_role_docker_memory_swappiness

# Type: int
sqlitebrowser_role_docker_memory_swappiness:

sqlitebrowser_role_docker_shm_size

# Type: string
sqlitebrowser_role_docker_shm_size:

Security & Devices

sqlitebrowser_role_docker_cap_drop

# Type: list
sqlitebrowser_role_docker_cap_drop:

sqlitebrowser_role_docker_cgroupns_mode

# Type: string
sqlitebrowser_role_docker_cgroupns_mode:

sqlitebrowser_role_docker_device_cgroup_rules

# Type: list
sqlitebrowser_role_docker_device_cgroup_rules:

sqlitebrowser_role_docker_device_read_bps

# Type: list
sqlitebrowser_role_docker_device_read_bps:

sqlitebrowser_role_docker_device_read_iops

# Type: list
sqlitebrowser_role_docker_device_read_iops:

sqlitebrowser_role_docker_device_requests

# Type: list
sqlitebrowser_role_docker_device_requests:

sqlitebrowser_role_docker_device_write_bps

# Type: list
sqlitebrowser_role_docker_device_write_bps:

sqlitebrowser_role_docker_device_write_iops

# Type: list
sqlitebrowser_role_docker_device_write_iops:

sqlitebrowser_role_docker_devices

# Type: list
sqlitebrowser_role_docker_devices:

sqlitebrowser_role_docker_devices_default

# Type: string
sqlitebrowser_role_docker_devices_default:

sqlitebrowser_role_docker_groups

# Type: list
sqlitebrowser_role_docker_groups:

sqlitebrowser_role_docker_privileged

# Type: bool (true/false)
sqlitebrowser_role_docker_privileged:

sqlitebrowser_role_docker_security_opts

# Type: list
sqlitebrowser_role_docker_security_opts:

sqlitebrowser_role_docker_user

# Type: string
sqlitebrowser_role_docker_user:

sqlitebrowser_role_docker_userns_mode

# Type: string
sqlitebrowser_role_docker_userns_mode:

Networking

sqlitebrowser_role_docker_dns_opts

# Type: list
sqlitebrowser_role_docker_dns_opts:

sqlitebrowser_role_docker_dns_search_domains

# Type: list
sqlitebrowser_role_docker_dns_search_domains:

sqlitebrowser_role_docker_dns_servers

# Type: list
sqlitebrowser_role_docker_dns_servers:

sqlitebrowser_role_docker_domainname

# Type: string
sqlitebrowser_role_docker_domainname:

sqlitebrowser_role_docker_exposed_ports

# Type: list
sqlitebrowser_role_docker_exposed_ports:

sqlitebrowser_role_docker_hosts

# Type: dict
sqlitebrowser_role_docker_hosts:

sqlitebrowser_role_docker_hosts_use_common

# Type: bool (true/false)
sqlitebrowser_role_docker_hosts_use_common:

sqlitebrowser_role_docker_ipc_mode

# Type: string
sqlitebrowser_role_docker_ipc_mode:

sqlitebrowser_role_docker_links

# Type: list
sqlitebrowser_role_docker_links:

sqlitebrowser_role_docker_network_mode

# Type: string
sqlitebrowser_role_docker_network_mode:

sqlitebrowser_role_docker_pid_mode

# Type: string
sqlitebrowser_role_docker_pid_mode:

sqlitebrowser_role_docker_ports

# Type: list
sqlitebrowser_role_docker_ports:

sqlitebrowser_role_docker_uts

# Type: string
sqlitebrowser_role_docker_uts:

Storage

sqlitebrowser_role_docker_keep_volumes

# Type: bool (true/false)
sqlitebrowser_role_docker_keep_volumes:

sqlitebrowser_role_docker_mounts

# Type: list
sqlitebrowser_role_docker_mounts:

sqlitebrowser_role_docker_storage_opts

# Type: dict
sqlitebrowser_role_docker_storage_opts:

sqlitebrowser_role_docker_tmpfs

# Type: list
sqlitebrowser_role_docker_tmpfs:

sqlitebrowser_role_docker_volume_driver

# Type: string
sqlitebrowser_role_docker_volume_driver:

sqlitebrowser_role_docker_volumes_from

# Type: list
sqlitebrowser_role_docker_volumes_from:

sqlitebrowser_role_docker_volumes_global

# Type: bool (true/false)
sqlitebrowser_role_docker_volumes_global:

sqlitebrowser_role_docker_working_dir

# Type: string
sqlitebrowser_role_docker_working_dir:

Monitoring & Lifecycle

sqlitebrowser_role_docker_auto_remove

# Type: bool (true/false)
sqlitebrowser_role_docker_auto_remove:

sqlitebrowser_role_docker_cleanup

# Type: bool (true/false)
sqlitebrowser_role_docker_cleanup:

sqlitebrowser_role_docker_force_kill

# Type: string
sqlitebrowser_role_docker_force_kill:

sqlitebrowser_role_docker_healthcheck

# Type: dict
sqlitebrowser_role_docker_healthcheck:

sqlitebrowser_role_docker_healthy_wait_timeout

# Type: int
sqlitebrowser_role_docker_healthy_wait_timeout:

sqlitebrowser_role_docker_init

# Type: bool (true/false)
sqlitebrowser_role_docker_init:

sqlitebrowser_role_docker_kill_signal

# Type: string
sqlitebrowser_role_docker_kill_signal:

sqlitebrowser_role_docker_log_driver

# Type: string
sqlitebrowser_role_docker_log_driver:

sqlitebrowser_role_docker_log_options

# Type: dict
sqlitebrowser_role_docker_log_options:

sqlitebrowser_role_docker_oom_killer

# Type: bool (true/false)
sqlitebrowser_role_docker_oom_killer:

sqlitebrowser_role_docker_oom_score_adj

# Type: int
sqlitebrowser_role_docker_oom_score_adj:

sqlitebrowser_role_docker_output_logs

# Type: bool (true/false)
sqlitebrowser_role_docker_output_logs:

sqlitebrowser_role_docker_paused

# Type: bool (true/false)
sqlitebrowser_role_docker_paused:

sqlitebrowser_role_docker_recreate

# Type: bool (true/false)
sqlitebrowser_role_docker_recreate:

sqlitebrowser_role_docker_restart_retries

# Type: int
sqlitebrowser_role_docker_restart_retries:

sqlitebrowser_role_docker_stop_timeout

# Type: int
sqlitebrowser_role_docker_stop_timeout:

Other Options

sqlitebrowser_role_docker_capabilities

# Type: list
sqlitebrowser_role_docker_capabilities:

sqlitebrowser_role_docker_cgroup_parent

# Type: string
sqlitebrowser_role_docker_cgroup_parent:

sqlitebrowser_role_docker_commands

# Type: list
sqlitebrowser_role_docker_commands:

sqlitebrowser_role_docker_create_timeout

# Type: int
sqlitebrowser_role_docker_create_timeout:

sqlitebrowser_role_docker_entrypoint

# Type: string
sqlitebrowser_role_docker_entrypoint:

sqlitebrowser_role_docker_env_file

# Type: string
sqlitebrowser_role_docker_env_file:

sqlitebrowser_role_docker_labels

# Type: dict
sqlitebrowser_role_docker_labels:

sqlitebrowser_role_docker_labels_use_common

# Type: bool (true/false)
sqlitebrowser_role_docker_labels_use_common:

sqlitebrowser_role_docker_read_only

# Type: bool (true/false)
sqlitebrowser_role_docker_read_only:

sqlitebrowser_role_docker_runtime

# Type: string
sqlitebrowser_role_docker_runtime:

sqlitebrowser_role_docker_sysctls

# Type: list
sqlitebrowser_role_docker_sysctls:

sqlitebrowser_role_docker_ulimits

# Type: list
sqlitebrowser_role_docker_ulimits:

sqlitebrowser_role_autoheal_enabled

# Enable or disable Autoheal monitoring for the container created when deploying
# Type: bool (true/false)
sqlitebrowser_role_autoheal_enabled: true

sqlitebrowser_role_depends_on

# List of container dependencies that must be running before the container start
# Type: string
sqlitebrowser_role_depends_on: ""

sqlitebrowser_role_depends_on_delay

# Delay in seconds before starting the container after dependencies are ready
# Type: string (quoted number)
sqlitebrowser_role_depends_on_delay: "0"

sqlitebrowser_role_depends_on_healthchecks

# Enable healthcheck waiting for container dependencies
# Type: string ("true"/"false")
sqlitebrowser_role_depends_on_healthchecks:

sqlitebrowser_role_diun_enabled

# Enable or disable Diun update notifications for the container created when deploying
# Type: bool (true/false)
sqlitebrowser_role_diun_enabled: true

sqlitebrowser_role_dns_enabled

# Enable or disable automatic DNS record creation for the container
# Type: bool (true/false)
sqlitebrowser_role_dns_enabled: true

sqlitebrowser_role_docker_controller

# Enable or disable Saltbox Docker Controller management for the container
# Type: bool (true/false)
sqlitebrowser_role_docker_controller: true

sqlitebrowser_role_docker_image_repo

# Type: string
sqlitebrowser_role_docker_image_repo:

sqlitebrowser_role_docker_image_tag

# Type: string
sqlitebrowser_role_docker_image_tag:

sqlitebrowser_role_docker_volumes_download

# Type: bool (true/false)
sqlitebrowser_role_docker_volumes_download:

sqlitebrowser_role_paths_location

# Type: string
sqlitebrowser_role_paths_location:

sqlitebrowser_role_themepark_addons

# Type: string
sqlitebrowser_role_themepark_addons:

sqlitebrowser_role_themepark_app

# Type: string
sqlitebrowser_role_themepark_app:

sqlitebrowser_role_themepark_theme

# Type: string
sqlitebrowser_role_themepark_theme:

sqlitebrowser_role_traefik_api_endpoint

# Type: dict/omit
sqlitebrowser_role_traefik_api_endpoint:

sqlitebrowser_role_traefik_api_middleware

# Type: string
sqlitebrowser_role_traefik_api_middleware:

sqlitebrowser_role_traefik_api_middleware_http

# Type: string
sqlitebrowser_role_traefik_api_middleware_http:

sqlitebrowser_role_traefik_autodetect_enabled

# Enable Traefik autodetect middleware for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_autodetect_enabled: false

sqlitebrowser_role_traefik_certresolver

# Type: string
sqlitebrowser_role_traefik_certresolver:

sqlitebrowser_role_traefik_crowdsec_enabled

# Enable CrowdSec middleware for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_crowdsec_enabled: false

sqlitebrowser_role_traefik_error_pages_enabled

# Enable custom error pages middleware for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_error_pages_enabled: false

sqlitebrowser_role_traefik_gzip_enabled

# Enable gzip compression middleware for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_gzip_enabled: false

sqlitebrowser_role_traefik_middleware_http

# Type: string
sqlitebrowser_role_traefik_middleware_http:

sqlitebrowser_role_traefik_middleware_http_api_insecure

# Type: bool (true/false)
sqlitebrowser_role_traefik_middleware_http_api_insecure:

sqlitebrowser_role_traefik_middleware_http_insecure

# Type: bool (true/false)
sqlitebrowser_role_traefik_middleware_http_insecure:

sqlitebrowser_role_traefik_priority

# Type: string
sqlitebrowser_role_traefik_priority:

sqlitebrowser_role_traefik_robot_enabled

# Enable robots.txt middleware for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_robot_enabled: true

sqlitebrowser_role_traefik_tailscale_enabled

# Enable Tailscale-specific Traefik configuration for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_tailscale_enabled: false

sqlitebrowser_role_traefik_wildcard_enabled

# Enable wildcard certificate for the container
# Type: bool (true/false)
sqlitebrowser_role_traefik_wildcard_enabled: true

sqlitebrowser_role_web_domain

# Type: string
sqlitebrowser_role_web_domain:

sqlitebrowser_role_web_fqdn_override

# Override the Traefik fully qualified domain name (FQDN) for the container
# Type: list
sqlitebrowser_role_web_fqdn_override:

Example Override

sqlitebrowser_role_web_fqdn_override:
  - "{{ traefik_host }}"
  - "sqlitebrowser2.{{ user.domain }}"
  - "sqlitebrowser.otherdomain.tld"

Note: Include {{ traefik_host }} to preserve the default FQDN alongside your custom entries

sqlitebrowser_role_web_host_override

# Override the Traefik web host configuration for the container
# Type: string
sqlitebrowser_role_web_host_override:

Example Override

sqlitebrowser_role_web_host_override: "Host(`{{ traefik_host }}`) || Host(`{{ 'sqlitebrowser2.' + user.domain }}`)"

Note: Use {{ traefik_host }} to include the default host configuration in your custom rule

sqlitebrowser_role_web_http_port

# Type: string (quoted number)
sqlitebrowser_role_web_http_port:

sqlitebrowser_role_web_http_scheme

# Type: string ("http"/"https")
sqlitebrowser_role_web_http_scheme:

sqlitebrowser_role_web_http_serverstransport

# Type: dict/omit
sqlitebrowser_role_web_http_serverstransport:

sqlitebrowser_role_web_scheme

# URL scheme to use for web access to the container
# Type: string ("http"/"https")
sqlitebrowser_role_web_scheme:

sqlitebrowser_role_web_serverstransport

# Type: dict/omit
sqlitebrowser_role_web_serverstransport:

sqlitebrowser_role_web_subdomain

# Type: string
sqlitebrowser_role_web_subdomain: