{"id":4208,"date":"2011-09-16T16:51:00","date_gmt":"2011-09-16T11:21:00","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=4208"},"modified":"2016-12-19T15:16:39","modified_gmt":"2016-12-19T09:46:39","slug":"fast-db-management-through-idea-increase-productivity","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/fast-db-management-through-idea-increase-productivity\/","title":{"rendered":"Fast DB Management Through IDEA- Increase Productivity"},"content":{"rendered":"

Hi,<\/p>\n

well we can run SQL Queries and browse database through IDEA with a good GUI interface.<\/p>\n

It Just Requires Two Steps:
\n1) Setup (One time)
\n2)Usage (how to)<\/p>\n

\n

A: Setup<\/h1>\n
\n

PART I<\/strong>
\n1) Download the Database Navigator Tool From Intellij Repo -> Download Tool<\/strong>
\n2) Then Execute in the Directory containing the downloaded file<\/p>\n

[bash]unzip DBN_9912.zip; cp -rfvp DBNavigator \/opt\/idea\/plugins\/[\/bash]<\/p>\n

assuming “\/opt\/idea” is the idea installation directory, Feel free to change this as required. \ud83d\ude42
\n3) Restart IDEA
\nPART II<\/strong>
\n4) Now in your IDEA Left Dock Bar You will see the DB Browser Tab<\/strong>(As shown in the image below)
\n\"\"<\/a>
\n5) Click On That Tab
\n6) Now in DBNavigator window click on Settings Button<\/strong>(The Last Button on the tools menu)
\n7) On Connections Tab, Click on the “+” button to add the connection. Do the settings(One Time Step)<\/strong>, Sample settings is shown below:
\n\"\"<\/a><\/p>\n

ALL DONE \ud83d\ude42<\/strong><\/p>\n

\n

B: USAGE<\/h1>\n
\n

Using is very simple,
\nYou can RUN SQL Queries with Auto-complete(hav’t tried this yet though).. \ud83d\ude1b
\nSee Database Schema and Content Inside Idea through a very Intiutive Interface. \ud83d\ude42<\/p>\n

Here are the Screenshots for what all you can do:<\/p>\n

\"\"<\/a>
\n
\n\"\"
\n
\n\"\"
\n
\n\"\"
\n
\n\"\"
\n
\n\"\"
\n
\nMore Screen shots:
\n\n\t\t