DataGrip is a multi-engine database environment. It supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. It includes an editor that provides intelligent coding assistance for editing SQL code and features auto-completion, analysis and navigation. It also comes with a query console for running and profiling queries.
Updates in 2016.1
Connectivity
- Copy Passwords with SSH Settings - You can now copy a password along with all other SSH settings between data sources.
- Custom URL Support - If you’re using a DBMS that DataGrip doesn't’t directly support, you'll be prompted to create a custom JDBC URL template that will be used to extract information (like login or address) from that URL.
- Port Number Auto Corrections - New SQL Server connection inspections will inform you if you have specified an incorrect port number.
- Completion for Instance and Databases - In the General tab, for SQL Server data sources there is now a completion for hosts, instances and databases.
- Better Error Handling - DataGrip has improved the way MySQL tells you about connection errors, so you will get more details on what went wrong.
Editor
- Qualify and Unqualify Identifier - A new pair of intention actions, Qualify and Unqualify identifier, are accessible from the Alt+Enter menu.
- Structure View Enhancements - Structure View will now be able to display the common table expressions, and will no longer shorten longer names in an unpredictable way.
- Right-to-left Language Support - Selection and caret now fully support RTL languages like Arabic or Hebrew.
IDE Features
- File Scopes - DataGrip now supports file scopes that simplify various operations (like code analysis) by grouping files based on multiple criteria such as path or name.
- By-word Difference Highlighting - DataGrip adds by-word difference highlighting in the diff viewer so now it's easier to see the difference between the two files you're comparing.
PostgreSQL Support
- Better Grammar Support - Several PostgreSQL features including WITHIN GROUP and window functions for custom aggregates are now properly highlighted and available for completion.
- Completion for Table Functions - Table functions are now properly highlighted and available for completion. Plus, automatic aliases can now be used for qualification in the SQL editor.
- Function in Indexes Support - Added support for functions in indexes so you can now navigate to them from the database view or from an index DDL.
Other Improvements
- Oracle 12 grammar support.
- Move XML elements left or right with the Alt+Ctrl/Cmd+Shift+Arrow keys.
- Objects that are not introspected now can be resolved to a DDL statement if there is a match.
- Press Ctrl/Cmd+F to search for text in the Terminal plugin.
- Remote Hosts Access plugin is now available for installation.
- Perforce plugin is now available for installation.
About JetBrains
JetBrains is a leading software development firm specializing in the creation of intelligent, productivity-enhancing software technology. The company is widely known for their innovative, award-winning products, IntelliJ IDEA, ReSharper and TeamCity. JetBrains' products are trusted and used every day by developers in over 3,000 companies worldwide, many from the Fortune 100. JetBrains has headquarters in Prague, Czech Republic and R&D centers in Russia, Germany and the USA.
