DataGrip 2022.2: The option to import multiple CSV files, New Modify UI, Playground and Script resolve modes, and more!
Hello, We’ve just released the second major update of 2022. Here’s a list of all the improvements introduced in 2022.2. For detailed descriptions of all new features and enhancements, please visit our What’s new page. The option to import multiple CSV files You can now select several CSV files and import them at once! Playground and Script resolve modes We’ve introduced two resolve modes, Playground and Script, to ensure greater precision when resolving database objects in SQL scripts. Code generation Categories in the keymap We re-arranged the structure
Top 10 DataGrip shortcuts to empower your coding
We love shortcuts. They make coding faster and more efficient. But they are not always easy to remember. With that in mind, we’ve put together a list of our top-10 most useful DataGrip shortcuts. Execute statement: Cmd/Ctrl+Enter Click the statement or select the fragment of code that you want to execute. It can be a subquery or a group of statements. Press Cmd/Ctrl+Enter. DataGrip executes the whole statement or only the selection if you’ve highlighted a fragment of code. If there are several statements, a list of suggestions appears and you can choose which one to execute. It always
DataGrip 2022.1: Copying multiple objects, New logic for canceling statements and stopping connections, Editing results in MongoDB
Hello, We’ve just released the first major update of 2022. Here’s a list of all the improvements introduced in 2022.1. For detailed descriptions of all new features and enhancements, please visit our What’s new page. Import/Export Copy multiple objects Data editor Introspection Code generation New version of Modify TableQuality improvements for old Modify Table Database diff viewer Swap source and target Code editor Running queries Canceling running statementsCanceling connections IDE General Reworked settingsEv
Working with source codes in DataGrip
Basics The source code of the object is the core part of the DDL script which is needed to create this object. In other words, the CREATE statement is not part of the object's source code. The source code is stored inside the database. The most common objects found with the source code are views, functions, and stored procedures.In many other tools, to update the source code, you would need to generate the CREATE OR REPLACE script, make the required changes and run it. In DataGrip it works a little differently. You just need to make the changes you need to make and the proper script will be
Datalore: 5 Techniques for Insightful Analytics With SQL
What if your data insights could reach a wider audience and help you drive your company’s growth? Read this blog post to learn about 5 modern techniques you can use to upgrade your SQL analytics skills!
DataGrip 2022.1 EAP Has Started!
Hello, Our first release this year is under heavy development, and we're glad you're here to try out the latest features and share your feedback with us. This is the first build of the DataGrip 2022.1 Early Access Program. Let’s take a look! Import/Export Copy multiple objects This is undoubtedly the highlight of this release. You can now select multiple tables and copy them to another schema.Select the tables and press F5 to open the export dialog. As with exporting a single table, you can map the columns, see the DDL of the new table, and change it. As you may
Top 8 DataGrip Database Explorer Features You Have to Know
JetBrains DataGrip is a powerful tool for working with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases and DDL data sources.
DataGrip 2021.3 EAP Is Open
Hello! We have begun our DataGrip 2021.3 EAP and there is something really exciting inside. Data editor Aggregates We’ve added the ability to display an Aggregate view for a range of cells. This is a long-awaited feature that will help you manage your data and that will spare you from having to write additional queries! This brings our data editor step closer to Excel and Google Spreadsheets! Select the cell range you want to see the view for, then right click and select Show Aggregate View. Quick facts: It shares the panel with Value view: now you have tw
DataGrip 2021.2: Creating DDL data sources from real ones, Better diagrams, Search in Local History
DataGrip 2021.2 is here! This is the second major update of 2021, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. DDL data source Generation from a real data sourceCreating objects Diagrams Table comments are now visibleTable colors are also displayed on the diagramAbility to turn off edge merges Code editor Search in Local HistoryLocal History for sourcesLong tab names are backMaximize Editor / Normalize Splits action Code co
Don’t Lose Your Work! Stay Safe With DataGrip
We’ve all been in situations where we thought we lost something forever, a text file or a photo, perhaps. But then somehow we found a way to recover it. The relief you feel in that moment can stay with you for a long time. DataGrip can be a really powerful tool for recovering your queries, even if it can't recover all your data. Read on to learn about what it can do. Query history DataGrip saves all the queries you run. To view the query history for the current data source, click the Clock button on the console's toolbar. Text search is available in this window to help you fi
DataGrip 2021.1: UI for grants, Context Live Templates, Edit Data in MongoDB and More!
Today we’re introducing DataGrip 2021.1, our first major release this year and possibly the most remarkable release in the history of our IDE. We hope you will find that v2021.1 addresses at least one of your pain points, or maybe you will discover a new feature you’ll love or both. Let’s dive in! UI for grants Grants can be modified from the Modify object and Modify user/role dialogs. This feature is available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, SQL Server, and Sybase. Context live templates Select first N rows from a table and many other templates for code gener
Query Book in DataGrip
People often ask us: – Do you have a query book? I have numerous queries I run time after time. I want to store them and to be able to call any of them when I want. There's an issue for this feature in our DataGrip issue tracker. While we don't have a feature specifically named query book, we believe there are approaches you can take with DataGrip that cover the majority of these needs: live templates; run configurations; one file with all queries; separate query files. Let's take a look at them. Live templates Generally, live templates are created for situations where you just need to use a