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
0 answers

How to change DataGrip settings so that it detects double quotes as strings instead of columns?

I just started using Jetbrains DataGrip at work for Sybase DB developement. All the developement is done using ASE ISQL or RapidSQL. they both accept select "test" as valid command and print test but if i run the same command in DataGrip it detects…
Gurbakhshish Singh
  • 1,034
  • 1
  • 10
  • 25
0
votes
0 answers

Print log in 0xdbe output

I want to know how to print log in 0xdbe console. For exemple, I'm running a plpgsql script using raise notice, but the notice is printed only after the script finished. DO language plpgsql $$ DECLARE BEGIN raise notice 'please datagrip,…
HenioJR
  • 604
  • 1
  • 10
  • 17
-1
votes
1 answer

Can't connect Postgres through DataGrip On Mac M1 Pro

I created a pg container using docker run --name pg -e POSTGRES_PASSWORD=123456 -p 5432:5432 -d postgres and I could connect it by psql, see above: But I can't connect it by DataGrip, Why? the error in the picture is above: DBMS: PostgreSQL (ver.…
Lix Li
  • 1
  • 1
-1
votes
1 answer

SQL - Trickle down an overpayment to the following months

I have a table in amazon redshift (datagrip) like…
Anonymous
  • 440
  • 3
  • 14
-1
votes
1 answer

Trying to create a SQL query for a repair database

I am trying to create a query that returns the list of works performed by ewere or Daria in the period from 01.01.2014 to 01.02.2014 or in the period from 01.05.2014 to 01.06.2014 or basically any date period. The list must contain a description of…
wily.x.x
  • 11
  • 4
-1
votes
1 answer

How to copy/display SQL query results as JSON in JetBrains DataGrip

How to copy or display SQL query results as JSON in JetBrains DataGrip? Thanks in advance.
Vinay Kumar
  • 386
  • 2
  • 8
-1
votes
1 answer

Error in SQL syntax when trying to create function

I'm currently learning about SQL functions and have encountered a problem I don't know how to solve. So I'm supposed to create a function that has three parameters, a month, year and amount. It's supposed to return a count of every payment amount…
Murkyu
  • 1
-1
votes
1 answer

Is there any way to ignore these SQL warnings on DataGrip?

I use DataGrip as an IDE for Google BigQuery. DataGrip has a warning pane that warns about items that are frivolous. An example below, "Unable to resolve column 'DAYS_DIFF_CURRENT_ETA', this is occurring because I capitalized the word when I was…
Jaskeil
  • 1,044
  • 12
  • 33
-1
votes
1 answer

I'm getting "Unknown setting session_id" while connecting to ClickHouse from IDE DataGrip

I'm trying to connect to ClickHouse from IDE DataGrip. But that doesn't work and I'm receiving this error: Code: 115, e.displayText() = DB::Exception: Unknown setting session_id, e.what() = DB::Exception. How would be possible to solve this? Could…
YISIO
  • 1
-1
votes
1 answer

Linux (POP OS) JetBrains applications has no top toolbar?

So I just installed Pop OS to my system, but notice, that neither of JetBrains apps has a top toolbar. Firstly, it's just a dark line, but after some time it just disappears. Tried to install the software in a different ways, but got the same…
Fireflies
  • 67
  • 5
-1
votes
1 answer

"SCRIPT TO..." option in Datagrip?

Decided to pick up Datagrip for my Postgres database. I've worked with SSMS/MS SQL-Server a lot, and one of the nice things about SSMS is the option to select a table and then a menu option called "SCRIPT TO..." and it'll give another list of…
user9754798
  • 363
  • 3
  • 15
-1
votes
1 answer

DATAGRIP SQL editor doesn't erase statements after being executed

I have a bit of a problem with my DATAGRIP SQL IDE. When i run any type of a statement, for example, lets say, SHOW DATABASES; in the lower part of the IDE - the console, i get the query results, but in the upper part of the IDE where i write the…
Dimitar
  • 1
  • 1
-1
votes
1 answer

Remote postgres database disconnects frequently on azure

I have installed Postgres(11) on Azure, I am connecting to it using Datagrip client, The problem is it disconnects very frequently and connects back when I run some query, takes nearly 5 seconds to connect back. Here I am attaching a picture of…
-1
votes
1 answer

getting different values, by condition becoming more specific

I have two pieces of code SELECT * FROM etel.ti18n_country inner join etel.ti18n ON id_i18nid = i18nid WHERE id_countryid = 1 and SELECT * FROM etel.ti18n_country inner join etel.ti18n …
Mimeer
  • 81
  • 1
  • 9
-1
votes
1 answer

how to export and import MySQL schema in a single file by DataGrip IDE

I am new in DataGrip IDE . how to do this
Man
  • 742
  • 1
  • 6
  • 23
1 2 3
45
46