Create custom Eclipse

 

Download Platform Runtime Binary

Choose Eclipse Releaes for add plugin

Choose 

Eclipse Java Developments Tools

Javadocs Help Feature

Javascript Development Tool

Wild Web Developer

m2e - Maven Integration for Eclipse

Add useful update sites

https://www.genuitec.com/updates/devstyle/ci/

(tickDevStyle Features)

 http://eclipse.sonarlint.org

(tick SonarLint for Eclipse, SonarLint for Eclipse Developer Resources,  SonarLint for Eclipse Source Code)

https://dbeaver.io/update/latest/ 

https://github.eclipsesource.com/jshint-eclipse/updates/

https://ecd-plugin.github.io/update

Install Nodeclipse, Wild Web Developer,

Open .js files with Nodelipse-JSDT

Create readonly user in Postgres

CREATE USER testuser WITH PASSWORD 'somepassword';
GRANT CONNECT ON DATABASE dbtest TO testuser;

//remove all permission, only superuser can perform db actions
REVOKE ALL ON schema public FROM public;
//remove all table permission from user
REVOKE ALL ON ALL TABLES IN SCHEMA public FROM testuser;
//grant select permission to user
GRANT SELECT ON ALL TABLES IN SCHEMA public TO testuser;