IntelliJ IDEA 13: What’s New in Database Tools
We hope you had enough time during the holidays to play with IntelliJ IDEA 13 and now want to try something new, like Database Tools, which has been so greatly improved in version 13 that you can now ditch your third party database client and perform all database operations right from IntelliJ IDEA (and it doesn’t matter what server you are using, you get the same user experience with all of them.)
Data Source Configuration
The data source configuration is no more a nightmare, thanks to the new Data Source and Drivers dialog. Just type a host, port, credentials and IntelliJ IDEA will take care of the rest, including downloading the driver and composing the JDBC URL.
Find Usages by a Primary Key
Another amazing new feature you’ll hardly find in any database client is Find Usages for a table row. This action helps you find all other rows referencing the current one via it’s primary key. Now you don’t need to write a query to find out, for example, which orders have been made by a certain customer, you just call Find Usages via Alt+F7 and that’s it.
Show Data by a Foreign Key
If you’d like to see the referenced data behind a foreign key (without leaving the table), just press Ctrl+Q (Ctrl+J for Mac) while a foreign key is selected, and IntelliJ IDEA will show you the data in a quick popup.
If you press the shortcut twice, you’ll get a popup with the Transposed view of the row.
Needless to say that navigation from a foreign key to referenced data works via Ctrl+B (Cmd+B for Mac).
Structure Popup and Tool Window
Every IntelliJ IDEA user knows how the Structure popup via Ctrl+F12 (Cmd+F12 for Mac) is useful when navigating in a file or class structure. Now you can use it in the table editor and result views as well to navigate between columns. Additionally, you can toggle column visibility (press Space), or even change their order via Shift+Alt+Up/Down (reset order with Alt+Shift+Ctrl+Backspace, Alt+Shift+Cmd+Backspace for Mac).
The same functionality is also available in the Structure tool window.
Note that the Structure popup (and tool window, too) let you navigate through an SQL file structure.
Query Filter and Sorting
User interface for query filter and results sorting has also been improved, and you can click column headers to sort data either locally or on the server side.
Other major improvements include:
- Current SQL statement highlighting in the editor
- Smart code completion for JOIN statements
- Assigning colors to databases
- Configuring H2 and SQLite data sources by drag and drop
As always you are welcome to share your feedback or submit bug reports to the issue tracker.
Stay tuned to our blog for more news.
Develop with Pleasure!
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…