Categories
MySQL

MySQL 8 : About GRANT / PRIVILEGES

In previous version of MySQL (before v8), we can grant/create mysql user one and grant it at once to get access by each host (location / 127.0.0.1) base on your mysql config. In MySQL 8, you no longer can (implicitly) create a user using the GRANT command. You need to do by CREATE USER and…

Categories
Java

Solving the recursive Json data generation in Java Spring

Let me presume a quick remark or note on the use of jsonManagedReference, jsonBackReference or JsonIdentityInfo annotation when you will manage to display json data from the entity while working on Spring 3 and Jackson. The work likely in case you need to exchange the data via Json such as developing application with AngularJS and…

Categories
PostgreSQL

A recommandation or a Free GUI Tool for ER Diagram for PostgreSQL

pgAdmin3 which is coming by default when we install PostgreSQL but there is no GUI data modeling. Found from following list, there are some GUI tool but don’t know which one should be taking into account. – http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools – http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools Is there any recommended tool for GUI database modeling with ER Diagram like we have…