SQLPage

SQL-only web app builder that turns database queries into interactive UIs.

Access

  • Open in browser: http://<SERVER_IP>:8080 (HTTP)

Important Files and Directories

  • Install directory: /root/sqlpage
  • Site directory: /root/sqlpage/source
  • Main page: /root/sqlpage/source/index.sql
  • Environment file: /root/sqlpage/.env
  • Docker Compose file: /root/sqlpage/docker-compose.yml
  • PostgreSQL volume: /var/lib/docker/volumes/sqlpage_postgres_data/_data

Website Files

  • Your SQLPage site files are stored in: /root/sqlpage/source
  • Main example page: /root/sqlpage/source/index.sql
  • Edit the file and refresh the browser to see changes.

Docker Management

Go to install directory:

cd /root/sqlpage

Start services:

docker compose up -d

Stop services:

docker compose down

View status:

docker compose ps

View logs:

docker compose logs -f

Restart services:

docker compose restart

Application Details