Released: Jun 27th, 2017
Mac Platform: Intel
OS Version: OS X 10.8 or later
Web Site: http://www.jetbrains.com/
Manage multiple types of databases with this intuitive IDE that makes it easy to write SQL code and offers a wide range of useful features
DataGrip is a versatile application that caters to the needs of database administrators and SQL developers, supports a broad range of data sources and offers numerous helpful tools that can speed up your workflow.
Powerful tool that supports multiple types of databases and provides automatic code completion
DataGrip is a multi-engine database environment that enables you to connect to various data sources, such as MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Sybase, SQLite and DB2. Essentially, if the database management system uses JDBC, it is supported by DataGrip.
As you would expect from a database IDE, DataGrip offers context-sensitive code completion, which can significantly reduce the time it takes to write SQL code. This function takes multiple factors into account, such as table structure and foreign keys.
Of course, it is impossible to avoid mistakes altogether, but this utility can help you out by detecting errors while you are writing code and offering suggestions for dealing with them.
Easy-to-use query console and smart variable refactoring
Renaming a variable in your database can cause a lot of headaches, as any references made to it become invalid. However, DataGrip enables you to quickly refactor them and update the variable’s usage in the entire file.
DataGrip also allows you to execute queries with very little effort and keep track of your work with the help of a handy history log.
Sleek, modern interface and fully customizable keyboard shortcuts
DataGrip offers a well-designed interface that can be personalized in numerous ways. You can display or hide various toolbars or menus, and you have complete control over their layout.
Additionally, the application lets you choose from multiple color schemes, and you can enable the Distraction Free mode when all you need to do is write code.
Most of the app's functions can be controlled with hotkeys, and they are fully customizable. You can either select one of the existing profiles or create an entirely new one.
Overall, DataGrip is a comprehensive database IDE for administrators and SQL developers. It is packed with useful features, offers a well-designed, modern interface and is very intuitive.
What's New in Version 2017.1.5:
Most important fixes:
• DBE-2771 — Important fix with “column reference is ambiguous” for Postgres EDB users.
• DBE-4753 — “Invalidate Caches/Restart” is enabled in the Find action menu.
• DBE-4733 — Empty rows are removed from the console output tab.