CSV

Hello! Here are some improvements from the next build for the DataGrip 2020.1 EAP CSV file type DataGrip now has a registered *.csv file type. This means that you will no longer get a notification about CSV supporting available plugins. DataGrip also has the ability to edit CSV files as tables. You will see a floating toolbar with the Edit as Table button. If you click this button and define the CSV format in the corresponding dialog, then the editable table with the content of your CSV file will open. Two tabs for the file become visible: Text and Data. Easy navigation to Execute setting

Hello!  From this post you'll find out what's new in DataGrip 2017.1. It is a long read, so let's begin with the table of contents. Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid. Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database. Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option;  Settings for Qualifying objects and more. Database objects: Double-cliсk ope

Hello! It’s time for the new EAP build for 2017.1 which is going to be released later this March. There are several notable features, let’s take a look at them. Schema management We are still working on the schema selection UI. Now it’s a tree with the ability to choose the current schema. Of course, if the current schema is changed in some other place, DataGrip will show the new one. The Schemas tab comes back to the data source properties dialog. We added the Pattern field where you can describe what you want to be introspected. The Ctrl+Q (Ctrl+J for OSX) shortcut will give you

Hello! The new year has already brought us a new version of DataGrip, as today we start the Early Access Program for DataGrip 2017.1. Everybody can try this free build and take the new possibilities for a spin: - Сolumns mapping in CSV - Drag-n-drop tables - Smart options for SQL editing - Code insight - SQLite introspection - Miscellaneous Let’s see what these enhancements are about. Сolumns mapping in CSV import Many users have asked us to make the import process more flexible. It frequently happens that the number of columns in a .csv file is not the same as in the target table

Hello, everybody! We are excited to release DataGrip 2016.2 and this version brings many interesting features. As usual, we thank all our early adopters who helped us make the IDE better during this release cycle. What is in DataGrip 2016.2? tl;dr: UI for importing CSV files, JSON and XML support in literals, regular expressions checking, dynamic SQL support, completion in tables, keyboard layout aware completion, recompile packages in Oracle, search path support for PostgreSQL and much more. Let's look closer. Database view Some changes happened to the instrospector. We've replac

We are rapidly approaching the 2016.2 release in July. In the meantime, for those who are impatient to try the new features, we've got a new EAP build. Lots of people told us that the current way of importing CSV files (with the help of Edit As Table) was not very convenient. You asked, we delivered! Enjoy a dedicated UI for importing CSV, TSV (well, DSV) files to the database. Click the schema you want import data to, and choose Import From File... from the context menu. Then choose the CSV file where your data is. You will see the Import dialog window. The left-hand panel is for

Here's a a quick bugfix DataGrip update, bringing you some nice stuff to try right away. Parameterized query plan can now be explained in Oracle without providing parameter values: CSV extractor now quotes values properly, making it simpler to import CSV files. Have a watch of this short video tutorial: https://youtu.be/MtrimePA58U Please use the Check for Update menu command, or download the latest DataGrip 1.0.3 setup from our website. Сheck the release notes for the complete list of changes. The DataGrip team _ JetBrains The Drive to Develop