Skip to content

jo-tools/cubesql-webadmin

 
 

Repository files navigation

cubeSQL Web Admin

A web based administration for cubeSQL Serversqlabs)

License: MIT

Description

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

cubeSQL Web Admin is a web based administration tool for cubeSQL Server.

ScreenShot: Login

ScreenShot: Databases

Build from Source Code

In order to build cubeSQL Web Admin application, Xojo and the latest cubeSQL Xojo Plugin are required.

Ready to use executables and Docker Images

  1. Executables are provided with the Releases.

  2. Docker Images provided by jo-tools can be found here:
    Docker Hub: jotools/cubesql-webadmin

  3. Docker Compose setups provided by jo-tools can be found here:
    GitHub: jo-tools/docker

    • These setups contain both cubeSQL Server and cubeSQL Web Admin

Configuration

cubeSQL Web Admin supports the following launch arguments and corresponding environment variables.

Example:
Launch cubeSQLWebAdmin on Port 8080 and prefill login data to connect to a cubeSQL Server running on localhost Port 4440:
/path/to/launch/cubeSQLWebAdmin --Port=8080 --CubeSQLHostname=localhost --CubeSQLPort=4440 --CubeSQLUsername=admin --CubeSQLPassword=admin

Web Application

  • --Port | CUBESQL_WEBADMIN_PORT

Default New Connection

  • --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: plain text | /path/to/file.txt | `/output/of/a/shell/cmd`
    • --CubeSQLSSLRootCertificate | CUBESQL_SSL_ROOTCERTIFICATE
      with value: /path/to/file
    • --CubeSQLSSLCipherList | CUBESQL_SSL_CIPHERLIST
      with value: plain text | /path/to/file.txt
  • --CubeSQLUsername | CUBESQL_USERNAME
    Only if Username is prefilled:
    • --CubeSQLPassword | CUBESQL_PASSWORD
      with value: plain text | /path/to/file.txt | `/output/of/a/shell/cmd`

Connection Choice

To offer a list of connection choices they can be specified in a JSON file which contains an array of ConnectionItems.

Example: connection-choice.json

  • --CubeSQLConnectionChoice | CUBESQL_CONNECTIONCHOICE
    with value: /path/to/connection-choice.json

About

cubeSQL Web Admin has been written by Jürg Otter, who is a long term user of Xojo and working for CM Informatik AG. Their Application CMI LehrerOffice is a Xojo Design Award Winner 2018. In his leisure time Jürg provides some bits and pieces for Xojo Developers.

Releases

No releases published

Packages

No packages published

Languages

  • Xojo 97.8%
  • Shell 2.0%
  • Other 0.2%