sqliteonlinecom/soe-sqliteserver repository overview

⁠What is soe?

Soe - external module for accessing local and remote databases from SqliteOnline.com⁠

SQL Editor, any database from any device.

⁠How to use this image

docker run --name soe-sqliteserver -v /my/own/datadir:/var/lib/soe --rm -d -e SOE_DB_PASS=my_secret_pw -e SOE_DB_ROOT=1 -e SOE_ROW_LIMIT=0 -p 8081:17321 sqliteonlinecom/soe-sqliteserver

⁠Connecting to your database via SqliteOnline.com

You can check if the server settings are correct. http://localhost:8081/soe/test

Go to the SqliteOnline.com⁠ website and click the Owner DB button

• Url http://localhost:8081/soe/
• DB name sys
• Login root
• Password my_secret_pw

⁠Server configuration

Append new db file: INSERT INTO dblist (name, file) VALUES ('dbname','/var/lib/soe/dbfile.db');

Append new user: INSERT INTO users (login, password) VALUES ('new_user_name',PASSWORD('user_password')); (password: min 9 chars)

Allow user to access the database: INSERT INTO perm (login, name) VALUES ('user_name','dbname');

Allow user to access the all database: INSERT INTO perm (login, name) VALUES ('user_name','*'); (except 'sys')

⁠Using environment variables in soe configuration

• soe_path path (default: soe)
• soe_body_size limit on request length, support short: kb, mb (default: 2mb)
• soe_timeout session time limit in seconds, support short: m, h (default: 15m)
• soe_row_limit limit the number of lines, unlimited - 0 (experimental feature) (default: 100000)
• soe_login_allow allow access to the database, only users from the list, via "SOE" (example: user1,user2,user3)
• soe_login_deny block users from the list to access the database via "SOE" (example: user1,user2,user3)
• soe_db_root allow the user root to access the database through "SOE". allow - 1, deny - 0 (default: 0)
• soe_db_pass root password (min 9 chars)

⁠Using nginx configuration (from remote server)

You can check if the server settings are correct. https://youdomain/soe/test

# replace nginx_path on you path name
location /soe/ {
   gzip on;
   gzip_comp_level 9;
   gzip_types application/json;
   proxy_set_header X-Real-IP $remote_addr;
   proxy_set_header Host $host;
   proxy_pass http://127.0.0.1:8081;
   proxy_redirect off;
   proxy_buffering off;
   proxy_buffer_size 128k;
   proxy_buffers 100 128k;
   proxy_http_version 1.1;
   proxy_set_header Upgrade $http_upgrade;
   proxy_set_header Connection "upgrade";
   proxy_next_upstream error timeout http_500 http_502 http_503 http_504;
   proxy_connect_timeout 5s;
   proxy_read_timeout 30s;
   proxy_send_timeout 30s;
}

⁠License

View license information⁠ for the software contained in this image.

As with all Docker images, these likely also contain other software which may be under other licenses (such as Bash, etc from the base distribution, along with any direct or indirect dependencies of the primary software being contained).

As for any pre-built image usage, it is the image user's responsibility to ensure that any use of this image complies with any relevant licenses for all software contained within.