Nextсloud Performance Hacks with EverSQL and DataGrip
Hi, I'm Pasha. In my everyday life, I'm a Developer Advocate for data engineering, but by night, I'm a geek. Like, a really geeky geek! I have used Linux since 2009 as my primary OS (BTW I use Arch). If possible, I always prefer to host everything I use. So if you decide to drop me an email at email@example.com, rest assured, I’ll receive it on my self-hosted mail server. While self-hosting certainly has its benefits, it does have some downsides, like poorer performance, that should be addressed.This is the story of how I “fought” with self-hosted MySQL to get better database performance. Nex
Not All Databases/Schemas Are Displayed by Default. Why?
There is one thing which makes DataGrip different from many other database tools: DataGrip doesn't show all schemas and databases by default in the database explorer. In this post we'll briefly describe why it's designed like this and what you can do if this doesn’t suit your workflow. The most important thing about DataGrip is that the essence of its work concerns database introspection. Introspection is the process where DataGrip loads the metadata for all the database objects and then uses this metadata for coding assistance and navigation. By default, all schemas shown in the databas
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
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!
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 shown by defaultYou need to manually select which databases and schemas are visibleDefault SQL editor: a file that needs to be savedDefault SQL editor: a query console that is saved automaticallyRun quer
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 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 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
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 is 100% consistent with what you get in MongoDB’s own shell and other MongoDB developer tools. To use the newest version of the driver, just update it in the properties window of your MongoDB data so
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 smart data editor, a mini spreadsheet right inside your IDE. Let’s take a closer look at some of the data viewing and editing perks inside DataGrip. 1. Data search When working with a table, enter a fil