If you are mostly working with Postgres database programming, this tool for you.
ZPG an experimental side project written with NodeJS and Webix (GPL license), inspired by Jenkins and PgAdmin add some features to make it simple and easy. For more other functionality of Postgres please use PgAdmin
Features idea:
- Easy to navigate
- Task SQL continues integration
- Comparing between SQL function direct correction
- Simple query editor
- Copy content between database
- Easy view table content
- Generator
- and more..
Docs here (currently on progress)
Try to Quick Start
- Node
- Postgres version 9.6 or above
Download here and install
wget https://github.com/finzaiko/zpg/releases/download/0.0.21-dev/zpg_0.0.21-dev_amd64.deb
sudo dpkg -i zpg_0.0.21-dev_amd64.debwget https://github.com/finzaiko/zpg/releases/download/0.0.21-dev/zpg-0.0.21-dev.x86_64.rpm
sudo yum localinstall zpg-0.0.21-dev.x86_64.rpm
or
sudo rpm -i zpg-0.0.21-dev.x86_64.rpmwget https://github.com/finzaiko/zpg/releases/download/0.0.21-dev/ZPG-0.0.21-dev.AppImage
chmod a+x ZPG-0.0.21-dev.AppImage
./ZPG-0.0.21-dev.AppImageDownload and double clickdocker run --rm --name zpg -p 9001:9000 -d -e "API_SERVER=http://localhost:9001" finzaiko/zpg:1.0
open in browser: http://localhost:9001
git clone https://github.com/finzaiko/zpg.git
make install
Manual npm install
npm install
cd backend && npm install
cd frontend && npm install
cd backend && cp .env.example .env
npm run dev
or
make start-dev-server
or try desktop
make start-dev-desktop
http://localhost:8000
username: admin
password: admin123
-
Create Server connection
-
Add DB Connection
This is an experiment personal project, found some bug and under development, you can submit the issue.
Query
# Increase JS heap momory to 4GB
pm2 start zpg/backend/index.js --node-args="--max-old-space-size=4096" --name "zpg"
pm2 save
pm2 startup
<Copy paste script result and run again>
Try ZPG for mobile (Android) 👉 ZPG Postgres