jotools/cubesql-webadmin repository overview

⁠cubeSQL Web Admin

A web based Administration Tool for cubeSQL⁠ (© sqlabs).

⁠cubeSQL

cubeSQL (© sqlabs) is a fully featured and high performance relational database management system built on top of the sqlite database engine.

Website: https://www.sqlabs.com/cubesql⁠

⁠Docker Image Information

Use at your own risk...

• cubeSQL Web Admin
  • written in Xojo⁠
  • Source Code⁠
• Port: 80

Notes:

• you can't connect to cubeSQL via localhost in a Docker Container
• connect using a hostname, or via host.docker.internal

⁠Configuration

⁠Web Application

• --Port | CUBESQL_WEBADMIN_PORT

⁠Prefill Login data:

• --CubeSQLHostname | CUBESQL_HOSTNAME
• --CubeSQLPort | CUBESQL_PORT
• --CubeSQLEncryption | CUBESQL_ENCRYPTION with values: NONE, AES128, AES128, SSL
  For Encryption type SSL:
  • --CubeSQLSSLCertificate | CUBESQL_SSL_CERTIFICATE
    with value: /path/to/file
  • --CubeSQLSSLCertificatePassword | CUBESQL_SSL_CERTIFICATEPASSWORD
    with value: /path/to/file.txt | plain text
  • --CubeSQLSSLRootCertificate | CUBESQL_SSL_ROOTCERTIFICATE
    with value: /path/to/file
  • --CubeSQLSSLCipherList | CUBESQL_SSL_CIPHERLIST
    with value: /path/to/file.txt | plain text
• --CubeSQLUsername | CUBESQL_USERNAME
  Only if Username is prefilled:
  • --CubeSQLPassword | CUBESQL_PASSWORD

⁠Docker Compose

The following Docker Compose setups are combining cubeSQL Server⁠ and cubeSQL Web Admin⁠:

• using Volumes
  local-cubesql-volumes⁠
• using Bind Mounts
  local-cubesql-bind-mounts⁠