IntelliJ IDEA 11: New and Noteworthy in Database Realm
There are many little things in database and SQL area that got attention in yesterday’s IntelliJ IDEA 11 release but now I just want to highlight the major ones.
Data Sources view got a new look and now includes stored procedures both from DDL scripts and real databases. The existing SQL dialects support has been redesigned with two new dialects introduced: H2 and MS Transact-SQL. So the list of supported SQL languages now looks like this:
- Includes stored procedures. Search for usages, navigate to, drag and drop to editor, etc.
- Working with large databases is now less painful. Tables and procedures are available the moment their names are loaded. Columns, procedure parameters and other information are loaded in background afterwards.
- If something is changed there’s no need to wait for the whole synchronization. Refresh only selected schemas, tables or procedures.
- Console now remembers its state so you won’t lose statements you have never run.
- If you do not want to switch editors back and forth you can run statements directly from an SQL file or any other place where SQL injection takes place: invoke “Run Query in Console” intention for the first time then use console “Execute” action shortcut as if you are in console.
- Transact-SQL batch execution mode (the toggle is hidden in the console properties dialog)
- Console editor now can be undocked and split as any other editor.
Subscribe to Blog updates
Thanks, we've got you!
The What, Why, and How of JPA Buddy in IntelliJ IDEA
Master JPA entity management with JPA Buddy in IntelliJ IDEA! Our latest article shows you how to simplify your workflow and reduce boilerplate code.
The Best of IntelliJ IDEA’s HTTP Client
In today's fast-paced tech world, easy and efficient management of web services and APIs is crucial. That's where IntelliJ IDEA's HTTP Client steps in, turning complex HTTP requests into a walk in the park. The HTTP Client is a feature-rich, text-based tool in IntelliJ IDEA Ultimate. It seamlessl…
Import Postman Collections to the HTTP Client
We know that many of you use Postman collections and want to stay in the flow while working with them. This means staying inside IntelliJ IDEA and not switching to a different app. Great news! You can now effortlessly transform Postman collections into .http and use them in the HTTP Client …
What’s New in IntelliJ IDEA 2023.1 for Spring Developers
The IntelliJ IDEA 2023.1 release came packed with updates for Spring. This blog post will highlight the most noticeable changes, including full support for Lombok, a reworked Spring tool window, navigation for Spring Security rules, Spring Security 6 support, and more. Remember that these featur…