Questions tagged [datagrip]

JetBrains' commercial Database IDE(formerly 0xdbe). This is a cross platform database IDE that supports most relational databases.

DataGrip is a multi-engine database environment from JetBrains. It supports:

  • Oracle
  • PostgreSQL
  • AWS Redshift
  • MySQL
  • Microsoft SQL Server
  • Microsoft Azure
  • DB2
  • Sybase
  • SQLite
  • HyperSQL
  • Apache Derby
  • H2
  • Exasol

Targeting the needs of professional SQL developers, DataGrip makes working with databases an enjoyable experience.

Main features

Database objects

DataGrip introspects objects in your databases and displays them grouped in folders by schemas. It also provides a UI for adding and editing tables, columns, indexes, constraints, etc. Quick navigation brings you to any object, whether it has just been created in your code or has been read from a database.

Data editor

A powerful table editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.

Query editor

Transform and move blocks of code, use multi-cursors to manage selection, format code according to specific style. DataGrip provides context-sensitive, schema-aware code completion, helping you write code faster. Completion is aware of table structure, foreign keys, and even database objects created in the code you're editing.

Additional Features

Code Reformatting

Reformat queries with a single click through user-definable code style schemes. Formatting currently supports: SQL, JSON, HTML, XML, and CSV.

Query Templates (Live Templates)

Ability to define custom, commonly-used SQL snippets that can be generated via an alias using smart code completion (e.g. define a common set of joins to auto-generate when typing 'common' into the SQL editor).

Safe Refactor

Refactor code without worrying that your changes will break other portions of your project. DataGrip will automatically check and alert, if a refactor change has the potential to break other portions of code within your project.

Links

679 questions
0
votes
1 answer

Update PyCharm with new DataGrip

JetBrains has just released new DataGrip 2017.3 I have Professional edition of PyCharm. This includes working with databases (as I understood all the features of DataGrip). Is it possible to update my Pycharm, so that it also includes new…
Snobby
  • 1,067
  • 3
  • 18
  • 38
0
votes
1 answer

DataGrip stuck on "connecting to database..."

I try to connect to Redshift Using JetBrain DataGrip, after I fill in the datasource information (host, db, username, password etc) and try Test Connection I saw that there is a background task spawn up and prompts "Connecting to database..." and…
Ning Lin
  • 51
  • 1
  • 5
0
votes
1 answer

When opening text file as table not entire file is saved

After opening a text file larger then 2.5MB, datagrip will open the file in read-only mode. If I then edit the text file as a table and export the table with dump data to file, it will only write the first 2.5MB to file and the rest of the file will…
John Cadac
  • 89
  • 1
  • 11
0
votes
1 answer

Trying to connect to a database created in a spring boot package with intelij Datagrip

I have created a spring boot project in eclipse with a H2 embedded database and JPA. Inside my resource folder I'm using import.sql to populate the tables created in my entity package.The spring web application and database runs fine as I can check…
Super Hans
  • 128
  • 2
  • 11
0
votes
2 answers

“Error 42P01: relation does not exist” (non public schema in PostgreSQL)

I want to create a foreign key but I got Error 42P01: relation solicitantes does not exist. I have to schemas: public and laboratorio. My table is called procedencias. I want to create a foreign key to solicitantes table. Both belongs to laboratorio…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
0
votes
1 answer

False results being returned from stored procedure?

I've written a stored procedure in Microsoft SQL Server that should import results from 4Matrix and insert them into the Results table on MyPortal. It does import results, however, some of them are incorrect. Here's the code for the stored procedure…
Rowan Richards
  • 401
  • 8
  • 20
0
votes
0 answers

Datagrip simple calculation on the Select Query Result

I recently switch from Aginity for Redshift to Datagrip for accessing my redshift db. I am wondering for Datagrip is it a function to get simple calculations (like count, sum) on certain columns of the select results like the Aginity for Redshift?…
user2741956
  • 145
  • 2
  • 6
0
votes
2 answers

Cannot connect DataGrip to database hosted using XAMPP

I am currently trying to learn MySQL. I have used XAMPP to setup my database on PhpMyAdmin. suppose, host: localhost
port: 3306
database name: db1
username: user1
password: pass1
URL:…
harsh.gupta
  • 45
  • 2
  • 10
0
votes
1 answer

Invalid update SQL in DataGrip

I wrote a MySQL update SQL on my DataGrip to update the wrong data: update common_express_track set step = 135 where express_id in (33, 235, 237) and business_source = 0 and step = 0 and content = 'Out For Delivery' order by content; I executed it,…
phinche
  • 93
  • 5
0
votes
1 answer

How can I figure out ORA-00900 invalid SQL statement in datagrip

Normally, using show errors can solve this problem in SQL*PLUS. However executing show errors in datagrip will show Nothing to run, and executing a procedure which has invalid SQL statement only shows error invalid SQL statement. So I can't figure…
ribilynn
  • 460
  • 5
  • 21
0
votes
2 answers

Run write sql queries with caution in DataGrip

Is there any flag in DataGrip that enables showing caution message of running write SQL queries(UPDATE/INSERT/DELETE). E.g. saying that Reason: it's so easy to run queries in DataGrip with Cmd+Enter and not paying attention what query you are…
vishes_shell
  • 22,409
  • 6
  • 71
  • 81
0
votes
1 answer

Database creation and double checking for mistakes

I created a database in one of my project but I'm not sure if I still doing it right. I'm still learning sql and I stuggle in some of the tables I make. The operations are the following. I can add officer with it's assign division. I have to check…
Larigyn
  • 115
  • 1
  • 2
  • 12
0
votes
1 answer

What DataGrip SQL Dialect is closest to BigQuery STANDARD SQL (SQL 2011)

Google claims that BigQuery Standard SQL is closest to SQL 2011. When using DataGrip (or similar platform), what SQL Dialect would match closest to the Standard SQL dialect that BigQuery uses? DB2 Derby H2 HSQLDB MySQL Oracle Oracle…
jasonsirota
  • 4,003
  • 3
  • 17
  • 15
0
votes
1 answer

How to connect to remote MySQL database with JetBrains DataGrip

I've installed MySQL database server on Ubuntu Server 16.04 virtual machine. I've created a new database called Test: CREATE DATABASE IF NOT EXISTS Test; I also created new remote user 'test' and gave him privileges on that database: CREATE USER…
devaerial
  • 2,069
  • 3
  • 19
  • 33
0
votes
1 answer

How to connect to a embedded Derby database?

I am using Netbeans and a embedded Derby database in a small Java project. I would like to see the structure and data of the database as when I use PgAdmin or DataGrip with PostgreSQL databases. It is my first time using and embedded database so I…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88