We've just discovered this in the Softwire office, and it looks like a huge step up on the existing other tools, especially Microsoft's SQL management studio and MySQL workbench.
Some choice quotes:
> Awesome handling of multiple queries. MySqlWorkbench forces one query at a time which can be annoying but is nowhere near as bad as SSMS which insists you highlight any individual query you want to run or it will run the whole file.
> Nicely displaying multiple tables. MySqlWorkbench just doesn't, and SSMS insists on putting them on top of each other which is really ugly. DataGrip is lovely, it just gives multiple tabs at the bottom with each separate table on.
> My favourite 'wow' feature is the ability to select some or all of a results grid (arbitrary rows * arbitrary columns), and copy and paste that data as JSON (or various other, configurable text formats).
> Using it within IntelliJ means that you can use Intellij's language injection feature, and get SQL autocompletion/checking/navigation etc. from context appropriate strings in other languages which is very neat.
The only time I don't use DataGrip is when I need to some some user management on PostgreSQL. Then I fire PgAdmin. Otherwise, DataGrip became my main SQL tool. I love it.
Replies
HTTP Toolkit
Screensaver Ninja