A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.
Visit project page at http://rickbergfalk.github.io/sqlpad/.
Using docker
# To build initial image (and force rebuild)
docker-compose build --no-cache web
docker-compose create --force-recreate web
# Start sqlpad in dev mode and bring dockerized db's up
docker-compose up
# To bring down
docker-compose down
# To remove dangling containers volumes etc
docker system prune
Locally
- Clone/download repo
- Install node 6 or later
- Install npm5
- run
npm start
from command line
Once Running At this point you should have both backend and front-end development servers running.
http://localhost:3000 serves react front-end in dev-mode http://localhost:3010 serves front-end compiled for production
Both front-end/back-end should auto-refresh/auto-reload on file change.
To build front-end production files run npm run build
.
See wiki for additional development details and project information.
If you have highlighted just part of your query, only that part will be executed when you click Run Query.
MIT