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 execut
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
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!
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.
Transition from SSMS to DataGrip: 10 tips
This post is for people familiar with SQL Server Management Studio who have decided to try DataGrip with SQL Server. Some concepts, pieces of the user interface, and shortcuts differ between these two tools. We'd like to try and help you with this transition! TLDR: table SSMSDataGripConnects to any running serverTCP/IP and SQL Server Browser should be enabledAll databases and schemas are sho
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 D
DataGrip overview video
🔥 Important content!We’ve released the DataGrip overview video, covering all the major capabilities of our IDE. We bet you’ll learn something new today!No matter how experienced of a DataGrip user you are, there’s always room for improvement.
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 temp
Introducing MongoDB Shell in DataGrip
Hi! We've released the new version of the MongoDB JDBC driver, which means that DataGrip now includes support for the new MongoDB Shell out of the box. This is the result of a close collaboration between engineering teams at MongoDB and JetBrains, and we are excited to finally release it to all our users. If you use DataGrip to work with MongoDB and Atlas, you get a console/shell experience that
Top 9 Spreadsheet Features of DataGrip You Have to Know
JetBrains DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP When you work with databases, you’re exploring the data contained in them. And there are times you’ll want to manipulate that data without having to write queries. DataGrip has your needs covered with its sma
Top 9 SQL Features of DataGrip You Have to Know
DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP One of the most important activities for anyone working with databases is writing SQL. Built on IntelliJ Platform, DataGrip makes coding an enjoyable experience by automating repetitive tasks: as an SQL developer, you probably h
Working with files in DataGrip
People working with databases write SQL. A lot of SQL. In this post, we’ll go over whether it’s better to just use a temporary SQL editor in DataGrip or if it's more convenient to work directly with SQL files stored on your computer. Spoiler: it all depends on your needs. You might already have a working directory with tons of scripts; we will tell you how you can use DataGrip to deal with them t