Database Tools

We’ve recently announced the opening of the EAP for IntelliJ IDEA 2017.3, and we have already even looked at some of the interesting EAP features. However, we didn’t cover changes in the database tools yet. So let’s explore the major changes in this area. Selecting schema when running SQL file IntelliJ IDEA 2017.3 now prompts you to choose database/schema along with a datasource when you try to run an SQL file from the Project tool window: (more…)

If you’re following our recent news, you already know that last week we released the new massive IntelliJ IDEA update, 2017.2. However, we didn’t mention its database tools much in the release announcement, so now it’s time to catch up on that, because there’s plenty of new features in that area. Amazon Redshift and Microsoft Azure These cloud database providers are now supported out of the box with dedicated drivers and their specific SQL syntaxes. If you’re already using any of them via the standard SQL Server or PostgreSQL drivers, make sure that you migrate to the new dedicate

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 tak

As you know, IntelliJ IDEA provides built-in database tools with support for many SQL dialects, such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server and others. A while ago we shared this video with a quick overview of how to set up a connection to a database, use smart completion (even for SQL queries within Java), on-the-fly code analysis, navigation (between queries and database), search (for tables and fields), and more cool features. Now, please enjoy a new video with even more exciting features available in IntelliJ IDEA 12 for working with databases: (more…)

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: MySQL 5.6 PostgreSQL 9.0.5 Oracle 11.2 SQLite 3.7 SQL Server 10.50 Derby 10.8 HSQLDB 2.2 H2 1.3 SQL-92    Featuring: Exa

We at JetBrains know how important it is to track what has been changed in your project from one version or revision to another. This is why IntelliJ IDEA 10.5 brings you new Diff Tools for comparing local directories, DB objects (Data Sources, Schemes, Tables). In later updates we're planning on including even remote to local files comparison as well. Diff Tools are available via Ctrl+D, or from context menu, wherever you may need them. Say, to compare two Data Sources (or Tables, or Schemes, come to that), all you need is select them in Data Sources tool window, and then invoke the Compare a

IntelliJ IDEA X features a simple database table editor and viewer. You can add and remove rows, sort by specific column and choose columns to display just by pressing F4 on a table in the Data Sources view. If you find the console-like way better than the GUI way, you can still run all those delete from... and insert into... statements in the Database console. Try this in the latest IntelliJ IDEA 10 EAP and let us know your thoughts on it.

In IntelliJ IDEA 10 a new JPA Console is added to existing Hibernate and Database consoles. Now you can run and test your JPA queries in a target environment of your application. Both Hibernate and JPA consoles are available if applicable. Note the new "Run Query in Console" Intention Action that is now available on all the supported types of queries: JPA QL, Hibernate QL and SQL. It allows you to quickly run a query directly from the editor in a corresponding console either new or already running.

The latest IntelliJ IDEA 9.0.2 EAP contains a big number of Database-related functionality changes: Database Console now has its own toolwindow New console-like UI that keeps input and output in one place and retains the highlighting for execution history Keyboard shortcuts for all Console actions are now configurable Per-result Page Up, Page Down and Refresh actions Complete support for In-Memory Databases (try running some DDL in Console then click Refresh Tables and all the tables will be loaded in the Data Sources tree) Improved support for heavy JDBC drivers that use native librari

Since IntelliJ IDEA 9.0.2 Database Diagram supports drag-and-drop for adding more tables to the view. The screenshot below shows the way to access the diagram if you somehow missed the What's New in 9.0 page. You can try this right now in the latest EAP.

Maia release is closing in, and yet we have not run out of useful features to announce. Next EAP brings you a long-awaited support of PostgreSQL dialect. Just as with all others, you can set it at project, folder, or individual file levels either via Project Settings section of Settings dialog, or by invoking a quick-fix on any error marker inside of an .sql file with Alt+Enter shortcut.

In Maia the Show Parameter Info action (Ctrl+P) is available in SQL function calls and value expressions.