James Kovacs

Follow New posts New posts and comments

Edited October 18, 2017 21:11

Amen! After two weeks with DG, I've given up on it and have gone back to what I was using. P.S. Thank you for mentioning HeidiSQL--just now I downloaded and installed it.

1. Community
2. DataGrip
3. DataGrip not fit for purpose with MariaDB/MySql!

• 0 votes

Created October 18, 2017 04:52

File -> Settings... -> Editor -> Color Scheme -> Database -> Console -> Statement to execute -> untic "Effects" You can also change the Effects via the drop-down option list. BEFORE: AFTER:

1. Community
2. DataGrip
3. Box around SQL code

• 8 votes

Created October 07, 2017 00:33

Well you may want to try File -> Settings... -> Editor -> Code Style -> SQL and tic the "Disable formatting" option on one of more of the six tabs.

1. Community
2. DataGrip
3. Annoying parentheses while generating DDL

• 1 vote

Edited October 06, 2017 22:33

To your first point: my experience has been this--upon opening a .txt file internally formatted as CSV containing fields with text, integers, phone numbers, years, and dates: when the structure was...

1. Community
2. DataGrip
3. How to load all my columns as TEXT and How to load multiple files at the same time?

• 0 votes

Created October 06, 2017 20:22

One way to do what you want is: 1) Export the one or more tables as CSV or TSV or HTML or plain text (.txt). 2) Use Beyond Compare ( https://www.scootersoftware.com/features.php?zz=features_list ) ...

1. Community
2. DataGrip
3. Comparing multiple tables in Datagrip

• 0 votes

Created October 06, 2017 03:55

You can extend the DataGrip functionality by writing one or more custom scripts; see https://www.jetbrains.com/help/datagrip/extending-the-datagrip-functionality.html  

1. Community
2. DataGrip
3. Strip char set when exporting to file

• 2 votes

Created October 06, 2017 03:13

Click the DDL box in located in the upper right corner of the view, next to "HTML Table," Dump Data, Export to Database, and View Query. Alternately, right-click the table name and select one of th...

1. Community
2. DataGrip
3. Quick Documentation - View Source of View

• 0 votes

Created October 06, 2017 02:38

If the field is defined to be NOT NULL then "Set NULL" is not available. What is available in this case is "Set Default" (Ctrl+Alt+D). However if the field allows a NULL value then "Set NULL" is av...

1. Community
2. DataGrip
3. How to set a field to NULL?

• 3 votes