Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Installing MySQL Server and MySQL Workbench Introduction to MySQL Server and Workbench

Posted by aroshinemunasinghe
aroshinemunasinghe
5,649 Points

SQL in IntelliJ , how to install SDK/ Plug In ect?

Hi I'm IntelliJ fan :wink: And I just wondering if someone knows how to install SQL in IntelliJ 2016.5.2 :smile:

I went to plugin and it seemed it has installed "auto" SQL When I click create project I cant find to create SQL project.. Check this youtube (maybe you understand what I mean): https://www.youtube.com/watch?v=PNuCEzd9smY How did he create a SQL file and so go on? Mine is not working

Please tell me step by step :pray:

1 Answer

Alexander Nikiforov
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points
Alexander Nikiforov
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points

First of all you need Ultimate edition of Inteliijidea.

Database tools are not available for Community edition. Take a look at intellij download page

https://www.jetbrains.com/idea/download/

Second, with which framework are you going to use SQL, you cannot just open SQL project...

For simple database stuff MySQL workbench is made.

Intellijidea helps you to use database along with some other project framework:

For example Spring/Hibernate...

If you do python project, you need to use PyCharm, and there PyCharm will help you

There also very helpful tool provided by JetBrains, which is called 'DataGrip'

https://www.jetbrains.com/datagrip/?fromMenu

This one is specifically designed to work just with SQL and databases.

So it depends very much of your purposes your other non-SQL language, and yeah it will cost you money.

P.S. I use Inteliijdea Ultimate, and very happy.

And No. I haven't use DataGrip or any other IDEs for python, c# and etc..

aroshinemunasinghe
aroshinemunasinghe
5,649 Points

thanks!! I think I found this link also http://stackoverflow.com/questions/40307706/how-to-install-sql-in-intellij-2016-2-5-how-to-create-a-project-sql-intellij

:smile: