More Docker. Easy Access. New Streamlined Plans. Learn more.

jotools/cubesql

By jotools

Updated 3 months ago

cubeSQL (© sqlabs) - a fully featured and high performance sqlite based server

Image
Databases & Storage

50K+

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...

  • runs cubeSQL Server
  • Volume: /data
    (containing cubesql.settings, databases, backups)
  • Port: 4430

Volume: /data

It is highly recommended to use an own volume. That allows you to use all cubesql data (settings, databases, backups, ...) with different/newer versions of Container or cubeSQL.

Docker on Synology

In order to have the data Volume easily accessible:

  1. Download the Image from Docker Hub
  2. Click on 'Start' to setup up your Container
  3. Click on 'Advanced Settings'
  4. Advanced Settings - Volume(s): Add Folder (select one on your Synology), and set it's MountPoint to: /data (make sure it's read-and-writeable)
  5. Advanced Settings - Port: Add "Local Port: 4430" for "Container Port: 4430" (cubeSQL will then be available on Port 4430 of your Synology)

Environment Variables

The default settings run cubeSQL on Port 4430.
All Data (settings, databases, backups) are located in /data.

  • CUBESQL_PORT=4430
  • ENV CUBESQL_DATA=/data
  • ENV CUBESQL_SETTINGS=$CUBESQL_DATA/cubesql.settings

Docker Compose

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

cubeSQL License/Registration

You will need to register cubeSQL.

  1. Request a Key from sqlabs
  2. Download the desktop application cubeSQL Admin or run the web based administration tool cubeSQL Web Admin(also available as Docker Image: jotools/cubesql-webadmin)
  3. Connect to cubeSQL and register your server

Docker Pull Command

docker pull jotools/cubesql